SELECT DISTINCT SQL_CALC_FOUND_ROWS animations.anim_id, animations.anim_title, LPAD(anim_archive_id, 9, '0') as anim_archive_id, animations.anim_description, animations.anim_keywords, animations.anim_filter, animations.anim_frontposition, price_list.price_value FROM animations LEFT JOIN price_list ON (animations.anim_price_type = price_list.price_type) WHERE 1 AND price_list.price_anim_format = '720x576' AND price_list.price_anim_compression=1 ORDER BY animations.anim_times_sold DESC, animations.anim_archive_id DESC LIMIT -45, 45 [nativecode=1064 ** 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 '-45, 45' at line 2]