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 18
[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' at line 5
[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 '' at line 7
)
Array
(
[0] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
[1] =>
[2] => SELECT
`s_category`.*,
`s_category_desc`.*,
u.linked_from,
IF (u.linked_from>0, (SELECT url FROM system_url_desc WHERE language_id = ud.language_id AND system_url_id = u.linked_from), ud.url) AS url,
IF (u.linked_from>0, u.linked_from, u.id) AS url_id
FROM `s_category`
JOIN `s_category_desc` ON `s_category`.`id` = `s_category_desc`.`s_category_id`
LEFT JOIN system_url AS u ON (u.pkey_value = `s_category`.`id` AND u.`table`='s_category')
LEFT JOIN system_url_desc AS ud ON (u.id = ud.system_url_id AND ud.language_id = 1)
WHERE
`s_category_desc`.language_id = 1
AND `s_category`.`id` =
[3] => SELECT
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock>0 AND sp.active=1)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1=1
[4] => 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 18
[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' at line 5
[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 '' at line 7
[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 '))
WHERE 1=1 AND sp.active = 1 AND IFNULL(sp.hidden,0)=0 AND IFNULL(sp.comi' at line 15
[6] => 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
`s_category`.*,
`s_category_desc`.*,
u.linked_from,
IF (u.linked_from>0, (SELECT url FROM system_url_desc WHERE language_id = ud.language_id AND system_url_id = u.linked_from), ud.url) AS url,
IF (u.linked_from>0, u.linked_from, u.id) AS url_id
FROM `s_category`
JOIN `s_category_desc` ON `s_category`.`id` = `s_category_desc`.`s_category_id`
LEFT JOIN system_url AS u ON (u.pkey_value = `s_category`.`id` AND u.`table`='s_category')
LEFT JOIN system_url_desc AS ud ON (u.id = ud.system_url_id AND ud.language_id = 1)
WHERE
`s_category_desc`.language_id = 1
AND `s_category`.`id` =
[3] => SELECT
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock>0 AND sp.active=1)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1=1
[4] => 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 =
[5] => 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
[6] => 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 18
[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' at line 5
[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 '' at line 7
[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 '))
WHERE 1=1 AND sp.active = 1 AND IFNULL(sp.hidden,0)=0 AND IFNULL(sp.comi' at line 15
[6] => 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
[7] => 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
`s_category`.*,
`s_category_desc`.*,
u.linked_from,
IF (u.linked_from>0, (SELECT url FROM system_url_desc WHERE language_id = ud.language_id AND system_url_id = u.linked_from), ud.url) AS url,
IF (u.linked_from>0, u.linked_from, u.id) AS url_id
FROM `s_category`
JOIN `s_category_desc` ON `s_category`.`id` = `s_category_desc`.`s_category_id`
LEFT JOIN system_url AS u ON (u.pkey_value = `s_category`.`id` AND u.`table`='s_category')
LEFT JOIN system_url_desc AS ud ON (u.id = ud.system_url_id AND ud.language_id = 1)
WHERE
`s_category_desc`.language_id = 1
AND `s_category`.`id` =
[3] => SELECT
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock>0 AND sp.active=1)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1=1
[4] => 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 =
[5] => 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
[6] => 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
[7] =>
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
)
Huawei P40 Pro Plus tokok | Topkinalat telefon tok
