#0  haltOnError(pdo, SQLSTATE[42S22]: Column not found: 1054 Unknown column 'office_tariffs.type' in 'where clause' ----- Query: SELECT office_tariffs.*, orgs.code as orgCode, orgs.ttl as orgName, orgs.logoid as logoId, bc.title as bc_title, bc.id as bc_id, bc.building_class as bc_building_class,
       EXISTS (
        SELECT 1 FROM files 
        WHERE files.ownerid = office_tariffs.id 
        AND (
            (files.ownertype = 'classic_office_tariff' AND office_tariffs.type = 'classic_office') OR
            (files.ownertype = 'office_tariff' AND office_tariffs.type = 'office')
        )
    ) AS has_photo
    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.building_id AND office_tariffs.building_type="App\\Models\\Org") 
        left join districts on districts.id = office_tariffs.district_id 
        left join business_centers bc on (bc.id = office_tariffs.building_id AND office_tariffs.building_type="App\\Models\\BusinessCenter")
    WHERE office_tariffs.status = 'on' AND (bc.building_class != 'C' OR bc.building_class IS NULL) AND near_office_metro.metroid = 92 AND near_office_metro.min_go <= 70 AND office_tariffs.district_id IN (57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72) AND number_seats >= '2' AND number_seats <= '5' AND office_tariffs.building_class = 'A' AND (orgs.cityid = '1' OR districts.city_id = '1')
        AND (
            (
                office_tariffs.type = 'classic_office'
                AND office_tariffs.building_class IN ('A','A+','B','B+')
            )
            OR (
                office_tariffs.type != 'classic_office'
                AND office_tariffs.building_class IN ('A','A+','B','B+','C','C+')
            )
        )
     ORDER BY
    has_photo DESC,
    IFNULL(NULLIF(FIELD(office_tariffs.building_class, 'A+', 'A', 'B+', 'B', 'C+', 'C'), 0), 999),
    price ASC) called at [/var/www/code/core/func.php:1329]
#1  db(SELECT office_tariffs.*, orgs.code as orgCode, orgs.ttl as orgName, orgs.logoid as logoId, bc.title as bc_title, bc.id as bc_id, bc.building_class as bc_building_class,
       EXISTS (
        SELECT 1 FROM files 
        WHERE files.ownerid = office_tariffs.id 
        AND (
            (files.ownertype = 'classic_office_tariff' AND office_tariffs.type = 'classic_office') OR
            (files.ownertype = 'office_tariff' AND office_tariffs.type = 'office')
        )
    ) AS has_photo
    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.building_id AND office_tariffs.building_type="App\\Models\\Org") 
        left join districts on districts.id = office_tariffs.district_id 
        left join business_centers bc on (bc.id = office_tariffs.building_id AND office_tariffs.building_type="App\\Models\\BusinessCenter")
    WHERE office_tariffs.status = 'on' AND (bc.building_class != 'C' OR bc.building_class IS NULL) AND near_office_metro.metroid = 92 AND near_office_metro.min_go <= 70 AND office_tariffs.district_id IN (57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72) AND number_seats >= '2' AND number_seats <= '5' AND office_tariffs.building_class = 'A' AND (orgs.cityid = '1' OR districts.city_id = '1')
        AND (
            (
                office_tariffs.type = 'classic_office'
                AND office_tariffs.building_class IN ('A','A+','B','B+')
            )
            OR (
                office_tariffs.type != 'classic_office'
                AND office_tariffs.building_class IN ('A','A+','B','B+','C','C+')
            )
        )
     ORDER BY
    has_photo DESC,
    IFNULL(NULLIF(FIELD(office_tariffs.building_class, 'A+', 'A', 'B+', 'B', 'C+', 'C'), 0), 999),
    price ASC) called at [/var/www/code/office/list-officy.php:555]
#2  require(/var/www/code/office/list-officy.php) called at [/var/www/code/office/office.php:24]
#3  require_once(/var/www/code/office/office.php) called at [/var/www/index.php:149]
<b>Sorry, there is a fatal error!</b><br><br>Error reference time: 2025/07/02, 10:53:37<br>