QUERY = select iv.* ,ir.`retailer_name` , ir.`retailer_logo` from `icodes_vouchers` iv ,`pricerunner_retailers` ir where DATEDIFF(now(),iv.expiry_date) >1 AND `expiry_date` !='0000-00-00 00:00:00' AND iv.`pricerunner_retailer_index` = ir.`pricerunner_retailer_index` AND iv.`pricerunner_retailer_index` IN ( select icr.`pricerunner_retailers_id` from icodes_cat_retailers icr where icr.`icodes_cat_id` = 5 ) order by iv.start_date DESC,iv.pricerunner_retailer_index 0, 25 ;