Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
AND (`town`.`coords` > ""
AND `town`.`way` > ""
A' at line 71
The SQL being executed was:
SELECT `town`.`town_id` AS `id`,
`town`.`name` AS `name`,
`townUri`.`value` AS `promo1_code`,
`town`.`way_id` AS `wayid`,
`town`.`distance` AS `km`,
`town`.`segment` AS `segment`,
`town`.`coords` AS `geo`,
`town`.`way` AS `way`,
`townInSearch`.`value` AS `inSearch`,
`town`.`opts_json` AS `opts_json`,
COUNT(DISTINCT `fields`.`dom_id`) AS `countFieldsOffers`,
min(cast(ifnull(villaStdCurrencyRatio.value, `villa`.`own_currency_ratio`) * `villa`.`price` AS decimal)) AS `minprice`,
max(cast(ifnull(villaStdCurrencyRatio.value, `villa`.`own_currency_ratio`) * `villa`.`price` AS decimal)) AS `maxprice`,
min(cast(`villa`.`land_square` AS decimal)) AS `minsquare`,
max(cast(`villa`.`land_square` AS decimal)) AS `maxsquare`,
min(cast(`villa`.`house_square` AS decimal)) AS `minhsquare`,
max(cast(`villa`.`house_square` AS decimal)) AS `maxhsquare`,
group_concat(DISTINCT `villa`.`kind` ORDER BY 1) AS `kinds`,
count(DISTINCT `villa`.`dom_id`) AS `offers`,
`ready`.`value` AS `ready`,
`url`.`value` AS `url`,
`url_real`.`value` AS `url_real`,
`promo1_material`.`value` AS `promo1_material`,
`hide_video`.`value` AS `hide_video`,

`promo1_text`.`value` AS `promo1_text`
FROM `cache_aggregators_promo` as `town`
LEFT JOIN `cache_aggregators_dom` as `villa`
ON `villa`.`promo_id` = `town`.`town_id` AND `villa`.`enabled` = 1 AND `villa`.`status` <> 3 AND (secret <> 1 OR secret IS NULL)
LEFT JOIN `currency` `villaStdCurrencyRatio`
ON (`villaStdCurrencyRatio`.`num_code` IN (1,840,978))
AND ((`villa`.`currency`,`villaStdCurrencyRatio`.`num_code`) IN ((0,840), (1,1), (2,978)))
LEFT JOIN `promo_resource` `townRes`
ON `town`.`realestate_id` = `townRes`.`realestate_id`
LEFT JOIN `promo_data` `townTags`
ON (`town`.`town_id` = `townTags`.`promo_id`)
AND (`townTags`.`prop_id`=615)
LEFT JOIN `promo_data` as `townUri`
ON `townUri`.`promo_id` = `town`.`town_id` AND `townUri`.`prop_id` = 128
LEFT JOIN `promo_data` as `townInSearch`
ON `townInSearch`.`promo_id` = `town`.`town_id`
AND `townInSearch`.`prop_id` = 122
LEFT JOIN `cache_aggregators_dom` AS `fields`
ON `fields`.`promo_id` = `town`.`town_id`
AND `fields`.`kind` = 3
AND `fields`.`enabled` = 1
AND NOT (`fields`.`status` = 3)
AND (NOT (`fields`.`secret` = 1) OR `fields`.`secret` IS NULL)
LEFT JOIN `promo_data` AS `ready`
ON `ready`.`promo_id` = `town`.`town_id`
AND `ready`.`prop_id` = 120
LEFT JOIN `promo_data` AS `url`
ON `url`.`promo_id` = `town`.`town_id`
AND `url`.`prop_id` = 16
LEFT JOIN `promo_data` AS `url_real`
ON `url_real`.`promo_id` = `town`.`town_id`
AND `url_real`.`prop_id` = 17
LEFT JOIN `promo_data` AS `promo1_material`
ON `promo1_material`.`promo_id` = `town`.`town_id`
AND `promo1_material`.`prop_id` = 125
LEFT JOIN `promo_data` AS `hide_video`
ON `hide_video`.`promo_id` = `town`.`town_id`
AND `hide_video`.`prop_id` = 158
LEFT JOIN `promo_data` AS `promo1_text`
ON `promo1_text`.`promo_id` = `town`.`town_id`
AND `promo1_text`.`prop_id` = 131

WHERE ((`town`.`realestate_id`=1)
AND (`town`.`parent_id`=0)
AND (`townRes`.`id`="4"))
AND (`town`.`town_id` IN ())
AND (`town`.`coords` > ""
AND `town`.`way` > ""
AND `town`.`distance` > ""
)

GROUP BY `town`.`town_id`
HAVING (`inSearch` = 1) ORDER BY `town`.`rating` DESC, `name` ASC, `km` ASC LIMIT 16

Error Info: Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) 
    	      AND (`town`.`coords` > ""
    	      AND `town`.`way` > ""
    	A' at line 71
)
$_GET = [
    'id' => 'Napoleon',
];