Reply To: Maseter Port Out PIN

[Nishit Shan]

#13804

Hello Andrey,

select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible=’1′) as num from cart_brands b order by b.brandname asc;

This above query inside DB log helped little bit for my bug searching. Although there was not any error but code was using old structure as it was made long time ago , so i have optimised the code and updated with new structure .