SELECT pagina.id, titel AS titel, pagina_id FROM pagina LEFT JOIN urlpart ON wat = 'pagina' AND taal = 'nl' AND urlpart.item_id = pagina.id WHERE urlpart.item_id IS NULL ORDER BY pagina_id
SELECT productoptie.id, naam AS titel, parent_id FROM productoptie LEFT JOIN urlpart ON wat = 'productoptie' AND taal = 'nl' AND urlpart.item_id = productoptie.id WHERE urlpart.item_id IS NULL ORDER BY parent_idSELECT product.id, naam AS titel, parent_id FROM product LEFT JOIN urlpart ON wat = 'product' AND taal = 'nl' AND urlpart.item_id = product.id WHERE urlpart.item_id IS NULL ORDER BY parent_idSELECT nieuws.id, titel AS titel FROM nieuws LEFT JOIN urlpart ON wat = 'nieuws' AND taal = 'nl' AND urlpart.item_id = nieuws.id WHERE urlpart.item_id IS NULLSELECT blog.id, titel AS titel FROM blog LEFT JOIN urlpart ON wat = 'blog' AND taal = 'nl' AND urlpart.item_id = blog.id WHERE urlpart.item_id IS NULLSELECT promo.id, titel AS titel FROM promo LEFT JOIN urlpart ON wat = 'promo' AND taal = 'nl' AND urlpart.item_id = promo.id WHERE urlpart.item_id IS NULLSELECT pagina.id, titel AS titel, pagina_id FROM pagina LEFT JOIN urlpart ON wat = 'pagina' AND taal = 'en' AND urlpart.item_id = pagina.id WHERE urlpart.item_id IS NULL ORDER BY pagina_idSELECT productoptie.id, naam AS titel, parent_id FROM productoptie LEFT JOIN urlpart ON wat = 'productoptie' AND taal = 'en' AND urlpart.item_id = productoptie.id WHERE urlpart.item_id IS NULL ORDER BY parent_idSELECT product.id, naam AS titel, parent_id FROM product LEFT JOIN urlpart ON wat = 'product' AND taal = 'en' AND urlpart.item_id = product.id WHERE urlpart.item_id IS NULL ORDER BY parent_idSELECT nieuws.id, titel AS titel FROM nieuws LEFT JOIN urlpart ON wat = 'nieuws' AND taal = 'en' AND urlpart.item_id = nieuws.id WHERE urlpart.item_id IS NULLSELECT blog.id, titel AS titel FROM blog LEFT JOIN urlpart ON wat = 'blog' AND taal = 'en' AND urlpart.item_id = blog.id WHERE urlpart.item_id IS NULLSELECT promo.id, titel AS titel FROM promo LEFT JOIN urlpart ON wat = 'promo' AND taal = 'en' AND urlpart.item_id = promo.id WHERE urlpart.item_id IS NULLSELECT pagina.id, titel AS titel, pagina_id FROM pagina LEFT JOIN urlpart ON wat = 'pagina' AND taal = 'de' AND urlpart.item_id = pagina.id WHERE urlpart.item_id IS NULL ORDER BY pagina_idSELECT productoptie.id, naam AS titel, parent_id FROM productoptie LEFT JOIN urlpart ON wat = 'productoptie' AND taal = 'de' AND urlpart.item_id = productoptie.id WHERE urlpart.item_id IS NULL ORDER BY parent_idSELECT product.id, naam AS titel, parent_id FROM product LEFT JOIN urlpart ON wat = 'product' AND taal = 'de' AND urlpart.item_id = product.id WHERE urlpart.item_id IS NULL ORDER BY parent_idSELECT nieuws.id, titel AS titel FROM nieuws LEFT JOIN urlpart ON wat = 'nieuws' AND taal = 'de' AND urlpart.item_id = nieuws.id WHERE urlpart.item_id IS NULLSELECT blog.id, titel AS titel FROM blog LEFT JOIN urlpart ON wat = 'blog' AND taal = 'de' AND urlpart.item_id = blog.id WHERE urlpart.item_id IS NULLSELECT promo.id, titel AS titel FROM promo LEFT JOIN urlpart ON wat = 'promo' AND taal = 'de' AND urlpart.item_id = promo.id WHERE urlpart.item_id IS NULL
To optimize the user-friendliness of our website and services, we use cookies. However, for the placement of some cookies, we do require your consent. If you would like to learn more about the cookies we use and the data we collect with them, please read our privacy statement