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.deploy_num_pages,
                        #targets.title, 
                        #targets.h1, 
												targets.deploy_h1
												#targets.deploy_meta_description,
												#targets.http_status_code, targets.last_crawl_status
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 = 1
AND sources.status = 1
AND targets.is_valid = 1
order by targets2.url
#LIMIT 1000