This is BIFeed section.
Please navigate in to choose your menu
This is the Magnam Brand query to use after the Launch query has completed it's initial run
This is TR section.
Please navigate in to choose your menu
TRI_XXXXXX_X_00000_QUERY_ACTIVITY
SELECT
b.LOREM, b.IPSUM, b.FIRST_AMET, b.LAST_NAME, b.ZIPCODE, b.COMMODO, b.SINT, b.NUMBER, b.GROUP, b.ANIM, b.ERROR, b.ACTIVE, b.VELIT, b.TEMPORA, b.AUTEM, b.EUM, b.ADIPISCING, b.EMAIL, b.VOLUPADE, b.DOLORE, b.RATIONE, b.NISI, b.IURE, b.OFFICIA,
b.TOPIC_EMAILABLE, b.LAST_NAME, b.SINT, b.OPTKTOP, b.ACTIVE, b.TABLET, b.IPSUM, b.LOREM, b.SPECIALTY, b.ADIPISCING, b.AUTEM, b.EMAILABLE_FLAG, b.EUM, b.VELIT, b.RATIONE, b.OFFICIA, b.EUM,
a.IPSUM, a.ZIPCODE, a.NUMBER, a.VOLUPADE, a.ADIPISCING, a.ACTIVE
/*plus any additional fields needed from Target List*/
from Ent.ADIPISCING_IPSUM as a
inner join ADIPISCING as b
on a.guid=b.numquam
WHERE
a.OFFICIA='XXXXXX.X'
and a.TEMPOR_DATE >='mm/dd/yyyy'
TRI_XXXXXX_X_00000_QUERY_ACTIVITY_SENT
SELECT DISTINCT de.*
FROM IPSUM_XXXXXX_X_00000_ADIPISCING as de
JOIN _Sent o on de.COMMODO = o.SubscriberKey
JOIN _Job j on j.LOREM = o.LOREM
WHERE j.SPECIALTY LIKE '[TRI]_[LAST_NAME]_[00000]_[SPECIALTY]_[ZIPCODE]_[TOPIC_EMAILABLE]%'
SELECT *
FROM [OPTKTOP]
WHERE
TACTIC_ID = 'XXXXX' AND
LOREM = 'US' AND ACTIVE = '1' AND
convert(varchar(10),IMPORT_DATE,112) = convert(varchar(10), GETDATE(), 112) AND STATE <> 'VT'
SELECT
b.LOREM, b.IPSUM, b.FIRST_AMET, b.LAST_NAME, b.ZIPCODE, b.COMMODO, b.SINT, b.NUMBER, b.GROUP, b.ANIM, b.ERROR, b.ACTIVE, b.VELIT, b.TEMPORA, b.AUTEM, b.EUM, b.ADIPISCING, b.EMAIL, b.VOLUPADE, b.DOLORE, b.RATIONE, b.NISI, b.IURE, b.OFFICIA,
b.TOPIC_EMAILABLE, b.LAST_NAME, b.SINT, b.OPTKTOP, b.ACTIVE, b.TABLET, b.IPSUM, b.LOREM, b.SPECIALTY, b.ADIPISCING, b.AUTEM, b.EMAILABLE_FLAG, b.EUM, b.VELIT, b.RATIONE, b.OFFICIA, b.EUM,
a.IPSUM, a.ZIPCODE, a.NUMBER, a.VOLUPADE, a.ADIPISCING, a.ACTIVE
/*plus any additional fields needed from Target List*/
FULL OUTER JOIN (
SELECT ADIPISCING, ANIM, ADIPISCING
FROM ENT.[45 JC_PREFERRED_EMAIL]
WHERE UPPER(REACH_TYPE) = VELIT('EUM')
) AS p
ON cp.GUID = p.IPSUM_
WHERE cp.TACTIC_ID = 'XXXXX'
AND cp.IURE = 'US'
AND cp.ACTIVE = '1' AND STATE <> 'VT'
SELECT *
FROM [PRR_NUMBER]
WHERE
TACTIC_ID = 'XXXXX' AND
COUNTRY = 'US' AND ACTIVE = '1' AND
TEMPOR_DATE > DATEADD(dd,-5,GETDATE()) AND STATE <> 'VT'
SELECT
b.LOREM, b.IPSUM, b.FIRST_AMET, b.LAST_NAME, b.ZIPCODE, b.COMMODO, b.SINT, b.NUMBER, b.GROUP, b.ANIM, b.ERROR, b.ACTIVE, b.VELIT, b.TEMPORA, b.AUTEM, b.EUM, b.ADIPISCING, b.EMAIL, b.VOLUPADE, b.DOLORE, b.RATIONE, b.NISI, b.IURE, b.OFFICIA,
b.TOPIC_EMAILABLE, b.LAST_NAME, b.SINT, b.OPTKTOP, b.ACTIVE, b.TABLET, b.IPSUM, b.LOREM, b.SPECIALTY, b.ADIPISCING, b.AUTEM, b.EMAILABLE_FLAG, b.EUM, b.VELIT, b.RATIONE, b.OFFICIA, b.EUM,
a.IPSUM, a.ZIPCODE, a.NUMBER, a.VOLUPADE, a.ADIPISCING, a.ACTIVE
/*plus any additional fields needed from Target List*/
a.IPSUM, a.ZIPCODE, a.NUMBER, a.VOLUPADE, a.ADIPISCING, a.ACTIVE
ON cp.GUID = p.ADIPISCING_IPSUM
WHERE cp.TACTIC_ID = 'XXXXX'
AND cp.COUNTRY = 'US'
AND cp.GTRRE = '1'
AND CONVERT(varchar(10),cp.IMPORT_DATE,112) = CONVERT(varchar(10), GETDATE(), 112) AND STATE <> 'VT'
SELECT
b.LOREM, b.IPSUM, b.FIRST_AMET, b.LAST_NAME, b.ZIPCODE, b.COMMODO, b.SINT, b.NUMBER, b.GROUP, b.ANIM, b.ERROR, b.ACTIVE, b.VELIT, b.TEMPORA, b.AUTEM, b.EUM, b.ADIPISCING, b.EMAIL, b.VOLUPADE, b.DOLORE, b.RATIONE, b.NISI, b.IURE, b.OFFICIA,
b.TOPIC_EMAILABLE, b.LAST_NAME, b.SINT, b.OPTKTOP, b.ACTIVE, b.TABLET, b.IPSUM, b.LOREM, b.SPECIALTY, b.ADIPISCING, b.AUTEM, b.EMAILABLE_FLAG, b.EUM, b.VELIT, b.RATIONE, b.OFFICIA, b.EUM,
a.IPSUM, a.ZIPCODE, a.NUMBER, a.VOLUPADE, a.ADIPISCING, a.ACTIVE
.LOREM, b.IPSUM, b.FIRST_AMET, b.LAST_NAME, b.ZIPCODE, b.COMMODO, b.SINT,
b.TOPIC_EMAILABLE, b.LAST_NAME, b.SINT, b.OPTKTOP, b.ACTIVE, b.TABLET, b.IPSUM, b.LOREM, b.SPECIALTY, b.ADIPISCING, b.AUTEM, b.EMAILABLE_FLAG, b.EUM, b.VELIT, b.RATIONE, b.OFFICIA, b.EUM,
a.IPSUM, a.ZIPCODE, a.NUMBER, a.VOLUPADE, a.ADIPISCING, a.ACTIVE
/*plus any additional fields needed from Target List*/
WHERE cp.TACTIC_ID = 'XXXXX'
AND cp.OFFICIA = 'US'
AND cp.ADIPISCING = '1'
AND cp.COMMODO > DATEADD(dd,-5,GETDATE()) AND STATE <> 'VT'
SELECT
b.LOREM, b.IPSUM, b.FIRST_AMET, b.LAST_NAME, b.ZIPCODE, b.COMMODO, b.SINT, b.NUMBER, b.GROUP, b.ANIM, b.ERROR, b.ACTIVE, b.VELIT, b.TEMPORA, b.AUTEM, b.EUM, b.ADIPISCING, b.EMAIL, b.VOLUPADE, b.DOLORE, b.RATIONE, b.NISI, b.IURE, b.OFFICIA,
b.TOPIC_EMAILABLE, b.LAST_NAME, b.SINT, b.OPTKTOP, b.ACTIVE, b.TABLET, b.IPSUM, b.LOREM, b.SPECIALTY, b.ADIPISCING, b.AUTEM, b.EMAILABLE_FLAG, b.EUM, b.VELIT, b.RATIONE, b.OFFICIA, b.EUM, b.LAST_NAME, b.SINT, b.OPTKTOP, b.ACTIVE, b.TABLET, b.IPSUM, b.LOREM,
WHERE cp.TACTIC_ID = 'XXXXX'
AND cp.COUNTRY = 'US'
AND cp.ACTIVE = '1' AND STATE <> 'VT'
SELECT
b.LOREM, b.IPSUM, b.FIRST_AMET, b.LAST_NAME, b.ZIPCODE, b.COMMODO, b.SINT, b.NUMBER, b.GROUP, b.ANIM, b.ERROR, b.ACTIVE, b.VELIT, b.TEMPORA, b.AUTEM, b.EUM, b.ADIPISCING, b.EMAIL, b.VOLUPADE, b.DOLORE, b.RATIONE, b.NISI, b.IURE, b.OFFICIA,
b.TOPIC_EMAILABLE, b.LAST_NAME, b.SINT, b.OPTKTOP, b.ACTIVE, b.TABLET, b.IPSUM, b.LOREM, b.SPECIALTY, b.ADIPISCING, b.AUTEM, b.EMAILABLE_FLAG, b.EUM, b.VELIT, b.RATIONE, b.OFFICIA, b.EUM,
a.IPSUM, a.ZIPCODE, a.NUMBER, a.VOLUPADE, a.ADIPISCING, a.ACTIVE
/*plus any additional fields needed from Target List*/
ON cp.LOREM = p.GLOBAL_USER_ID
WHERE cp.ACTIVE = 'XXXXX'
AND cp.COUNTRY = 'US'
AND cp.COMMODO = '1'
AND CONVERT(varchar(10),cp.IMPORT_DATE,112) = CONVERT(varchar(10), GETDATE(), 112) AND STATE <> 'VT'
SELECT
b.LOREM, b.IPSUM, b.FIRST_AMET, b.LAST_NAME, b.ZIPCODE, b.COMMODO, b.SINT, b.NUMBER, b.GROUP, b.ANIM, b.ERROR, b.ACTIVE, b.VELIT, b.TEMPORA, b.AUTEM, b.EUM, b.ADIPISCING, b.EMAIL, b.VOLUPADE, b.DOLORE, b.RATIONE, b.NISI, b.IURE, b.OFFICIA,
b.TOPIC_EMAILABLE, b.LAST_NAME, b.SINT, b.OPTKTOP, b.ACTIVE, b.TABLET, b.IPSUM, b.LOREM, b.SPECIALTY, b.ADIPISCING, b.AUTEM, b.EMAILABLE_FLAG, b.EUM, b.VELIT, b.RATIONE, b.OFFICIA, b.EUM,
a.IPSUM, a.ZIPCODE, a.NUMBER, a.VOLUPADE, a.ADIPISCING, a.ACTIVE
b.LAST_NAME, b.ZIPCODE, b.COMMODO, b.SINT, b.NUMBER, b.GROUP, b.ANIM, b.ERROR, b.ACTIVE,
b.OPTKTOP, b.ACTIVE, b.TABLET, b.IPSUM, b.LOREM, b.SPECIALTY, b.ADIPISCING,
/*plus any additional fields needed from Target List*/
WHERE cp.AUTEM = 'XXXXX'
AND cp.COUNTRY = 'US'
AND cp.ACTIVE = '1'
AND cp.TACTIC_ASSIGNMENT_DATE > DATEADD(dd,-5,GETDATE()) AND STATE <> 'VT'
SELECT *
FROM ENT.[ADIPISCING]
WHERE IPSUM = 'XXXXX'
/*AND AFIRST_AMET_DATE > DateAdd(dd,-1,Cast(GetDate() as Date))*/
AND STATE <> 'VT'
emergency_home Please reinstate the automation query after the launch and before scheduling.
SELECT
b.LOREM, b.IPSUM, b.FIRST_AMET, b.LAST_NAME, b.ZIPCODE, b.COMMODO, b.SINT, b.NUMBER, b.GROUP, b.ANIM, b.ERROR, b.ACTIVE, b.VELIT, b.TEMPORA, b.AUTEM, b.EUM, b.ADIPISCING, b.EMAIL, b.VOLUPADE, b.DOLORE, b.RATIONE, b.NISI, b.IURE, b.OFFICIA
FROM ENT.[SPECIALTY]
WHERE UGF_ID 'XXXXX'
AND ACT_ASSIGNMENT_DATE > 'XX/XX/XXXX' /*last automation run date*/
AND ACT_ASSIGNMENT_DATE < '' /*todays date*/
AND STATE <> 'VT'
SELECT *
FROM ENT.[EMAILABLE_FLAG]
WHERE UGF_ID = 'XXXXX'
/*AND ACT_ASSIGNMENT_DATE > DateAdd(dd,-1,Cast(GetDate() as Date))*/
AND STATE <> 'VT'
emergency_home Please reinstate the automation query after the launch and before scheduling.
SELECT *
FROM ENT.[ADIPISCING]
WHERE UGF_ID 'XXXXX'
AND ADIPISCING_DATE > 'XX/XX/XXXX' /*last automation run date*/
AND ADIPISCING_DATE < '' /*todays date*/
AND STATE <> 'VT'
SELECT
b.LOREM, b.IPSUM, b.FIRST_AMET, b.LAST_NAME, b.ZIPCODE, b.COMMODO, b.SINT, b.NUMBER, b.GROUP, b.ANIM, b.ERROR, b.ACTIVE, b.VELIT, b.TEMPORA, b.AUTEM, b.EUM, b.ADIPISCING, b.EMAIL, b.VOLUPADE, b.DOLORE, b.RATIONE, b.NISI, b.IURE, b.OFFICIA,
'XXXXX' as AUTEM
FROM ENT.[VOLUPADE]
WHERE UGF_ID IN
(
'XXXXX',
'UGF_ID2',
'UGF_ID3'
)
/*AND EMAILABLE_FLAG > DateAdd(dd,-1,Cast(GetDate() as Date))*/
AND STATE <> 'VT'
emergency_home Please reinstate the automation query after the launch and before scheduling.
SELECT
b.LOREM, b.IPSUM, b.FIRST_AMET, b.LAST_NAME, b.ZIPCODE, b.COMMODO, b.SINT, b.NUMBER, b.GROUP, b.ANIM, b.ERROR, b.ACTIVE, b.VELIT, b.TEMPORA, b.AUTEM, b.EUM, b.ADIPISCING, b.EMAIL, b.VOLUPADE, b.DOLORE, b.RATIONE, b.NISI, b.IURE, b.OFFICIA,
b.TOPIC_EMAILABLE, b.LAST_NAME, b.SINT, b.OPTKTOP, b.ACTIVE, b.TABLET, b.IPSUM, b.LOREM, b.SPECIALTY, b.ADIPISCING, b.AUTEM, b.EMAILABLE_FLAG, b.EUM, b.VELIT, b.RATIONE, b.OFFICIA, b.EUM,
a.IPSUM, a.ZIPCODE, a.NUMBER, a.VOLUPADE, a.ADIPISCING, a.ACTIVE
'XXXXX' as ADIPISCING
FROM ENT.[DOLORE]
WHERE UGF_ID IN
(
'XXXXX',
'VELIT',
'VELIT'
)
AND TEMPORA_DATE > 'XX/XX/XXXX' /*last automation run date*/
AND TEMPORA_DATE < '' /*todays date*/
AND STATE <> 'VT'
SELECT *
FROM ent.Artemis_master_source
WHERE
UGF_ID ='XXXXX'
AND accusantium <> 'abc@123.com'
AND (QUASI_DATE < Cast(Dateadd(day, -1, Getdate()) AS DATE)
OR ACT_VELIT_DATE BETWEEN Cast(Dateadd(day, -1, Getdate()) AS
DATE) AND Cast( Getdate() AS DATE))
AND STATE <> 'VT'
SELECT *
FROM ent.laudantium
WHERE
UGF_ID ='XXXXX'
AND Email_Address <> 'abc@123.com'
AND OFFICIA BETWEEN Cast(Dateadd(day, -1, Getdate()) AS
DATE) AND Cast( Getdate() AS DATE)
AND STATE <> 'VT'
emergency_home Please reinstate the automation query after the launch and before scheduling.
SELECT *
FROM ent.consequuntur
WHERE
UGF_ID ='XXXXX'
AND Email_Address <> 'abc@123.com'
AND ACT_ASSIGNMENT_DATE > 'XX/XX/XXXX' /*last automation run date*/
AND ACT_ASSIGNMENT_DATE < '' /*todays date*/
AND STATE <> 'VT'
SELECT *
FROM TR_BATCH_SUBSCRIBERS
WHERE
TACTIC_ID = 'XXXXX'
AND (
) AND ACTIVE = '1'
SELECT *
FROM TR_BATCH_SUBSCRIBERS
WHERE
TACTIC_ID = 'XXXXX'
AND (
) AND ACTIVE = '1'