SELECT slug, CONCAT('/assets/landing/',filepath) as showfile FROM tbl_pages WHERE navtype='landing' AND published=1 AND CONCAT(subslug,'/',slug,'/') = '/sitemap.html/'