SELECT t1.title AS lev1, t2.title as lev2, t3.title as lev3, t4.title as lev4, t5.URL as url1, t6.URL as url2, t7.URL as url3, t8.URL as url4
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
LEFT JOIN wwm_guides AS t6 ON t6.parent = t5.Guide_ID
LEFT JOIN wwm_guides AS t7 ON t7.parent = t6.Guide_ID
LEFT JOIN wwm_guides AS t8 ON t8.parent = t7.Guide_ID
WHERE t1.title = 'Your Town';