1226 - User 'leshoppijfauth' has exceeded the 'max_questions' resource (current value: 64000)
select
p.products_id,
p.products_quantity,
p.products_quantity_mini,
pd.products_name,
pd.products_name2,
pd.products_description,
p.products_price,
p.manufacturers_id,
p.products_tax_class_id,
p.products_weight,
p.products_divers,
p.products_mesure_status,
p.products_image,
p.products_affect,
p.adh_cart,
p.products_date_available,
p.products_status,
s.specials_new_products_price,
s.status
from
new_cimb_products p
join new_cimb_products_description pd
on pd.products_id = p.products_id
left join new_cimb_specials s
on s.products_id = p.products_id
join new_cimb_products_to_categories p2c
on p2c.products_id = p.products_id
join new_cimb_categories c
on c.categories_id = p2c.categories_id
where
c.cat_status = '1'
and p.products_id = '40'
and p.products_status = 1
and p.products_quantity > 0
and pd.language_id = '4'
[TEP STOP]