http://www.career-college.org/11110/California/Santa+Monica/Fashion/Apparel_And_Textiles/colleges - Message: SELECT *  FROM wp_posts p LEFT JOIN tracking_articles ta ON p.id = ta.wp_post_ID AND ta.referring_url='/11110/california/santa+monica/fashion/apparel_and_textiles/colleges' WHERE p.post_status = 'publish' AND p.city LIKE "%santa monica%" AND p.state = "CA" ORDER BY ta.hit_ratio desc LIMIT 5