SELECT id,domain,slug,uniqueId,data,url,experience,view,active,waktu FROM listing_data WHERE active=? and JSON_EXTRACT(data,'$.render')!=? and (TRIM(TRAILING '-' FROM LOWER(REGEXP_REPLACE(JSON_UNQUOTE(JSON_EXTRACT(data,'$.category')), '[^a-z^0-9]+', '-'))) LIKE CONCAT('%',?,'%') or JSON_UNQUOTE(JSON_EXTRACT(data,'$.category'))=CONCAT('%',?,'%')) ORDER BY JSON_EXTRACT(data,'$.premium') DESC, waktu DESC Array
(
[0] => ssss
[1] => 1
[2] => 0000-00-00 00:00:00
[3] => fashion
[4] => fashion
)
SELECT id,domain,slug,uniqueId,data,url,experience,view,active,waktu FROM listing_data WHERE active=? and JSON_EXTRACT(data,'$.render')!=? and (TRIM(TRAILING '-' FROM LOWER(REGEXP_REPLACE(JSON_UNQUOTE(JSON_EXTRACT(data,'$.category')), '[^a-z^0-9]+', '-'))) LIKE CONCAT('%',?,'%') or JSON_UNQUOTE(JSON_EXTRACT(data,'$.category'))=CONCAT('%',?,'%')) ORDER BY JSON_EXTRACT(data,'$.premium') DESC, waktu DESC LIMIT 0,30Array
(
[0] => ssss
[1] => 1
[2] => 0000-00-00 00:00:00
[3] => fashion
[4] => fashion
)
SELECT id,domain,slug,uniqueId,data,url,experience,view,active,waktu FROM listing_data WHERE active=? and JSON_EXTRACT(data,'$.render')!=? and (TRIM(TRAILING '-' FROM LOWER(REGEXP_REPLACE(JSON_UNQUOTE(JSON_EXTRACT(data,'$.category')), '[^a-z^0-9]+', '-'))) LIKE CONCAT('%',?,'%') or JSON_UNQUOTE(JSON_EXTRACT(data,'$.category'))=CONCAT('%',?,'%')) ORDER BY JSON_EXTRACT(data,'$.premium') DESC, waktu DESC Array
(
[0] => ssss
[1] => 1
[2] => 0000-00-00 00:00:00
[3] => fashion
[4] => fashion
)
912+ Fashion Sites | CliffListing
