Adeeps

SELECT * FROM `sunglass_product` WHERE `rx_able`='1' and `combo_offer`='1' AND `id` IN(SELECT DISTINCT `prdt_id` FROM `sunglass_size_price` WHERE `status`='1' and (online_stock>0 OR online_stock!='')) Adeeps