Warning: pg_query(): Query failed: ERROR: column ozon_price_items.facial_media_id does not exist LINE 25: ozon_price_items.facial_media_id, ^ in /home/users/j/j862685/domains/xdb/core/lib/pgquerys.php on line 177
Invalid pg query: ERROR:  column ozon_price_items.facial_media_id does not exist
LINE 25:    ozon_price_items.facial_media_id,
            ^
in line:
SELECT ozon_price_items.item_id, ozon_price_items.trader_id, -- list_id 0, -- rownumber 0, -- type_id ozon_price_items.description_category_id, -- producer_id 0, -- model_id 0, -- mark ozon_price_items.barcodes, -- item ozon_price_items.name, -- itemrate, 0, -- description ozon_price_items.offer_id, ozon_price_items.xdb_old_price AS old_price, ozon_price_items.xdb_price AS price, -- facial_media_id ozon_price_items.facial_media_id, -- externalurl ozon_price_items.primary_image, -- adult_item 0, -- sensitive_item 0, firm_firms.firmname, to_char(ozon_price_items.updated_at, 'YYYY-MM-DD HH24:MI:SS') AS lastupdate, firm_delivery.city_id, -- platform_id 1 as platform_id, ts_rank(ozon_price_items.itemfts, to_tsquery('(одежда)')) AS weight, char_length(ozon_price_items.name) AS length FROM ozon_price_items -- INNER JOIN price_lists ON price_lists.trader_id = price_items.trader_id AND price_lists.list_id = price_items.list_id INNER JOIN firm_firms ON firm_firms.firm_id = ozon_price_items.trader_id INNER JOIN market_firms ON market_firms.firm_id = ozon_price_items.trader_id INNER JOIN type_typeschildren ON ozon_price_items.type_id = type_typeschildren.childtype_id AND type_typeschildren.type_id = 2884 LEFT JOIN firm_delivery ON firm_delivery.firm_id = ozon_price_items.trader_id AND firm_delivery.city_id = 0 WHERE -- У продавца активная синхронизация firm_firms.ozon_sync_enabled = TRUE AND -- Продавец активен firm_firms.enabled = TRUE AND -- Идентификатор маркетплейса market_firms.market_id = 27 AND -- Маркетплейс выбрал продавца market_firms.market_items_agree = TRUE AND -- Продавец выбрал маркетплейс market_firms.firm_items_agree = TRUE AND -- Количество товара больше 0 0 < ozon_price_items.stocks_present AND to_tsquery('(одежда)') @@ ozon_price_items.itemfts AND (firm_firms.other_city_forbid = FALSE OR firm_delivery.city_id = 0)