SELECT details.start_date AS ProgramDate,details.code AS ProgramCode,details.code AS EventCode,person.first_name,person.last_name,person1.first_name,person.last_name FROM aba_workflow.programplanner_details details join aba_user.attendee attende on details.webinar_marketer_id=attende.idjoin aba_user.person personon person.id=attende.person_idjoin aba_user.attendee attende1on details.marketer_id=attende1.idjoin aba_user.person person1on person1.id=attende1.person_id;#marketing update querySELECT details.start_date AS ProgramDate,details.code AS ProgramCode,details.code AS EventCode, CONCAT(person.first_name, person.last_name) AS ProductManager,CONCAT(person1.first_name, person1.last_name) AS webinarMarketer,details.code As Links,marketing.status AS MarketingStatus,marketing.changed_fields AS UpdatedItems,marketing.lastmodified_datetime AS TaskDueDate FROM aba_workflow.programplanner_details detailsjoin aba_user.attendee attendeon details.webinar_marketer_id=attende.idjoin aba_user.person personon person.id=attende.person_idjoin aba_user.attendee attende1on details.marketer_id=attende1.idjoin aba_user.person person1on person1.id=attende1.person_idjoin aba_workflow.programplanner_marketing marketingon details.program_planner_id=marketing.program_planner_idwhere marketing.changed_fields is not null or marketing.changed_fields ='';#marketing New page querySELECT details.start_date AS ProgramDate,details.code AS ProgramCode,details.code AS EventCode, CONCAT(person.first_name, person.last_name) AS ProductManager,CONCAT(person1.first_name, person1.last_name) AS webinarMarketer,details.code As Links,marketing.status AS MarketingStatus,marketing.changed_fields AS UpdatedItems,marketing.lastmodified_datetime AS TaskDueDate FROM aba_workflow.programplanner_details detailsjoin aba_user.attendee attendeon details.webinar_marketer_id=attende.idjoin aba_user.person personon person.id=attende.person_idjoin aba_user.attendee attende1on details.marketer_id=attende1.idjoin aba_user.person person1on person1.id=attende1.person_idjoin aba_workflow.programplanner_marketing marketingon details.program_planner_id=marketing.program_planner_id;#marketing Programs queryselect details.start_date As StartDate,details.code AS ProgramCode,details.code AS ProgramTitle,details.code AS Links,sponsor.name AS PrimarySponsers,CONCAT(person1.first_name, person1.last_name) AS Marketer,CONCAT(person.first_name, person.last_name) AS ProgramInitiator,marketing.status AS MarketingStatus,CONCAT(person2.first_name, person2.last_name) AS ProductionAssociates FROM aba_workflow.programplanner_details detailsjoin aba_user.attendee attende1on details.marketer_id=attende1.idjoin aba_user.person person1on person1.id=attende1.person_idjoin aba_workflow.programplanner ppon details.program_planner_id=pp.idjoin aba_user.attendee attendeon pp.created_by_idattendee=attende.idjoin aba_user.person personon person.id=attende.person_idjoin aba_workflow.programplanner_marketing marketingon pp.id=marketing.program_planner_idjoin aba_workflow.programplanner_sponsor ppsponsoron details.program_planner_id=ppsponsor.program_planner_idjoin aba_workflow.programplanner_sponsor_financial financialsponsoron financialsponsor.programplanner_sponsor_id=ppsponsor.idjoin aba_workflow.sponsor sponsoron sponsor.id=financialsponsor.financial_sponsors_idjoin aba_workflow.programplanner_associates associateson associates.program_planner_id=details.program_planner_idjoin aba_user.attendee attende2on associates.attendee_id=attende2.idjoin aba_user.person person2on person2.id=attende2.person_id;#ProgramsSELECT details.code,details.start_date,CONCAT(person1.first_name, person1.last_name) AS Marketer,marketing.status AS MarketingStatus FROM aba_workflow.programplanner ppright outer join aba_workflow.programplanner_details detailson details.program_planner_id=p.idjoin aba_user.attendee attende1on details.marketer_id=attende1.idjoin aba_user.person person1on person1.id=attende1.person_idjoin aba_workflow.programplanner_marketing marketingon pp.id=marketing.program_planner_idjoin aba_workflow.programplanner_associates associateson associates.program_planner_id=details.program_planner_idjoin aba_user.attendee attende2on (associates.attendee_id=attende2.id and associates.attendee_idattende2.id);#programs procedureDELIMITER // CREATE PROCEDURE getPrograms() BEGIN Declare @Programplanner_id AS varchar set @Programplanner_id =(SELECT pp.id FROM aba_workflow.programplanner pp;); END // DELIMITER ; call getPrograms(); DROP PROCEDURE IF EXISTS getPrograms(); ### SELECT details.code,person.first_name,CONCAT(person1.first_name,person1.secon FROM aba_workflow.programplanner pp,aba_workflow.programplanner_details details,aba_user.attendee attendee,aba_user.person person,aba_workflow.programplanner_associates associates,aba_user.attendee attendee1,aba_user.person person1where pp.id=details.program_planner_id and (details.webinar_marketer_id=attendee.id and person.id=attendee.person_id) and (associates.program_planner_id=details.program_planner_id or associates.program_planner_iddetails.program_planner_id) and(associates.attendee_id=attendee1.id and person1.id=attendee1.person_id);; select details.start_date As StartDate,details.code AS ProgramCode,details.code AS ProgramTitle,details.code AS Links,sponsor.name AS PrimarySponsers,CONCAT(person1.first_name, person1.last_name) AS Marketer,CONCAT(person.first_name, person.last_name) AS ProgramInitiator,marketing.status AS MarketingStatus,CONCAT(person2.first_name, person2.last_name) AS ProductionAssociates FROM aba_workflow.programplanner ppjoin aba_user.attendee attende1on details.marketer_id=attende1.idjoin aba_user.person person1on person1.id=attende1.person_idjoin aba_workflow.programplanner_details detailson details.program_planner_id=pp.idjoin aba_user.attendee attendeon pp.created_by_idattendee=attende.idjoin aba_user.person personon person.id=attende.person_idjoin aba_workflow.programplanner_marketing marketingon pp.id=marketing.program_planner_idjoin aba_workflow.programplanner_sponsor ppsponsoron details.program_planner_id=ppsponsor.program_planner_idjoin aba_workflow.programplanner_sponsor_financial financialsponsoron financialsponsor.programplanner_sponsor_id=ppsponsor.idjoin aba_workflow.sponsor sponsoron sponsor.id=financialsponsor.financial_sponsors_idjoin aba_workflow.programplanner_associates associateson associates.program_planner_id=details.program_planner_idjoin aba_user.attendee attende2on (associates.attendee_id=attende2.id and associates.attendee_idattende2.id)join aba_user.person person2on person2.id=attende2.person_id ; #Today Marketing programs query select details.start_date As StartDate,details.code AS ProgramCode,details.code AS ProgramTitle,details.code AS Links,sponsor.name AS PrimarySponsers,CONCAT(person1.first_name, person1.last_name) AS Marketer,CONCAT(person2.first_name, person2.last_name) AS ProgramInitiator,marketing.status AS MarketingStatus,CONCAT(person3.first_name, person3.last_name) AS ProductionAssociates from aba_workflow.programplanner_details detailsleft outer join aba_workflow.programplanner ppon pp.id=details.program_planner_idleft outer join aba_user.attendee attende1on details.marketer_id=attende1.idjoin aba_user.person person1on person1.id=attende1.person_idjoin aba_user.attendee attende2on pp.created_by_idattendee=attende2.idjoin aba_user.person person2on person2.id=attende2.person_idjoin aba_workflow.programplanner_associates associateson associates.program_planner_id=details.program_planner_id or associates.program_planner_iddetails.program_planner_idjoin aba_user.attendee attende3on associates.attendee_id=attende3.idjoin aba_user.person person3on person3.id=attende3.person_idleft outer join aba_workflow.programplanner_marketing marketingon pp.id=marketing.program_planner_idjoin aba_workflow.programplanner_sponsor ppsponsoron details.program_planner_id=ppsponsor.program_planner_idjoin aba_workflow.programplanner_sponsor_financial financialsponsoron financialsponsor.programplanner_sponsor_id=ppsponsor.idjoin aba_workflow.sponsor sponsoron sponsor.id=financialsponsor.financial_sponsors_idwhere details.is_active='y'; #Today Marketing New query select details.start_date AS ProgramDate,details.title As ProgramName,details.code AS EventCode,task.optional_field_value AS id,CONCAT(person1.first_name, person1.last_name) AS Marketer,CONCAT(person2.first_name, person2.last_name) AS WebinarMarketer,details.end_date AS endDate ,'action' from aba_workflow.programplanner_details detailsleft outer join aba_workflow.programplanner ppon details.program_planner_id=pp.idleft outer join aba_user.attendee attende1on details.marketer_id=attende1.idjoin aba_user.person person1on person1.id=attende1.person_idleft outer join aba_user.attendee attende2on details.webinar_marketer_id=attende2.idjoin aba_user.person person2on person2.id=attende2.person_idjoin aba_workflow.programplanner_tasks pptaskson pp.id=pptasks.program_planner_idjoin aba_workflow.programplanner_tasks_join_task ppjointaskon pptasks.id=ppjointask.programplanner_tasks_idjoin aba_workflow.task taskon ppjointask.tasks_id=task.idjoin aba_workflow.programplanner_status ppstatuson pp.program_planner_status_id=ppstatus.idwhere details.is_active='y' and ppstatus.name='Live Active';######left outer join aba_workflow.programplanner_target_markets targetmarketson targetmarkets.program_planner_id=pp.idleft outer join aba_workflow.program_xref_target_market_law_code xreftargetmarklawcodeon xreftargetmarklawcode.program_target_market__law_code_id=targetmarkets.idleft outer join aba_workflow.target_marketers_law_code_category targetmarklawcodecategoryon targetmarklawcodecategory.id=xreftargetmarklawcode.target_market_law_code_category_idleft outer join aba_workflow.target_marketers_law_code targetmarklawcodeon targetmarklawcode.law_code_category_id=targetmarklawcodecategory.id