IMPORTANT UPDATE: We have taken the decision to close our warehouse for the Christmas Holiday period. Further import restrictions into the country have made the distribution of goods extremely difficult and we have decided to limit the impact on our business by having an extended break.
We wish you all a happy holidays from PreciousLittleOne.
select * from tabProdInCat as t0 join tabProdAttributes as t1 on t0.prodId = t1.apProdId
where (t1.apAttId = 1051 AND t0.prodBrand = 122 AND t0.prodId = t1.apProdId AND t0.prodLive = 'Y')
group by t1.apProdId