SELECT store_code, Store_Name,
	0 as sequenceNr, 
	'Shop ' + store_name + ' = ' as OutputLine
FROM stores 
WHERE storeStatus = 'ON' and store_code NOT IN
		(
			select ar_store_code
			from pgm_action_responses
		)
	UNION ALL
SELECT 
	s.store_code,s.Store_Name,
	pss_story_id as sequenceNr, 
	 st_title + ' st_status = ' + CASE WHEN st_status = '1' THEN 'yes' ELSE 'no' END as OutputLine
From
	pgm_store_stories as ss
		inner join pgm_stories as st
			on ss.pss_story_id = st.st_id
		inner join stores as s
			on s.store_code = ss.pss_store_code
Where pss_story_id > '7829'  
ORDER BY 1, 2

  select
     pss_store_code
    ,store_name
	,pss_story_id
   	,st_title
  from stores as s
    full join pgm_store_stories as ss
      on s.store_code = ss.pss_store_code
    full join pgm_stories as st
      on ss.pss_story_id = st.st_id
  where s.storeStatus = 'on' AND st_release_date > '2009-12-01' and pss_store_code not in
      (
        select ar_store_code
        from pgm_action_responses
        where ar_story_id > '7939'
      )
  order by pss_store_code, pss_story_id