Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT a.id, a.impressions, za.order, za.zone_id
- FROM wp_wpbrads AS a
- LEFT JOIN wp_wpbrzonesads AS za
- ON a.id = za.ad_id
- WHERE a.impressions =
- (SELECT MAX(a.impressions)
- FROM wp_wpbrads AS a
- LEFT JOIN wp_wpbrzonesads AS za
- ON a.id = za.ad_id WHERE a.impressions < '' AND za.zone_id = '11' AND a.active = 'Y'
- AND (a.expiry = '0000-00-00' OR a.expiry >= '2014-03-06')
- AND (a.startDate = '0000-00-00' OR a.startDate <= '2014-03-06')
- AND (a.impressions = 0 OR a.impressions > a.views) AND a.id != '0')
- UNION ALL
- SELECT a.id, a.impressions, za.order, za.zone_id
- FROM wp_wpbrads AS a
- LEFT JOIN wp_wpbrzonesads AS za
- ON a.id = za.ad_id
- WHERE a.impressions =
- (SELECT MAX(a.impressions) FROM wp_wpbrads AS a
- LEFT JOIN wp_wpbrzonesads AS za
- ON a.id = za.ad_id WHERE za.zone_id = '11' AND a.active = 'Y'
- AND (a.expiry = '0000-00-00' OR a.expiry >= '2014-03-06')
- AND (a.startDate = '0000-00-00' OR a.startDate <= '2014-03-06')
- AND (a.impressions = 0 OR a.impressions > a.views) AND a.id != '0')
- ORDER BY impressions ASC LIMIT 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement