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] => 259586 [2] => dijual-ruko-strategis-2-lantai-luas-98m2-banjarsarisolo ) 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(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] => ssssss [1] => dijual [2] => jawa tengah [3] => jawa tengah [4] => surakarta [5] => surakarta [6] => ruko ) 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 )