Сортировка по
SELECT
cat.*,
cur.sname AS currency_sname,
com.brief_name AS company_brief_name,
com.id AS company_id
FROM catalog AS cat
LEFT JOIN currency AS cur
ON cat.currency_id = cur.id
LEFT JOIN companies AS com
ON cat.uid = com.uid
WHERE
cat.show = 'yes' AND
cat.status = '1' AND
cat.uid = '190'
ORDER BY
cat.no_price,
cat.price_search asc,
cat.name,
cat.id
LIMIT 24///////You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '///////' at line 20
