Live Streaming

SELECT dp.name ,dp.combo ,dp.id as id ,dp.faculty_id , dt.name as types,dp.twoviewprice,drive_price,dp.book_type FROM dbm_publication dp join dbm_product_type dt ON dt.id=dp.book_type WHERE dp.flag='1' and dp.status='1' and dp.id>'810' and dp.book_type IN (14,17,9) and (dp.id!='1121' and dp.id!='1422' and dp.id!='1122' and dp.id!='1316' and dp.id!='1317' and dp.id!='1262' and dp.id!='1285' and dp.id!='1126' and dp.id!='1127' and dp.id!='1131' and dp.id!='1138' and dp.id!='1137') Group By dp.id limit 40