I have a query like this(A one to many relationships)
Camp is related to Campaign
$camp =Camp::where('campaign_id', $cid)->where('weight','!=',0)->lists('weight','id')->toArray()
That would result long sql queries
select `weight`, `id` from `camp` where `campaign_id` = '15' and `weight` != '0'
select `weight`, `id` from `camp` where `campaign_id` = '25' and `weight` != '0'
select `weight`, `id` from `camp` where `campaign_id` = '48' and `weight` != '0'
select weight
, id
from campaign_creatives
where campaign_id
= '20' and weight
!= '0'
select `weight`, `id` from `campaign_creatives` where `campaign_id` = '38' and `weight` != '0'
select `weight`, `id` from `campaign_creatives` where `campaign_id` = '23' and `weight` != '0'
How to make this in one query with multiple campaign_id?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire