Array
(
[0] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY position' at line 1
)
Array
(
[0] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
)
Array
(
[0] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY position' at line 1
[1] =>
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
)
Array
(
[0] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
[1] =>
[2] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
FROM s_category AS c1
LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
WHERE IFNULL(c1.active,0)=1 AND c1.parent =
)
Array
(
[0] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY position' at line 1
[1] =>
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
[3] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))
WHERE 1=1 AND sp.active = 1 AND IFNULL(sp.hidden,0)=0 AND IFNULL(sp.comi' at line 15
[4] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))
JOIN s_product_extras2s_attribute2s_attribute_value AS spe2sa2sav ON(sp' at line 9
)
Array
(
[0] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
[1] =>
[2] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
FROM s_category AS c1
LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
WHERE IFNULL(c1.active,0)=1 AND c1.parent =
[3] => SELECT COUNT(distinct sp.id) AS cnt,
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price,
MIN(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS min_price
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN ())
WHERE 1=1 AND sp.active = 1 AND IFNULL(sp.hidden,0)=0 AND IFNULL(sp.coming_soon,0)!=1
[4] => SELECT s_attribute2s_attribute_value_id, COUNT(s_attribute2s_attribute_value_id) AS cnt
FROM s_product AS sp
JOIN s_product_extras spe ON(sp.id = spe.product_id )
JOIN s_product_pivot AS pivot ON (sp.id=pivot.product_id AND spe.id=pivot.product_extras_id )
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN ())
JOIN s_product_extras2s_attribute2s_attribute_value AS spe2sa2sav ON(spe.id = spe2sa2sav.s_product_extras_id)
WHERE 1=1
AND sp.active=1
AND IFNULL(sp.hidden,0)=0
AND IFNULL(sp.coming_soon,0)!=1
GROUP BY s_attribute2s_attribute_value_id, spe.product_id
)
Array
(
[0] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY position' at line 1
[1] =>
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
[3] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))
WHERE 1=1 AND sp.active = 1 AND IFNULL(sp.hidden,0)=0 AND IFNULL(sp.comi' at line 15
[4] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))
JOIN s_product_extras2s_attribute2s_attribute_value AS spe2sa2sav ON(sp' at line 9
[5] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))
LEFT JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.languag' at line 9
)
Array
(
[0] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
[1] =>
[2] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
FROM s_category AS c1
LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
WHERE IFNULL(c1.active,0)=1 AND c1.parent =
[3] => SELECT COUNT(distinct sp.id) AS cnt,
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price,
MIN(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS min_price
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN ())
WHERE 1=1 AND sp.active = 1 AND IFNULL(sp.hidden,0)=0 AND IFNULL(sp.coming_soon,0)!=1
[4] => SELECT s_attribute2s_attribute_value_id, COUNT(s_attribute2s_attribute_value_id) AS cnt
FROM s_product AS sp
JOIN s_product_extras spe ON(sp.id = spe.product_id )
JOIN s_product_pivot AS pivot ON (sp.id=pivot.product_id AND spe.id=pivot.product_extras_id )
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN ())
JOIN s_product_extras2s_attribute2s_attribute_value AS spe2sa2sav ON(spe.id = spe2sa2sav.s_product_extras_id)
WHERE 1=1
AND sp.active=1
AND IFNULL(sp.hidden,0)=0
AND IFNULL(sp.coming_soon,0)!=1
GROUP BY s_attribute2s_attribute_value_id, spe.product_id
[5] =>
SELECT sp.id AS id, (is_new+is_action+best_seller) AS defsort
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN ())
LEFT JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id=1)
LEFT JOIN system_url su ON(su.pkey_value = sp.id AND su.table='s_product')
LEFT JOIN system_url_desc sud ON(su.id = sud.system_url_id)
LEFT JOIN s_manufacturer sm ON sp.manufacturer_id = sm.id
LEFT JOIN s_manufacturer_desc smd ON (sm.id = smd.s_manufacturer_id AND smd.language_id = 1)
WHERE 1=1 AND sp.active = 1 AND IFNULL(sp.hidden,0)=0 AND IFNULL(sp.coming_soon,0)!=1 GROUP BY sp.id ORDER BY sp2sc.position ASC LIMIT 0, 40
)
