#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 (134, 135, 136, 137, 138) AND area >= '700' AND area <= '800-m2' ' 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 (134, 135, 136, 137, 138) AND area >= '700' AND area <= '800-m2' AND area >= '20' AND area <= '25-m2' AND district_id IN (126, 127, 128, 129, 130, 131, 132, 133) AND area >= '40' AND area <= '50-m2' AND district_id=108 AND district_id IN (23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39) AND area >= '60' AND area <= '70-m2' 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 (134, 135, 136, 137, 138) AND area >= '700' AND area <= '800-m2' AND area >= '20' AND area <= '25-m2' AND district_id IN (126, 127, 128, 129, 130, 131, 132, 133) AND area >= '40' AND area <= '50-m2' AND district_id=108 AND district_id IN (23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39) AND area >= '60' AND area <= '70-m2' 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, 11:12:41