QUERY = select * from `icodes_vouchers_types` ivtypes where ivtypes.status ='Active' AND ivtypes.`ID` IN ( select Distinct ivt.`icodes_vouchers_types_ID` from `icodes_vtypes` ivt where ivt.`icodes_vouchers_ID` IN ( Select iv.`ID` from `icodes_vouchers` iv where iv.`pricerunner_retailer_index` = )) ;