ERR x1: Unknown column 'it28.value' in 'where clause'
SELECT DISTINCT i.item_color, ct.color_translate FROM ineshop_items i LEFT JOIN ineshop_item_promo ip ON ip.item_code=i.item_code LEFT JOIN ineshop_color_translates ct ON i.item_color=ct.color WHERE i.item_color != '' AND i.item_color IS NOT NULL AND it28.value='False' AND it27.value='False' AND (ip.promo_id='new' ) ERR x2: Unknown column 'it28.value' in 'where clause'
SELECT DISTINCT i.item_size, st.size_translate FROM ineshop_items i LEFT JOIN ineshop_item_promo ip ON ip.item_code=i.item_code LEFT JOIN ineshop_size_translates st ON i.item_size=st.size WHERE i.item_size != '' AND i.item_size IS NOT NULL AND it28.value='False' AND it27.value='False' AND (ip.promo_id='new' ) ERR x3: Unknown column 'it28.value' in 'where clause'
SELECT MIN(a.item_cost) as cost_min, MAX(a.item_cost) as cost_max FROM (SELECT itc.cost AS item_cost FROM ineshop_items i LEFT JOIN ineshop_item_promo ip ON ip.item_code=i.item_code LEFT JOIN ineshop_costs itc ON (i.item_code=itc.item_code AND itc.cost_name='0' ) WHERE TRUE AND it28.value='False' AND it27.value='False' AND (ip.promo_id='new' ) GROUP BY item_id) a ERR x4: Unknown column 'it28.value' in 'where clause'
SELECT DISTINCT pf_ip.parameter_name name,pf_ip.value FROM ineshop_item_parameter pf_ip WHERE EXISTS (SELECT * FROM ineshop_items i LEFT JOIN ineshop_item_promo ip ON ip.item_code=i.item_code WHERE TRUE AND it28.value='False' AND it27.value='False' AND (ip.promo_id='new' ) AND i.item_code=pf_ip.item_code ) AND pf_ip.parameter_name IN ('p_s1','p_barva','p_s2','p_s3') UNION SELECT DISTINCT SUBSTRING_INDEX(pf_it.text_name,'.',1) name,pf_it.value FROM ineshop_item_text pf_it WHERE EXISTS (SELECT * FROM ineshop_items i LEFT JOIN ineshop_item_promo ip ON ip.item_code=i.item_code WHERE TRUE AND it28.value='False' AND it27.value='False' AND (ip.promo_id='new' ) AND i.item_code=pf_it.item_code ) AND pf_it.text_name IN ('p_s1.cs_CZ','p_barva.cs_CZ','p_s2.cs_CZ','p_s3.cs_CZ') ERR x5: Unknown column 'it28.value' in 'where clause'
SELECT icc.category_id FROM ineshop_item_code_categories icc, ineshop_categories c WHERE c.category_id=icc.category_id AND EXISTS (SELECT * FROM ineshop_items i LEFT JOIN ineshop_item_promo ip ON ip.item_code=i.item_code WHERE TRUE AND it28.value='False' AND it27.value='False' AND (ip.promo_id='new' ) AND i.item_code=icc.item_code ) ORDER BY c.priority DESC, c.category_name ERR5: Unknown column 'it28.value' in 'where clause'
SELECT SQL_CALC_FOUND_ROWS DISTINCT i.item_code, i.subcode, i.item_color ,item_name FROM ineshop_items i LEFT JOIN ineshop_item_promo ip ON ip.item_code=i.item_code WHERE it28.value='False' AND it27.value='False' AND (ip.promo_id='new' ) GROUP BY item_code, subcode ORDER BY item_name , item_code LIMIT 0,24 Novinka
0 ks
Košík: 0,00
0 ks