Untitled

-- jual
select CONCAT(LOWER(slug), '-', id) as slug from advertises where is_publish = 1 and listing_type = 1;
-- sewa
select CONCAT(LOWER(slug), '-', id) as slug from advertises where is_publish = 1 and listing_type = 2;
-- project
select CONCAT(LOWER(slug), '-', id) as slug from projects;
-- agent
select REPLACE(LOWER(pic_name), ' ', '-') || '-' || id from agents where is_active = 1;