Array
(
    [0] => Unknown column 'pivot.attribute55' in 'on clause'
    [1] => Unknown column 'pivot.attribute55' in 'on clause'
)
Array
(
    [0] => 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 (16,21,185,26,23,22,24,181,139,68,66,65,64,62,59,55,54,53,25,61,188,187,127,60,58,56,63,194,193,192,191,190,189,150,167,186,175,171,169))
		 JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = '1' ) JOIN s_product_pivot AS pivot ON (pivot.product_id=sp.id  AND pivot.attribute55 IN(2608)) WHERE 1=1  AND sp.active = 1 AND spd.name != ''   AND IFNULL(sp.hidden,0)=0  
    [1] => 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  AND pivot.attribute55 IN(2608))
					 JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN (16,21,185,26,23,22,24,181,139,68,66,65,64,62,59,55,54,53,25,61,188,187,127,60,58,56,63,194,193,192,191,190,189,150,167,186,175,171,169))
					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] => Unknown column 'pivot.attribute55' in 'on clause'
    [1] => Unknown column 'pivot.attribute55' in 'on clause'
    [2] => Unknown column 'pivot.attribute55' in 'on clause'
)
Array
(
    [0] => 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 (16,21,185,26,23,22,24,181,139,68,66,65,64,62,59,55,54,53,25,61,188,187,127,60,58,56,63,194,193,192,191,190,189,150,167,186,175,171,169))
		 JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = '1' ) JOIN s_product_pivot AS pivot ON (pivot.product_id=sp.id  AND pivot.attribute55 IN(2608)) WHERE 1=1  AND sp.active = 1 AND spd.name != ''   AND IFNULL(sp.hidden,0)=0  
    [1] => 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  AND pivot.attribute55 IN(2608))
					 JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN (16,21,185,26,23,22,24,181,139,68,66,65,64,62,59,55,54,53,25,61,188,187,127,60,58,56,63,194,193,192,191,190,189,150,167,186,175,171,169))
					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
					
    [2] => 
			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 (16,21,185,26,23,22,24,181,139,68,66,65,64,62,59,55,54,53,25,61,188,187,127,60,58,56,63,194,193,192,191,190,189,150,167,186,175,171,169))
		 	LEFT JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id=1)
						LEFT JOIN s_category sc ON(sc.id = sp2sc.category_id)
						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)
						JOIN s_product_pivot AS pivot ON (pivot.product_id=sp.id  AND pivot.attribute55 IN(2608))
						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, sp2sc.position, id DESC LIMIT 0, 12 
)
35 cm | Aler.si
0
Košarica
0,00 €
0

Košarica je prazna

Brezplačna dostava za nakup nad 35 €