1064 - 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 'or ) and (p2c.categories_id IN(32,70,71,58,10,72,73,42,33,53,62,40,41,43,57,68,' at line 45
select distinct p.products_image, p.products_weight, p.products_weight_horizontal, p.products_weight_square, p.products_model, m.manufacturers_id, p.products_id, p.bwidth_min, p.bwidth_max, p.bdrop_min, p.bdrop_max, pd.products_name, p.products_tax_class_id, pr.product_id , pr.length, p2c.categories_id, p2c.products_id, p.products_max_surface, p2c.sort_bs , c.sort_order, cp.sort_order as sort_cp, ((c.sort_order * IF(p2c.sort_bs < 100, 1000, 10000)) + p2c.sort_bs) as sort_bs2, IF(p.slat_size > 0, p.slat_size, 1000) as slat_size2, p.extra_badges, c.parent_id, (c.sort_order * 10000 + p2c.sort) as sort2,
ROUND((
case CEIL(IF(500 > p.bwidth_max, p.bwidth_max , IF(500 < p.bwidth_min, p.bwidth_min, 500))/100)*100
when 300 then pr.300
when 400 then pr.400
when 500 then pr.500
when 600 then pr.500
when 700 then pr.500
when 800 then pr.500
when 900 then pr.500
when 1000 then pr.1000
when 1100 then pr.1100
when 1200 then pr.1200
when 1300 then pr.1300
when 1400 then pr.1400
when 1500 then pr.1500
when 1600 then pr.1600
when 1700 then pr.1700
when 1800 then pr.1800
when 1900 then pr.1900
when 2000 then pr.2000
when 2100 then pr.2100
when 2200 then pr.2200
when 2300 then pr.2300
when 2400 then pr.2400
when 2500 then pr.2500
when 2600 then pr.2600
when 2700 then pr.2700
when 2800 then pr.2800
when 2900 then pr.2900
when 3000 then pr.3000
when 3100 then pr.3100
when 3200 then pr.3200
when 3300 then pr.3300
when 3400 then pr.3400
when 3500 then pr.3500
when 3600 then pr.3600
when 3700 then pr.3700
when 3800 then pr.3800
when 3900 then pr.3900
when 4000 then pr.4000
else pr.500
end
) * (1-(pds.table_discount / 100)) * ((100 - pds.discount)/100),2) as products_price from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id inner join price_discount pds on pds.product_id = p.products_id and pds.price_table = "price" , products_description pd, products_to_categories p2c, products_options_values pov, products_options_values_to_products_options povtpo, products_attributes pa, price pr, categories c left join categories cp on cp.categories_id=c.parent_id where c.status='1' and (cp.status='1' or cp.status IS NULL) and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p.products_id = pa.products_id and pov.products_options_values_id = pa.options_values_id and pov.language_id = '1' and pov.products_options_values_id = povtpo.products_options_values_id and povtpo.products_options_id = '6' and ( or ) and (p2c.categories_id IN(32,70,71,58,10,72,73,42,33,53,62,40,41,43,57,68,50,60,55,74,75,52,61,65,66,67) and pr.product_id = p.products_id and pr.length = CEIL(IF(1000 > p.bdrop_max, p.bdrop_max , IF(1000 < p.bdrop_min, p.bdrop_min, 1000))/100)*100 ) group by p.products_id order by sort_bs2 asc, p2c.sort asc, pd.products_name
[TEP STOP]
francais
nederlandse
dansk
italiano
español
deutsch
svenska
norsk
