INSERT tbl_campaigns (sCampaignName, sSummary, iRatingIDFK, iC02ImpactIDFK) VALUES ('#ARGUMENTS.sCampaignName#', '#ARGUMENTS.sSummary#', #ARGUMENTS.iRatingIDPK#, #ARGUMENTS.iC02ImpactIDPK#) SELECT iCampaignIDPK AS id FROM tbl_campaigns ORDER BY iCampaignIDPK DESC INSERT tbl_campaign_category_link (iCampaignIDFK, iCategoryIDFK) VALUES (#get_id.id#, #this_category#) INSERT INTO tbl_embedded_media (sEmbeddedMedia, id, sType) VALUES ('#this_media#', #get_id.id#, 'Campaign') UPDATE tbl_campaigns SET sCampaignName = '#ARGUMENTS.sCampaignName#', sSummary = '#ARGUMENTS.sSummary#', iRatingIDFK = #ARGUMENTS.iRatingIDPK#, iC02ImpactIDFK = #ARGUMENTS.iC02ImpactIDPK# WHERE iCampaignIDPK = DELETE FROM tbl_campaign_category_link WHERE iCampaignIDFK = INSERT tbl_campaign_category_link (iCampaignIDFK, iCategoryIDFK) VALUES (, #this_category#) INSERT INTO tbl_embedded_media (sEmbeddedMedia, id, sType) VALUES ('#this_media#', , 'Campaign') SELECT * FROM tbl_campaigns ORDER BY sCampaignName SELECT * FROM tbl_campaigns, tbl_campaign_category_link, tbl_c02impact, tbl_ratings, tbl_categories WHERE 0=0 tbl_campaign_category_link.iCampaignIDFK = tbl_campaigns.iCampaignIDPK AND tbl_campaign_category_link.iCategoryIDFK = tbl_categories.iCategoryIDPK AND tbl_campaign_category_link.iCategoryIDFK = AND tbl_campaigns.iRatingIDFK = tbl_ratings.iRatingIDPK AND tbl_campaigns.iC02ImpactIDFK = tbl_c02impact.iC02ImpactIDPK AND tbl_campaigns.iCampaignIDPK = SELECT * FROM tbl_campaign_category_link WHERE iCampaignIDFK = SELECT * FROM tbl_categories ORDER BY iSortOrder SELECT * FROM tbl_ratings SELECT * FROM tbl_c02impact SELECT * FROM tbl_user_campaign_link, tbl_campaigns WHERE UUID = '#arguments.UUID#' AND iCategoryIDFK = #ARGUMENTS.iCategoryIDPK# AND tbl_campaigns.iCampaignIDPK = tbl_user_campaign_link.iCampaignIDFK DELETE FROM tbl_campaigns WHERE iCampaignIDPK = #arguments.iCampaignIDPK# DELETE FROM tbl_user_campaign_link WHERE iCampaignIDFK = #arguments.iCampaignIDPK# SELECT iCampaignIDPK, sCampaignName, sSummary, sRating, sC02Impact FROM tbl_campaigns, tbl_campaign_category_link, tbl_c02impact, tbl_ratings WHERE tbl_campaign_category_link.iCategoryIDFK = #ARGUMENTS.iCategoryIDPK# AND tbl_campaign_category_link.iCampaignIDFK = tbl_campaigns.iCampaignIDPK AND tbl_campaigns.iRatingIDFK = tbl_ratings.iRatingIDPK AND tbl_campaigns.iC02ImpactIDFK = tbl_c02impact.iC02ImpactIDPK SELECT iCampaignIDPK, sC02Impact, iC02ImpactValue FROM tbl_campaigns, tbl_c02impact, tbl_user_campaign_link WHERE tbl_user_campaign_link.UUID = '#ARGUMENTS.UUID#' AND tbl_campaigns.iC02ImpactIDFK = tbl_c02impact.iC02ImpactIDPK AND tbl_user_campaign_link.iCampaignIDFK = tbl_campaigns.iCampaignIDPK SELECT iCampaignIDPK, sC02Impact, iC02ImpactValue FROM tbl_campaigns, tbl_c02impact, tbl_user_campaign_link WHERE tbl_user_campaign_link.UUID = '#ARGUMENTS.UUID#' AND tbl_campaigns.iC02ImpactIDFK = tbl_c02impact.iC02ImpactIDPK AND tbl_user_campaign_link.iCampaignIDFK = tbl_campaigns.iCampaignIDPK SELECT iCampaignIDPK, sC02Impact, iC02ImpactValue FROM tbl_campaigns, tbl_c02impact, tbl_user_campaign_link WHERE tbl_user_campaign_link.UUID = '#ARGUMENTS.UUID#' AND tbl_campaigns.iC02ImpactIDFK = tbl_c02impact.iC02ImpactIDPK AND tbl_user_campaign_link.iCampaignIDFK = tbl_campaigns.iCampaignIDPK SELECT iCampaignIDFK FROM tbl_user_campaign_link WHERE UUID = '#ARGUMENTS.UUID#' AND iCampaignIDFK = #ARGUMENTS.iCampaignIDPK# INSERT INTO tbl_user_campaign_link (UUID, iCampaignIDFK) VALUES ('#ARGUMENTS.UUID#', #ARGUMENTS.iCampaignIDPK#) SELECT iC02ImpactValue FROM tbl_c02impact INNER JOIN tbl_campaigns ON tbl_c02impact.iC02ImpactIDPK = tbl_campaigns.iC02ImpactIDFK WHERE iCampaignIDPK = #ARGUMENTS.iCampaignIDPK#