1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1) AS recommended' at line 8 SQL=SELECT @aid:=a.id, a.id, a.title, a.min_capacity, a.max_capacity, a.price_summer, a.price_winter, a.price_summer_type, a.price_winter_type, a.price_summer_period, a.price_winter_period,a.price_summer_food, a.price_winter_food, phones,( SELECT small FROM j25_rjacc_images WHERE accomodation_id=a.id AND summer=1 ORDER BY ordering ASC LIMIT 0, 1) AS photo,( SELECT recommend FROM j25_rjacc_accomodation_recommend WHERE accomodation_id=a.id AND section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1) AS recommended FROM j25_rjacc_accomodations AS a WHERE a.published=1 AND (a.valid_to>='2024-03-29 04:47:33' OR a.valid_to='0000-00-00') AND a.id IN( SELECT accomodation_id FROM j25_rjacc_accomodation_recommend WHERE section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND recommend=1) ORDER BY ( SELECT ordering FROM j25_rjacc_accomodation_ordering WHERE accomodation_id=a.id AND section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1)

Tuto stránku nemůžete navštívit, protože:

  1. zastaralá záložka/oblíbené
  2. vyhledávač, který má zastaralý index tohoto webu
  3. překlep v adrese
  4. na tuto stránku nemáte přístup
  5. Požadovaný obsah nebyl nalezen.
  6. Při zpracování požadavku došlo k chybě.

Vyzkoušejte prosím některou z těchto stránek:

Pokud problémy přetrvávají, obraťte se na správce tohoto webu a nahlaste mu níže uvedenou chybu..

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1) AS recommended' at line 8 SQL=SELECT @aid:=a.id, a.id, a.title, a.min_capacity, a.max_capacity, a.price_summer, a.price_winter, a.price_summer_type, a.price_winter_type, a.price_summer_period, a.price_winter_period,a.price_summer_food, a.price_winter_food, phones,( SELECT small FROM j25_rjacc_images WHERE accomodation_id=a.id AND summer=1 ORDER BY ordering ASC LIMIT 0, 1) AS photo,( SELECT recommend FROM j25_rjacc_accomodation_recommend WHERE accomodation_id=a.id AND section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1) AS recommended FROM j25_rjacc_accomodations AS a WHERE a.published=1 AND (a.valid_to>='2024-03-29 04:47:33' OR a.valid_to='0000-00-00') AND a.id IN( SELECT accomodation_id FROM j25_rjacc_accomodation_recommend WHERE section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND recommend=1) ORDER BY ( SELECT ordering FROM j25_rjacc_accomodation_ordering WHERE accomodation_id=a.id AND section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1)

Call stack
# Function Location
1 JApplicationCms->execute() /home/html/rokytnice.com/public_html/index.php:46
2 JApplicationSite->doExecute() /home/html/rokytnice.com/public_html/libraries/cms/application/cms.php:245
3 JApplicationSite->dispatch() /home/html/rokytnice.com/public_html/libraries/cms/application/site.php:224
4 JComponentHelper::renderComponent() /home/html/rokytnice.com/public_html/libraries/cms/application/site.php:178
5 JComponentHelper::executeComponent() /home/html/rokytnice.com/public_html/libraries/cms/component/helper.php:332
6 require_once() /home/html/rokytnice.com/public_html/libraries/cms/component/helper.php:352
7 JControllerLegacy->execute() /home/html/rokytnice.com/public_html/components/com_rjaccomodation/rjaccomodation.php:17
8 RJAccomodationController->display() /home/html/rokytnice.com/public_html/libraries/legacy/controller/legacy.php:722
9 JControllerLegacy->display() /home/html/rokytnice.com/public_html/components/com_rjaccomodation/controller.php:20
10 RJAccomodationViewAccomodations->display() /home/html/rokytnice.com/public_html/libraries/legacy/controller/legacy.php:685
11 RJAccomodationModelAccomodations->getItems() /home/html/rokytnice.com/public_html/components/com_rjaccomodation/views/accomodations/view.html.php:22
12 JFalangDatabase->loadObjectList() /home/html/rokytnice.com/public_html/components/com_rjaccomodation/models/accomodations.php:224
13 JDatabaseDriver->loadObjectList() /home/html/rokytnice.com/public_html/plugins/system/falangdriver/falang_database.php:278
14 JFalangDatabase->execute() /home/html/rokytnice.com/public_html/libraries/joomla/database/driver.php:1281
15 JDatabaseDriverMysqli->execute() /home/html/rokytnice.com/public_html/plugins/system/falangdriver/falang_database.php:99