PAGE AND LAYOUT all and fixed_page_onceSELECT campaign_id from ad_daily_campaign where page='all' and layout='fixed_page_once' and is_delete='0' and paused='0' and (ad_start<'23:48:22' and ad_end>'23:50:22') and dated='2025-07-15' and view_remain>0
PAGE AND LAYOUT home and headerSELECT campaign_id from ad_daily_campaign where page='home' and layout='header' and is_delete='0' and paused='0' and (ad_start<'23:48:22' and ad_end>'23:50:22') and dated='2025-07-15' and view_remain>0 SELECT count(ad_id) as count1 from ad_view where campaign_id='4' and created_on like '2025-07-15%' and user_ip='216.73.216.158'
.png)