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 'DESC FROM icon_pack, icon WHERE ip_can_show='1' AND ip_id=icon_ip_id AND ip_mem_' at line 1SELECT DISTINCT icon_id, icon_view_all_time DESC FROM icon_pack, icon WHERE ip_can_show='1' AND ip_id=icon_ip_id AND ip_mem_id='0' ORDER BY icon_view_all_time DESC  LIMIT 0, 40