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,
0 AS weight,
0 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 = 5 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 (firm_firms.other_city_forbid = FALSE OR firm_delivery.city_id = 0)