LINCE

select p.products_model, pd.products_name, left(pd.products_description, 300) products_description, m.manufacturers_name,p.products_image, p.products_brinde_id, p.products_id, p.products_quantity, p.products_envio, p.manufacturers_id, p.products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_date_added , (select CONCAT_WS(";",AVG(rr.reviews_rating),COUNT(*)) from montebla_reviews rr where rr.products_id in (IF(p.products_group, p.products_group, p.products_id))) reviews_rating_average from all_products p left join all_products_description pd on pd.products_id = p.products_id and pd.language_id = '4' left join all_specials s on s.products_id = p.products_id and s.status = 1 left join all_products_to_categories p2c on p.products_id = p2c.products_id left join all_categories c on p2c.categories_id = c.categories_id left join all_manufacturers m on p.manufacturers_id = m.manufacturers_id where m.montebla_manufacturers_status = 1 and c.montebla_categories_status = 1 and p.products_quantity > 0 and p.products_status = 1 and p2c.categories_id in (145,146,147,148,149,150,151) group by p.products_id order by p.products_date_added desc limit 24