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;