select IF(p.pckgcostunit='INR',round(p.pckgCost,0),round(p.pckgCost*69.00,0)) pc, IF(p.pckgcostunit='USD',round(p.pckgCost,0),round(p.pckgCost/69.00,0)) pc_usd , p.*, m.file_name, m.memberID, m.compName, m.yourName, m.paid_status, m.new_mobile_phone, m.contact_visibility_status, m.mobilePhone, m.phone, m.fax, m.memberType, i.pkg_id, i.image, i.title, i.default_img_slno, p.slno, p.pckgTitle from packagetbl p inner join pkg_city_state_cross c on p.slno = c.pkg_id and (c.country = '11889' || c.state = '11889' || c.city = '11889') inner join members m on m.memberID = p.member_id and m.activeStatus in ('Y','B') left join pkg_image i on i.pkg_id = p.slno where p.activeStatus = 'Y' && m.test_status='0' group by p.slno order by p.pkg_paid_status desc, p.pkg_display_date desc desc limit 0, 12
[TEP STOP]