Warning: pg_query(): Query failed: ERROR: column price_items.facial_media_id does not exist
LINE 16: price_items.facial_media_id,
^ in /home/users/j/j862685/domains/xdb/core/lib/pgquerys.php on line 177
Invalid pg query: ERROR: column price_items.facial_media_id does not exist
LINE 16: price_items.facial_media_id,
^
in line:
SELECT
price_items.item_id,
price_items.trader_id,
price_items.list_id,
price_items.rownumber,
price_items.type_id,
price_items.producer_id,
price_items.model_id,
price_items.mark,
price_items.item,
price_items.secondhand,
price_items.garanty,
1 AS inventory,
price_items.store,
price_items.price,
price_items.facial_media_id,
price_items.externalurl,
price_items.description,
price_items.card_id,
price_items.pack_width,
price_items.pack_height,
price_items.pack_lenght,
price_items.pack_weight,
price_items.adult_item::int,
price_items.sensitive_item::int,
price_items.card_id,
price_lists.exchangerate,
price_lists.buildtime,
price_lists.lastupdate,
price_lists.itemscount,
price_lists.state,
firm_firms.firm_id,
firm_firms.parentfirm_id,
firm_firms.enabled,
firm_firms.firmname,
firm_firms.trader,
firm_firms.producer, place_cities.city_id,
place_cities.cityname,
place_cities.cityphonecode,
place_cities.gmt,
place_streets.street_id,
place_streets.streetname,
place_streets.streettype_id,
place_places.housenumber FROM firm_firms,
price_lists,
price_items,
firm_place,
place_places, place_cities,
place_streets,
market_firms WHERE price_items.item_id = 873268 AND
price_items.trader_id = price_lists.trader_id AND
price_items.list_id = price_lists.list_id AND
price_items.trader_id = firm_firms.firm_id AND firm_place.firm_id = firm_firms.firm_id
AND firm_place.place_id = place_places.place_id
AND place_places.city_id = place_cities.city_id
AND place_places.street_id = place_streets.street_id AND firm_firms.enabled = TRUE AND firm_firms.firm_id = market_firms.firm_id
AND market_items_agree = true
AND firm_items_agree = true
AND market_id = 27