SELECT id,postId,username,category,subCategory,type,uniqueId,title,slug,content,data,images,video,view,contact,status,checked,sold,modify,waktu FROM ad_listing WHERE uniqueId=? and slug=? ORDER BY waktu DESC Array ( [0] => ss [1] => 417609 [2] => di-jual-rumah-siap-huni-full-furnished-di-tenggarong-kutai-kartanegara ) SELECT id,postId,username,category,subCategory,type,uniqueId,title,slug,content,data,images,video,view,contact,status,checked,sold,modify,waktu,FLOOR(JSON_UNQUOTE(JSON_EXTRACT(data,'$.price.price'))/100000000)*100 AS rangePrice,COUNT(id) AS total FROM ad_listing WHERE type=? and (LOWER(REGEXP_REPLACE(JSON_UNQUOTE(JSON_EXTRACT(data,'$.province')), '[^a-z^0-9]+', '-'))=? or JSON_UNQUOTE(JSON_EXTRACT(data,'$.province'))=?) and (LOWER(REGEXP_REPLACE(JSON_UNQUOTE(JSON_EXTRACT(data,'$.regency')), '[^a-z^0-9]+', '-'))=? or JSON_UNQUOTE(JSON_EXTRACT(data,'$.regency'))=?) and (LOWER(REGEXP_REPLACE(JSON_UNQUOTE(JSON_EXTRACT(data,'$.district')), '[^a-z^0-9]+', '-'))=? or JSON_UNQUOTE(JSON_EXTRACT(data,'$.district'))=?) and (LOWER(REGEXP_REPLACE(JSON_UNQUOTE(JSON_EXTRACT(data,'$.village')), '[^a-z^0-9]+', '-'))=? or JSON_UNQUOTE(JSON_EXTRACT(data,'$.village'))=?) and LOWER(REGEXP_REPLACE(subCategory, '[^a-z^0-9]+', '-'))=LOWER(REGEXP_REPLACE(?, '[^a-z^0-9]+', '-')) GROUP BY JSON_UNQUOTE(JSON_EXTRACT(data,'$.price.price')) ORDER BY rangePrice ASC Array ( [0] => ssssssssss [1] => dijual [2] => kalimantan timur [3] => kalimantan timur [4] => kutai kartanegara [5] => kutai kartanegara [6] => tenggarong [7] => tenggarong [8] => timbau [9] => timbau [10] => rumah ) SELECT id,postId,username,category,subCategory,type,uniqueId,title,slug,content,data,images,video,view,contact,status,checked,sold,modify,waktu FROM ad_listing WHERE status=? ORDER BY waktu DESC LIMIT 0,12Array ( [0] => s [1] => active )