Adeeps

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