select top 30 * from (Select fldQSFDID as fldID , qsfc.fldGroupSourceType , (Select top 1 fldDateAdded FROM tblQSystemFeedData FD where FD.fldID = fldQSFDID) as fldSocialStartDate, qsfs.fldIcon , fldObjectFocus, fldMultiIcon, qsfcd.fldID as fldDID , qsfs.fldSingleRecComment, (SELECT fldCache FROM tblQSystemFeedCompressedDataCache where fldQSFCDID = fldQSFDID) as fldCache , fldGroupID, (SELECT fldGroupName FROM tblGroups where fldID = (Select top 1 FD.fldGroupID FROM tblQSystemFeedData FD where FD.fldID = fldQSFDID)) as fldGroupName, (SELECT '/channel.aspx?view=' + fldGroupLinkTag FROM tblGroups where fldID = (Select top 1 FD.fldGroupID FROM tblQSystemFeedData FD where FD.fldID = fldQSFDID)) as fldGroupURL, fldProdID, (SELECT fldName FROM tblProducts where fldID = fldProdID) as fldProdName, (SELECT fldURL FROM tblProducts where fldID = fldProdID) as fldProdURL, fldCompID, (SELECT companyname FROM company_list where companyid = fldcompid) as fldCompanyName, fldWallID, fldBlogID, fldReminderID, fldForumID, fldUserID, fldCCAID, fldNewsletterID, fldEmailCampaignID, fldRegionName, fldSocialEndDate, fldChildCount, fldUniqueMemCount , fldUniqueCompCount , (Select top 1 FD.fldCompID FROM tblQSystemFeedData FD where FD.fldID = fldQSFDID) as fldCompID2 , (Select top 1 FD.fldUserID FROM tblQSystemFeedData FD where FD.fldID = fldQSFDID) as fldUserID2 From tblQSystemFeedCompressed qsfc, tblQSystemFeedCompressedData qsfcd, tblQSystemFeedSource qsfs Where qsfcd.fldQSFCID = qsfc.fldID And qsfc.fldGroupSourceType = qsfs.fldQSource And qsfc.fldHide = 0 And fldSocialStartDate < getDate() union Select yt.fldID, 'youtube-custom' as fldGroupSourcetype, fldDateCreate as fldSocialStartDate, '##COMPANY##' as fldIcon , 'company' as fldObjectFocus , 'zzz' as fldMultiIcon , yt.fldID As fldDID , yt.fldTitle + ' [Watch Video]' as fldSingleRecComment , null As fldCache , null As fldGroupID , null As fldGroupName , null As fldGroupURL , null As fldProdID , null As fldProdName , null As fldProdURL , companyid as fldCompID , companyname As fldCompanyName , null as fldWallID , null As fldBlogID , null as fldReminderID , null As fldForumID , null as fldUserID , null As fldCCAID , null As fldNewsletterID , null As fldEmailCampaignID , '' as fldRegionName , fldDateCreate As fldSocialEndDate , 1 As fldChildCount , 1 As fldUniqueMemCount , 0 As fldUniqueCompCount , cl.companyid As fldCompID2 , null As fldUserID2 From tblYoutube yt, tblYoutubeCompany yc, company_list cl Where fldDateCreate > dateadd("d", -1, getDate()) And fldDateCreate < dateadd("d", 1, fldVideoDate) And yc.fldYoutubeID = YT.fldID And cl.companyid = yc.fldCompanyid And cl.fldRelationToCCIndustry = 10 ) As tblNewTable order by fldSocialStartDate desc

John A. K. Zabula has connected with Esteban Creasey

Member has connected with John A. K. Zabula

Danielle Brannon has connected with John A. K. Zabula

Rippeon Fong has connected with Lucas Fuentes

Pullak Mohanty has connected with Lucas Fuentes

Nedal Khatib has connected with Lucas Fuentes

Rodrigo Borgia has connected with Lucas Fuentes

Roselba Hurtado has connected with Lucas Fuentes

Наталия Золкина has connected with Lucas Fuentes

Al Yap has connected with Lucas Fuentes

Krishna Korlepara (United States) just joined our association! Welcome!

Artificial Intelligence and Tech Solutions (North & South America) - Artificial Intelligence and Tech Solutions – Event to help those looking for solutions to enhance service and reduce cost. Covering AI and other tools to enhance communication. We want to hear whats worked, whats coming up in the near future, will AI replace the agent completely and more.

Sean Hammerle has connected with Arijit Chatterji

Gurjeet Singh has connected with Arijit Chatterji

Sean Hammerle has connected with Yuliya Andreyko

Vishal Singal has connected with Yuliya Andreyko

Vishal Singal has connected with Prem Mungul

Vishal Singal has connected with Lesley Holmes

Tyler Zawacki has connected with Vishal Singal

Arijit Chatterji has connected with Danielle Brannon

Sean Hammerle has connected with Danielle Brannon

Laura Cameron-Crichlow has connected with Danielle Brannon

Grace Heny has connected with Danielle Brannon

Rodrigo Borgia has connected with Craig Rodwogin

Jennifer Schneider is celebrating a work anniversary!

Gaboutlwelwe Seisho is celebrating a work anniversary!

Americas Newsletter - Friday, June 4, 2021 has now been published

Sean Hammerle has connected with Calpunia Sauls

Aisha Kabeja has connected with Calpunia Sauls

Christie Cruz has connected with Wayne Henry