SELECT * FROM `voice_compaign_summary` WHERE status='V' AND alloted_api=0 AND occupied=0 AND user_voice_plan_id=0 AND compaign_id='3429' LIMIT 1 Total Compaigns:1 3429 AND status=2 AND isDead=0 AND caller_id_type=1 SELECT * FROM voice_sms_api WHERE api_owner_id='admin' AND isDeleted=0 AND status=2 AND isDead=0 AND caller_id_type=1 ORDER BY caller_id_type DESC, todays_credits/channels, rand() LIMIT 1