Cacher is the code snippet organizer for pro developers

/* Gets list of link destinations by URL
  REI Acc ID: 36312
	REI Org ID: 6231 
	iapl.deploy_status = 0 for Preview
	iapl.deploy_status = 1 for Live
	preview_num_pages
	preview_h1
	preview_description
*/
select sources.u_url_id, targets2.url, sources.internal_url, sources.internal_url_id,
                        targets.preview_num_pages,
                        targets.title,
												targets.h1, 
                        targets.preview_h1, 
												targets.preview_description,
												targets.http_status_code
from ix_account_page_links sources
join ix_account_internal_links_crawl targets on targets.account_id = sources.account_id
and targets.u_url_id = sources.internal_url_id
join ix_account_internal_links_crawl targets2 on targets2.account_id = sources.account_id
and targets2.u_url_id = sources.u_url_id
where sources.account_id = 36312
and sources.deploy_status = 0
AND sources.status = 1
AND targets.is_valid = 1
order by targets2.url