Query
~~exp:query sql="SELECT ebb.entry_id as the_id, ect.url_title as the_url, ect.title as the_title, ecd.field_id_878 as canon_url FROM exp_blocks_atom eba JOIN exp_blocks_block ebb ON eba.block_id = ebb.id JOIN exp_channel_titles ect ON ebb.entry_id = ect.entry_id JOIN exp_channel_data ecd ON ecd.entry_id = ect.entry_id WHERE data LIKE '%pololu-valley-overlook%' "~~Entry {the_id} - {the_title}
~~/exp:query~~
Results
{exp:query sql="SELECT ebb.entry_id as the_id, ect.url_title as the_url, ect.title as the_title, ecd.field_id_878 as canon_url FROM exp_blocks_atom eba JOIN exp_blocks_block ebb ON eba.block_id = ebb.id JOIN exp_channel_titles ect ON ebb.entry_id = ect.entry_id JOIN exp_channel_data ecd ON ecd.entry_id = ect.entry_id WHERE data LIKE '%pololu-valley-overlook%' "} Entry {the_id} - {the_title}{/exp:query}