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_id
SELECT 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_id
SELECT 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 NULL
SELECT 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 NULL
REPLACE INTO urlpart SET part = '1_2-4ghz-en-5ghz-wat-zijn-de-verschillen-', path = '/1_2-4ghz-en-5ghz-wat-zijn-de-verschillen-', wat = 'blog', item_id = 1, taal = 'nl'