Array ( [0] => Unknown column 'pivot.attribute51' in 'on clause' [1] => Unknown column 'pivot.attribute51' 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.attribute51 IN(2244)) 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.attribute51 IN(2244)) 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.attribute51' in 'on clause' [1] => Unknown column 'pivot.attribute51' in 'on clause' [2] => Unknown column 'pivot.attribute51' 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.attribute51 IN(2244)) 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.attribute51 IN(2244)) 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.attribute51 IN(2244)) 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 )
Nakupujte varno in udobno. Kot naš uporabnik imate vpogled tudi v status naročila. Postopek je enostaven, potrebujemo le vaš elektronski naslov in nekaj podatkov.
RegistracijaNakupujte varno in udobno. Kot naš uporabnik imate vpogled tudi v status naročila. Postopek je enostaven, potrebujemo le vaš elektronski naslov in nekaj podatkov.
RegistracijaNakupujte varno in udobno. Kot naš uporabnik imate vpogled tudi v status naročila. Postopek je enostaven, potrebujemo le vaš elektronski naslov in nekaj podatkov.
Registracija