SELECT website.n,
data.headline,
if ( navi.ebene = 0, navi.reihenfolge, navi.reihenfolge ) AS navigation
FROM cont_website AS website
LEFT JOIN cont_data AS data ON ( data.id_website = website.id )
LEFT JOIN navigation AS navi ON ( navi.id_website = website.id )
WHERE website.id_template = '33'
AND website.live = 'Y'
AND website.id_domain = '3'
AND data.lang = 'de'
ORDER BY navigation ASC - Table 'gw_iphone.navigation' doesn't exist