General Error
/product/%D0%BC%D0%B0%D1%81%D1%82%D0%B8%D0%BB%D0%BE%D1%81%D1%82%D1%80%D1%83%D0%B9%D0%BD%D0%BE-%D0%BC%D0%BD%D0%BE%D0%B3%D0%BE%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%BE%D0%BD%D0%B0%D0%BB%D0%BD%D0%BE-%D1%83%D1%81%D1%82%D1%80%D0%BE%D0%B9%D1%81%D1%82%D0%B2%D0%BE-canon-pixma-ts9550-all-in-one-black-2988C006AA/10047Error on Query:
SELECT properties.id_categories, property_values.imported_from value_from, properties.imported_from property_from, properties.id_properties, products.id_products, GROUP_CONCAT( DISTINCT properties_lang.name, " ", properties_lang.lang SEPARATOR "||" ) property_name, product_properties.id_product_properties, property_values.id_property_values, product_properties.hide, GROUP_CONCAT( DISTINCT property_values_lang.name, " ", property_values_lang.lang SEPARATOR "||" ) value_name FROM properties LEFT JOIN properties_lang ON ( properties_lang.id_properties = properties.id_properties ) LEFT JOIN product_properties ON ( product_properties.id_properties = properties.id_properties AND product_properties.id_products = "10047" ) LEFT JOIN products ON ( product_properties.id_products = products.id_products ) LEFT JOIN property_values ON ( product_properties.id_property_values = property_values.id_property_values AND property_values.deleted = 0 ) LEFT JOIN property_values_lang ON ( property_values_lang.id_property_values = property_values.id_property_values ) WHERE property_from = "polycomp" AND properties.id_categories = products.id_categories AND properties.deleted = 0 GROUP BY properties.id_properties, property_values.id_property_values, product_properties.id_products ORDER BY properties.priority
Unknown column 'property_from' in 'where clause'
File:
/data/http/xt/inc/_db.php
Line: 101
Debug:SQL Queries:SELECT *,access.id_access FROM access LEFT JOIN access_lang ON (access_lang.lang = "bg" AND access_lang.id_access = access.id_access)
SELECT *,config.id_config FROM config WHERE config.id_config = "core" LIMIT 0,1
SELECT *,currencies.id_currencies FROM currencies LEFT JOIN currencies_lang ON (currencies_lang.lang = "bg" AND currencies_lang.id_currencies = currencies.id_currencies) WHERE currencies.deleted = 0
SELECT *,warranty_types.id_warranty_types FROM warranty_types LEFT JOIN warranty_types_lang ON (warranty_types_lang.lang = "bg" AND warranty_types_lang.id_warranty_types = warranty_types.id_warranty_types) WHERE warranty_types.deleted = 0
SELECT *,config.id_config FROM config WHERE config.id_config = "shop" LIMIT 0,1
DELETE FROM sessions WHERE last_change < 1713426531
UPDATE sessions SET last_change = "1713427431.0687",info = "Продукт",admin_info = "",contact_ip = "3.144.113.197",is_bot = "1",id_contacts = "0",name = "claudebot",page_count = page_count + 1,agent = "claudebot",url = "/product/мастилоструйно-многофункционално-устройство-canon-pixma-ts9550-all-in-one-black-2988C006AA/10047" WHERE name = "claudebot"
SELECT * FROM sessions
SELECT categories.id_categories,categories.hide,categories.expand,credit_disabled,credit_cat,from_end_price,from_dealer_price,categories.siblings,categories.parent_id,GROUP_CONCAT(name SEPARATOR "||") name, GROUP_CONCAT(lang SEPARATOR "||") lang FROM categories LEFT JOIN categories_lang ON (categories.id_categories = categories_lang.id_categories) WHERE categories.deleted = 0 GROUP BY categories.id_categories
SELECT *,categories.id_categories FROM categories LEFT JOIN categories_lang ON (categories_lang.lang = "bg" AND categories_lang.id_categories = categories.id_categories) WHERE top_category > 0 AND categories.deleted = 0 ORDER BY priority
SELECT *,categories.id_categories FROM categories LEFT JOIN categories_lang ON (categories_lang.lang = "bg" AND categories_lang.id_categories = categories.id_categories) WHERE parent_id = 1 AND categories.deleted = 0
SELECT COUNT(*) amount, id_categories FROM products WHERE avail_qty > 0 AND variant_parent_id = 0 AND deleted = 0 GROUP BY id_categories
SELECT *,categories.id_categories FROM categories LEFT JOIN categories_lang ON (categories_lang.lang = "bg" AND categories_lang.id_categories = categories.id_categories) WHERE parent_id = 2 AND categories.deleted = 0
SELECT *,categories.id_categories FROM categories LEFT JOIN categories_lang ON (categories_lang.lang = "bg" AND categories_lang.id_categories = categories.id_categories) WHERE parent_id = 297 AND categories.deleted = 0
SELECT *,categories.id_categories FROM categories LEFT JOIN categories_lang ON (categories_lang.lang = "bg" AND categories_lang.id_categories = categories.id_categories) WHERE parent_id = 3 AND categories.deleted = 0
SELECT *,categories.id_categories FROM categories LEFT JOIN categories_lang ON (categories_lang.lang = "bg" AND categories_lang.id_categories = categories.id_categories) WHERE parent_id = 4 AND categories.deleted = 0
SELECT *,categories.id_categories FROM categories LEFT JOIN categories_lang ON (categories_lang.lang = "bg" AND categories_lang.id_categories = categories.id_categories) WHERE parent_id = 5 AND categories.deleted = 0
SELECT *,categories.id_categories FROM categories LEFT JOIN categories_lang ON (categories_lang.lang = "bg" AND categories_lang.id_categories = categories.id_categories) WHERE parent_id = 6 AND categories.deleted = 0
SELECT *,categories.id_categories FROM categories LEFT JOIN categories_lang ON (categories_lang.lang = "bg" AND categories_lang.id_categories = categories.id_categories) WHERE parent_id = 7 AND categories.deleted = 0
SELECT *,categories.id_categories FROM categories LEFT JOIN categories_lang ON (categories_lang.lang = "bg" AND categories_lang.id_categories = categories.id_categories) WHERE parent_id = 413 AND categories.deleted = 0
SELECT MAX(counter) cnt FROM compare
SELECT credit_disabled,credit_cat,out_warranty_id,buy_price,special_price,delivery,weight,lock_pazaruvaj,end_price,open_packing,products.id_products, products.polycomp_buy, products.polycomp_qty, products.garmin_buy, products.garmin_qty, products.most_buy, products.most_qty, products.asbis_buy, products.asbis_qty, products.vali_buy, products.vali_qty, products.dekada_buy, products.dekada_qty, products.also_buy, products.also_qty, products.timezone_buy, products.timezone_qty, products.edi_buy, products.edi_qty, products.adsys_buy, products.adsys_qty, products.asante_buy, products.asante_qty, products.lancom_buy, products.lancom_qty, products_lang.name, products_lang.warning, products_lang.short, products_lang.description, products.serial_number, products.secondary_sku, products.id_brands, products.imported_from, brands_lang.name bname, products.price, products.id_categories, products.time, ratings.rating my_rating, products.linked, products.secondary_id, products.black_friday, products.promotion, products.end_price, products.avail_qty, products.image, products.rating_count, products.rating, products.available_mode FROM products LEFT JOIN products_lang ON (products_lang.lang = "bg" AND products.id_products = products_lang.id_products) LEFT JOIN brands ON (products.id_brands = brands.id_brands) LEFT JOIN brands_lang ON (brands_lang.lang = "bg" AND brands.id_brands = brands_lang.id_brands) LEFT JOIN ratings on (products.id_products = ratings.id_products AND ip = INET_ATON("3.144.113.197")) WHERE products.id_products = "10047"
SELECT *,categories.id_categories FROM categories WHERE categories.id_categories = "77" AND categories.deleted = 0 LIMIT 0,1
SELECT *,categories.id_categories FROM categories LEFT JOIN categories_lang ON (categories_lang.lang = "bg" AND categories_lang.id_categories = categories.id_categories) WHERE categories.id_categories = "77" AND categories.deleted = 0 LIMIT 0,1
SELECT *,categories.id_categories FROM categories LEFT JOIN categories_lang ON (categories_lang.lang = "bg" AND categories_lang.id_categories = categories.id_categories) WHERE categories.id_categories = "77" AND categories.deleted = 0 LIMIT 0,1
SELECT rating, COUNT(*) votes FROM ratings WHERE id_products = "10047" GROUP BY rating
SELECT * FROM ratings WHERE id_products = "10047" AND ip = INET_ATON("3.144.113.197")
SELECT *,products.id_products FROM products LEFT JOIN products_lang ON (products_lang.lang = "bg" AND products_lang.id_products = products.id_products) WHERE variant_parent_id = "10047" AND avail_qty > 0 AND products.deleted = 0
SELECT * FROM reviews WHERE id_products = "10047"
SELECT products.id_products, products_lang.name, products_lang.short, products_lang.warning, products_lang.description, products.serial_number, brands_lang.name bname, products.price, products.id_categories, products.time, products.polycomp_buy, products.polycomp_qty, products.garmin_buy, products.garmin_qty, products.most_buy, products.most_qty, products.asbis_buy, products.asbis_qty, products.vali_buy, products.vali_qty, products.dekada_buy, products.dekada_qty, products.also_buy, products.also_qty, products.timezone_buy, products.timezone_qty, products.edi_buy, products.edi_qty, products.adsys_buy, products.adsys_qty, products.asante_buy, products.asante_qty, products.lancom_buy, products.lancom_qty, ratings.rating my_rating, products.linked, products.imported_from, products.avail_qty, products.image, products.recommended, products.purchased, products.open_packing, products.views, products.black_friday, products.promotion, products.end_price, products.rating, products.rating_count, products.available_mode FROM products LEFT JOIN products_lang ON (products_lang.lang = "bg" AND products.id_products = products_lang.id_products) LEFT JOIN brands ON (products.id_brands = brands.id_brands) LEFT JOIN brands_lang ON (brands_lang.lang = "bg" AND brands.id_brands = brands_lang.id_brands) LEFT JOIN ratings on (products.id_products = ratings.id_products AND ip = INET_ATON("3.144.113.197")) WHERE serial_number in ("2024C001AA","1970C001AA","2078C001AA","2103C004AA","2106C005AA","2052C004AA","1998C005AA","2106C001AA","2103C001AA","2104C001AA","2105C001AA","2052C001AA","2049C001AA","2050C001AA","2051C001AA","1998C001AA","1995C001AA","1996C001AA","1997C001AA") AND avail_qty > 0 AND variant_parent_id = 0 AND products.price > 0 AND products.deleted = 0 ORDER BY name LIMIT 0,32
SELECT properties.id_categories,property_values.imported_from value_from,properties.imported_from property_from,properties.id_properties,products.id_products,GROUP_CONCAT(DISTINCT properties_lang.name," ",properties_lang.lang SEPARATOR "||") property_name,product_properties.id_product_properties,property_values.id_property_values,product_properties.hide,GROUP_CONCAT(DISTINCT property_values_lang.name," ",property_values_lang.lang SEPARATOR "||") value_name FROM properties LEFT JOIN properties_lang ON (properties_lang.id_properties = properties.id_properties) LEFT JOIN product_properties ON (product_properties.id_properties = properties.id_properties AND product_properties.id_products = "10047") LEFT JOIN products ON (product_properties.id_products = products.id_products) LEFT JOIN property_values ON (product_properties.id_property_values = property_values.id_property_values AND property_values.deleted = 0) LEFT JOIN property_values_lang ON (property_values_lang.id_property_values = property_values.id_property_values) WHERE property_from = "polycomp" AND properties.id_categories = products.id_categories AND properties.deleted = 0 GROUP BY properties.id_properties, property_values.id_property_values, product_properties.id_products ORDER BY properties.priority
SQL Error Code:
1054
Please notify the administrator or webmaster: sand@skycode.com