The SQL Query:
SELECT c.*, (SELECT ft.footer_text FROM city_footer ft WHERE ft.cityid=c.id) AS footer_text, (SELECT CONCAT(ca.url,'++',ca.tsurl) FROM city_adultsearch ca WHERE ca.city=c.id) AS concat_adultsearch FROM city c WHERE c.slug='jacksonville'

Generated the following error:
Can't open file: './myproviderguide/city_adultsearch.frm' (errno: 24)
Florida Escorts on My Provider Guide to Female Escorts and Florida Escort services

Escorts in Florida

Choose a city from the list below

Choose a City

Florida