#0 haltOnError(pdo, 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 'district_id IN (101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112) AND ' at line 5 ----- Query: SELECT office_tariffs.*, orgs.code as orgCode, orgs.ttl as orgName, orgs.logoid as logoId
FROM office_tariffs
left join near_office_metro on near_office_metro.office_tariff_id = office_tariffs.id
left join orgs on orgs.id = office_tariffs.org_id
WHERE office_tariffs.status = 'on' AND near_office_metro.metroid IN ('195') AND min_go <= 10 AND min_go <= 70AND district_id IN (101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112) AND area >= '350' AND area <= '400-m2' AND district_id=13 AND area >= '300' AND area <= '350-m2' AND district_id IN (13, 14, 15, 16, 17, 18, 19, 20, 21, 22) AND area >= '10' AND area <= '15-m2' AND area >= '800' AND area <= '900-m2' AND district_id=149 AND district_id IN (57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72) AND orgs.cityid = '1') called at [/var/www/code/core/func.php:1317]
#1 db(SELECT office_tariffs.*, orgs.code as orgCode, orgs.ttl as orgName, orgs.logoid as logoId
FROM office_tariffs
left join near_office_metro on near_office_metro.office_tariff_id = office_tariffs.id
left join orgs on orgs.id = office_tariffs.org_id
WHERE office_tariffs.status = 'on' AND near_office_metro.metroid IN ('195') AND min_go <= 10 AND min_go <= 70AND district_id IN (101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112) AND area >= '350' AND area <= '400-m2' AND district_id=13 AND area >= '300' AND area <= '350-m2' AND district_id IN (13, 14, 15, 16, 17, 18, 19, 20, 21, 22) AND area >= '10' AND area <= '15-m2' AND area >= '800' AND area <= '900-m2' AND district_id=149 AND district_id IN (57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72) AND orgs.cityid = '1') called at [/var/www/code/office/list-officy.php:646]
#2 require(/var/www/code/office/list-officy.php) called at [/var/www/code/office/office.php:22]
#3 require_once(/var/www/code/office/office.php) called at [/var/www/index.php:153]
Sorry, there is a fatal error!
Error reference time: 2024/11/14, 21:42:54