Miscellany

SELECT t1.title AS lev1, t2.title as lev2, t3.title as lev3, t4.title as lev4, COALESCE(t1.title, t2.title, t3.title, t4.title, t5.title)
		FROM wwm_guides AS t1
		LEFT JOIN wwm_guides AS t2 ON t2.parent = t1.Guide_ID
		LEFT JOIN wwm_guides AS t3 ON t3.parent = t2.Guide_ID
		LEFT JOIN wwm_guides AS t4 ON t4.parent = t3.Guide_ID
		LEFT JOIN wwm_guides AS t5 ON t5.parent = t4.Guide_ID
		WHERE t1.title = 'Your Town';