Warning (512): SQL Error: 1305: FUNCTION amrpgs21_pro.item_global_rating does not exist [CORE/cake/libs/model/datasources/dbo_source.php, line 684]

Query: SELECT `Item`.`id`, `Item`.`user_id`, `Item`.`plan_id`, `Item`.`country_id`, `Item`.`region_id`, `Item`.`city_id`, `Item`.`visits`, `Item`.`reviews_rating`, `Item`.`reviews_count`, `Item`.`promos_count`, `Item`.`product_services_count`, `Item`.`images_count`, `Item`.`created`, `Item`.`modified`, `Item`.`name`, `Item`.`alias`, `Item`.`logo`, `Item`.`address`, `Item`.`map_status`, `Item`.`lat`, `Item`.`lng`, item_global_rating(Item.reviews_rating, Item.reviews_count) as global_rating, `Plan`.*, `Country`.`id`, `Country`.`url_name`, `Country`.`spa`, `Country`.`region_name_spa`, `Country`.`city_name_spa`, `Country`.`tel_code`, `Region`.`id`, `Region`.`code`, `Region`.`name`, `Region`.`spa`, `Region`.`spa_alias`, `Region`.`tel_code`, `City`.`id`, `City`.`name`, `City`.`spa`, `City`.`spa_alias`, `City`.`tel_code`, `Category1`.`id`, `Category1`.`macrocategory_id`, `Category1`.`name`, `Category1`.`spa`, `Category1`.`spa_alias`, `Category2`.`id`, `Category2`.`macrocategory_id`, `Category2`.`name`, `Category2`.`spa`, `Category2`.`spa_alias`, `Category3`.`id`, `Category3`.`macrocategory_id`, `Category3`.`name`, `Category3`.`spa`, `Category3`.`spa_alias`, `Category4`.`id`, `Category4`.`macrocategory_id`, `Category4`.`name`, `Category4`.`spa`, `Category4`.`spa_alias`, `Category5`.`id`, `Category5`.`macrocategory_id`, `Category5`.`name`, `Category5`.`spa`, `Category5`.`spa_alias`, `Plan`.`id` FROM `items_elsalvador` AS `Item` LEFT JOIN `plans` AS `Plan` ON (`Item`.`plan_id` = `Plan`.`id`) LEFT JOIN `countries` AS `Country` ON (`Item`.`country_id` = `Country`.`id`) LEFT JOIN `regions` AS `Region` ON (`Item`.`region_id` = `Region`.`id`) LEFT JOIN `cities` AS `City` ON (`Item`.`city_id` = `City`.`id`) LEFT JOIN `categories` AS `Category1` ON (`Item`.`category_1_id` = `Category1`.`id`) LEFT JOIN `categories` AS `Category2` ON (`Item`.`category_2_id` = `Category2`.`id`) LEFT JOIN `categories` AS `Category3` ON (`Item`.`category_3_id` = `Category3`.`id`) LEFT JOIN `categories` AS `Category4` ON (`Item`.`category_4_id` = `Category4`.`id`) LEFT JOIN `categories` AS `Category5` ON (`Item`.`category_5_id` = `Category5`.`id`) WHERE `Item`.`reviews_rating` >= 3 AND `Item`.`country_id` = 101 AND `Item`.`region_id` = 101002 AND ((`Item`.`reviews_rating` >= 3) AND (`Item`.`country_id` = 101)) ORDER BY `global_rating` DESC LIMIT 14

Empresas, hoteles, cafes, bars, restaurantes, spas, medicos y servi...

Negocios destacados en en Cabañas, El Salvador

0 Resultados encontrados



Warning (2): Invalid argument supplied for foreach() [APP/views/items/search.ctp, line 92]



Cargando...
Amerpages.com