SELECT p.*,( select min(price) from product_attribute where pid = p.id ) as `minprice` FROM product p LEFT JOIN product_attribute pa ON pa.pid = p.id LEFT JOIN users u ON u.id = p.vendor_id LEFT JOIN productkeywords pk ON FIND_IN_SET(pk.id,p.keywords_filter) > 0 WHERE p.id <> 0 and p.status = 0 and p.is_deleted = 0 and p.is_blocked = 0 and u.status= 0 and find_in_set ('34', p.subcatefory_id) Group by p.id ORDER BY rand() LIMIT 0,96 Buy Organic Superfoods Online | Buy Healthy Foods,