query('SELECT * FROM products ORDER BY id') as $r) $urls[] = product_url($r); foreach (db()->query("SELECT c.* FROM categories c WHERE EXISTS (SELECT 1 FROM products p WHERE ('|' || p.category_ids || '|') LIKE '%|' || c.id || '|%') ORDER BY c.id") as $r) $urls[] = category_url($r); foreach (db()->query('SELECT slug FROM pages ORDER BY id') as $r) $urls[] = page_url($r['slug']); foreach (db()->query('SELECT * FROM news ORDER BY id') as $r) $urls[] = news_url($r); echo "\n"; echo "\n"; foreach (array_unique($urls) as $path) echo " " . sitemap_loc($base . sitemap_path($path)) . "\n"; echo "\n";