SELECT item_id, title, url, short_note, list_date FROM cart2_products ORDER BY stat_hits DESC WHERE hide = '0' LIMIT 10
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE hide = '0' LIMIT 10' at line 1