SELECT PageControl.PageName, PageControl.ShortName, PageControl.LongName, PageControl.SortRange, PageControl.Section, PageControl.Meta1, PageControl.Meta2, PageControl.SparesLink,PageControl.MusicLink, MusicPage.PageName AS MusicPageName, SparesPage.PageName AS SparesPageName FROM PageControl LEFT JOIN PageControl AS MusicPage ON PageControl.MusicLink = MusicPage.PageNo LEFT JOIN PageControl AS SparesPage ON PageControl.SparesLink = SparesPage.PageNo WHERE PageControl.PageNo = 'P17' LIMIT 1database
| |||||||||||||||||||||||||||||||||
|
|
| |||||||||||||||||||||||||||||||