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 ')
WHERE 1 = 1' at line 5
[1] => 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
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price, sp.prices_with_vat, sp.vat_percent_id
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock >= 0 AND sp.active = 1 AND IFNULL(sp.hidden,0) = 0)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1 = 1
[1] => 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 ')
WHERE 1 = 1' at line 5
[1] => 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
[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 'ORDER BY position' at line 1
[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 '' at line 18
[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 ')
WHERE 1 = 1' at line 5
[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 '' at line 7
)
Array
(
[0] => SELECT
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price, sp.prices_with_vat, sp.vat_percent_id
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock >= 0 AND sp.active = 1 AND IFNULL(sp.hidden,0) = 0)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1 = 1
[1] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
[2] =>
[3] => 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` =
[4] => SELECT
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price, sp.prices_with_vat, sp.vat_percent_id
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock >= 0 AND sp.active = 1 AND IFNULL(sp.hidden,0) = 0)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1 = 1
[5] => 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 ')
WHERE 1 = 1' at line 5
[1] => 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
[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 'ORDER BY position' at line 1
[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 '' at line 18
[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 ')
WHERE 1 = 1' at line 5
[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 '' at line 7
[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_desc spd ON (s.id = spd.s_product_id AND spd.language_id' at line 2
)
Array
(
[0] => SELECT
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price, sp.prices_with_vat, sp.vat_percent_id
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock >= 0 AND sp.active = 1 AND IFNULL(sp.hidden,0) = 0)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1 = 1
[1] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
[2] =>
[3] => 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` =
[4] => SELECT
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price, sp.prices_with_vat, sp.vat_percent_id
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock >= 0 AND sp.active = 1 AND IFNULL(sp.hidden,0) = 0)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1 = 1
[5] => 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 =
[6] => SELECT s.manufacturer_id FROM s_product s
JOIN s_product2s_category spc ON (s.id = spc.product_id AND spc.category_id IN ())
JOIN s_product_desc spd ON (s.id = spd.s_product_id AND spd.language_id=1)
WHERE s.active = 1
AND s.manufacturer_id > 0
AND spd.name != ''
GROUP BY s.manufacturer_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 ')
WHERE 1 = 1' at line 5
[1] => 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
[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 'ORDER BY position' at line 1
[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 '' at line 18
[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 ')
WHERE 1 = 1' at line 5
[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 '' at line 7
[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_desc spd ON (s.id = spd.s_product_id AND spd.language_id' at line 2
[7] =>
[8] => 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
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price, sp.prices_with_vat, sp.vat_percent_id
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock >= 0 AND sp.active = 1 AND IFNULL(sp.hidden,0) = 0)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1 = 1
[1] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
[2] =>
[3] => 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` =
[4] => SELECT
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price, sp.prices_with_vat, sp.vat_percent_id
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock >= 0 AND sp.active = 1 AND IFNULL(sp.hidden,0) = 0)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1 = 1
[5] => 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 =
[6] => SELECT s.manufacturer_id FROM s_product s
JOIN s_product2s_category spc ON (s.id = spc.product_id AND spc.category_id IN ())
JOIN s_product_desc spd ON (s.id = spd.s_product_id AND spd.language_id=1)
WHERE s.active = 1
AND s.manufacturer_id > 0
AND spd.name != ''
GROUP BY s.manufacturer_id;
[7] =>
[8] => 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 ')
WHERE 1 = 1' at line 5
[1] => 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
[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 'ORDER BY position' at line 1
[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 '' at line 18
[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 ')
WHERE 1 = 1' at line 5
[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 '' at line 7
[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_desc spd ON (s.id = spd.s_product_id AND spd.language_id' at line 2
[7] =>
[8] => 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
[9] => 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_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = ' at line 8
[10] => 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(spe' at line 6
)
Array
(
[0] => SELECT
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price, sp.prices_with_vat, sp.vat_percent_id
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock >= 0 AND sp.active = 1 AND IFNULL(sp.hidden,0) = 0)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1 = 1
[1] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
[2] =>
[3] => 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` =
[4] => SELECT
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price, sp.prices_with_vat, sp.vat_percent_id
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock >= 0 AND sp.active = 1 AND IFNULL(sp.hidden,0) = 0)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1 = 1
[5] => 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 =
[6] => SELECT s.manufacturer_id FROM s_product s
JOIN s_product2s_category spc ON (s.id = spc.product_id AND spc.category_id IN ())
JOIN s_product_desc spd ON (s.id = spd.s_product_id AND spd.language_id=1)
WHERE s.active = 1
AND s.manufacturer_id > 0
AND spd.name != ''
GROUP BY s.manufacturer_id;
[7] =>
[8] => 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 =
[9] => 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 ())
JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = '1' ) WHERE 1=1 AND sp.active = 1 AND spd.name != '' AND IFNULL(sp.hidden,0)=0
[10] => SELECT s_attribute2s_attribute_value_id, COUNT(s_attribute2s_attribute_value_id) AS cnt
FROM s_product AS sp
JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = '1' )
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 spd.name != ''
AND IFNULL(sp.hidden,0)=0
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 ')
WHERE 1 = 1' at line 5
[1] => 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
[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 'ORDER BY position' at line 1
[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 '' at line 18
[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 ')
WHERE 1 = 1' at line 5
[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 '' at line 7
[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_desc spd ON (s.id = spd.s_product_id AND spd.language_id' at line 2
[7] =>
[8] => 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
[9] => 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_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = ' at line 8
[10] => 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(spe' at line 6
[11] => 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.language' at line 5
)
Array
(
[0] => SELECT
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price, sp.prices_with_vat, sp.vat_percent_id
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock >= 0 AND sp.active = 1 AND IFNULL(sp.hidden,0) = 0)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1 = 1
[1] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
[2] =>
[3] => 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` =
[4] => SELECT
MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price, sp.prices_with_vat, sp.vat_percent_id
FROM s_product sp
JOIN s_product_extras spe ON (sp.id = spe.product_id AND spe.stock >= 0 AND sp.active = 1 AND IFNULL(sp.hidden,0) = 0)
JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id = )
WHERE 1 = 1
[5] => 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 =
[6] => SELECT s.manufacturer_id FROM s_product s
JOIN s_product2s_category spc ON (s.id = spc.product_id AND spc.category_id IN ())
JOIN s_product_desc spd ON (s.id = spd.s_product_id AND spd.language_id=1)
WHERE s.active = 1
AND s.manufacturer_id > 0
AND spd.name != ''
GROUP BY s.manufacturer_id;
[7] =>
[8] => 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 =
[9] => 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 ())
JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = '1' ) WHERE 1=1 AND sp.active = 1 AND spd.name != '' AND IFNULL(sp.hidden,0)=0
[10] => SELECT s_attribute2s_attribute_value_id, COUNT(s_attribute2s_attribute_value_id) AS cnt
FROM s_product AS sp
JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = '1' )
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 spd.name != ''
AND IFNULL(sp.hidden,0)=0
GROUP BY s_attribute2s_attribute_value_id, spe.product_id
[11] =>
SELECT sp.id AS id, (IF(spe.stock > 0, 1, 0)+IF(spe.action_price > 0, 1, 0)+is_new+exposed ) 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 spd.name != '' AND IFNULL(sp.hidden,0)=0 GROUP BY sp.id ORDER BY defsort DESC, spd.name ASC LIMIT 0, 21
)
Pribor in dodatna opreme za stroje | GEDER, servis, trgovina d.o.o.
Vsak vrt je edinstven – zato vam na podlagi ogleda svetujemo katera robotska kosilnica je primerna za vas. Pri ogledu točno določimo območje košnje, najdemo primerno mesto polnilne postaje, svetujemo kako pripraviti vrt, da bo robotska kosilnica karseda učinkovita. Parcelo premerimo in vam pošljemo relevantno ponudbo. Za ogled se obračuna kavcija 50€, katera se v primeru nakupa robotske kosilnice pri nas obračuna v ceni le-te.
