SQL: [2149] SELECT LOWER(tb.keyword) AS keyword,LOWER(tb.displayURL) AS  displayURL,tb.campaignId, tb.cpc, tb.destinationURL, tb.keywordId, tb.advertiserId, tb.accountType, kw.url_feedid, kw.url_keyword, kw.url_clickid, kw.url_traffickw, kw.url_timestamp, kw.url_timestamp_format, kw.url_other_name, kw.url_other_field, kw.url_separator, kw.url_assignment, kw.dlAffiliateUrl, kw.dlAffiliateUrlPara, kw.dlOtherUrlPara, kw.isDeeplink, cp.destinationURL as cp_destinationURL, cp.deviceType, cp.enable_day_parting,  (CASE WHEN cp.enable_day_parting = 1 THEN
                        (SELECT flag FROM `campaign_day_parting` cdp WHERE cdp.campaign_id = tb.campaignId AND cdp.day = :day AND cdp.hour= :hour LIMIT 1) ELSE 'false' END ) AS flag_day_parting,
                        (CASE WHEN cp.enable_day_parting = 1 THEN
                        (SELECT 'true' FROM campaigns WHERE ( ( daypartStartDate IS NULL || daypartStartDate <= CURDATE() ) && (daypartEndDate IS NULL || daypartEndDate >= CURDATE() ) )and id=tb.campaignId )  ELSE 'false' END ) AS date_day_parting , null AS domain_price FROM T_Blending AS tb LEFT JOIN keywords as kw ON tb.keywordId=kw.id LEFT JOIN campaigns AS cp ON tb.campaignId = cp.id WHERE tb.cleaned_keyword=:keyword AND kw.matchtype=0 AND tb.aggregateStatus=1 AND tb.advertiserStatusReason!='IONotLive' AND tb.advertiserStatusReason!='IOInactive' AND tb.advertiserStatusReason!='IONotLinked' AND tb.campaignId NOT IN (SELECT campaignId FROM T_CampaignFeedBlacklist WHERE feedid=:feedid) AND :ip_country IN (SELECT countryCode FROM T_CampaignCountry WHERE campaignId=tb.campaignId) AND tb.campaignId NOT IN (SELECT campaignId FROM T_CampaignStateBlackList WHERE countryCode=:ip_country AND stateCode=:ip_state) AND tb.campaignId NOT IN (SELECT campaignId FROM T_CampaignCityBlackList WHERE countryCode=:ip_country AND stateCode=:ip_state AND city=:ip_city) Having ( (flag_day_parting = 'false' AND date_day_parting = 'false') || (date_day_parting IS NULL) || (flag_day_parting = 1 AND date_day_parting = 'true') ) ORDER BY tb.aggregateStatus DESC, tb.accountType DESC, domain_price DESC, tb.cpc DESC, tb.premiumCounter ASC, RAND() LIMIT 1
Sent SQL: [2122] SELECT LOWER(tb.keyword) AS keyword,LOWER(tb.displayURL) AS  displayURL,tb.campaignId, tb.cpc, tb.destinationURL, tb.keywordId, tb.advertiserId, tb.accountType, kw.url_feedid, kw.url_keyword, kw.url_clickid, kw.url_traffickw, kw.url_timestamp, kw.url_timestamp_format, kw.url_other_name, kw.url_other_field, kw.url_separator, kw.url_assignment, kw.dlAffiliateUrl, kw.dlAffiliateUrlPara, kw.dlOtherUrlPara, kw.isDeeplink, cp.destinationURL as cp_destinationURL, cp.deviceType, cp.enable_day_parting,  (CASE WHEN cp.enable_day_parting = 1 THEN
                        (SELECT flag FROM `campaign_day_parting` cdp WHERE cdp.campaign_id = tb.campaignId AND cdp.day = 'sunday' AND cdp.hour= '7' LIMIT 1) ELSE 'false' END ) AS flag_day_parting,
                        (CASE WHEN cp.enable_day_parting = 1 THEN
                        (SELECT 'true' FROM campaigns WHERE ( ( daypartStartDate IS NULL || daypartStartDate <= CURDATE() ) && (daypartEndDate IS NULL || daypartEndDate >= CURDATE() ) )and id=tb.campaignId )  ELSE 'false' END ) AS date_day_parting , null AS domain_price FROM T_Blending AS tb LEFT JOIN keywords as kw ON tb.keywordId=kw.id LEFT JOIN campaigns AS cp ON tb.campaignId = cp.id WHERE tb.cleaned_keyword='grammarly' AND kw.matchtype=0 AND tb.aggregateStatus=1 AND tb.advertiserStatusReason!='IONotLive' AND tb.advertiserStatusReason!='IOInactive' AND tb.advertiserStatusReason!='IONotLinked' AND tb.campaignId NOT IN (SELECT campaignId FROM T_CampaignFeedBlacklist WHERE feedid=5951) AND 'US' IN (SELECT countryCode FROM T_CampaignCountry WHERE campaignId=tb.campaignId) AND tb.campaignId NOT IN (SELECT campaignId FROM T_CampaignStateBlackList WHERE countryCode='US' AND stateCode='OH') AND tb.campaignId NOT IN (SELECT campaignId FROM T_CampaignCityBlackList WHERE countryCode='US' AND stateCode='OH' AND city='Columbus') Having ( (flag_day_parting = 'false' AND date_day_parting = 'false') || (date_day_parting IS NULL) || (flag_day_parting = 1 AND date_day_parting = 'true') ) ORDER BY tb.aggregateStatus DESC, tb.accountType DESC, domain_price DESC, tb.cpc DESC, tb.premiumCounter ASC, RAND() LIMIT 1
Params:  7
Key: Name: [7] :feedid
paramno=-1
name=[7] ":feedid"
is_param=1
param_type=1
Key: Name: [11] :ip_country
paramno=-1
name=[11] ":ip_country"
is_param=1
param_type=2
Key: Name: [9] :ip_state
paramno=-1
name=[9] ":ip_state"
is_param=1
param_type=2
Key: Name: [8] :ip_city
paramno=-1
name=[8] ":ip_city"
is_param=1
param_type=2
Key: Name: [4] :day
paramno=-1
name=[4] ":day"
is_param=1
param_type=2
Key: Name: [5] :hour
paramno=-1
name=[5] ":hour"
is_param=1
param_type=2
Key: Name: [8] :keyword
paramno=-1
name=[8] ":keyword"
is_param=1
param_type=2
<html><head><meta name="referrer" content="never" /><meta name="referrer" content="no-referrer" /><meta http-equiv="refresh" content="0;URL='https://qa.queryclick.pureleads.com/index_click.php?q=https%3A%2F%2Fwww.safeguide.net&i=shorelineqasearch02-05-11_1730386085_1029333'"  /></head><body></body></html>