Untitled

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