Database Error

    A Database Error Occurred

    Error Number: 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 'Category2.html LIMIT 30 OFFSET 30' at line 9

    SELECT `tb6_product`.`tb6f_id`, `tb6f_name`, `tb6f_price`, `tb6f_discount`, `tb6f_on_sale`, `tb6f_date_added` FROM (`tb6_product`) LEFT JOIN `tb12_tb6_has_tb11` Lv1 ON `Lv1`.`tb6f_id`=`tb6_product`.`tb6f_id` LEFT JOIN `tb11_product_category` Lv2 ON `Lv2`.`tb11f_id`=`Lv1`.`tb11f_id` WHERE `tb6f_status` = 1 AND (tb6f_price-tb6f_discount) <= '720' AND `Lv1`.`tb11f_id` = '8' OR `Lv2`.`tb11f_parent_id` = '8' ORDER BY `tb6f_date_added` Category2.html LIMIT 30 OFFSET 30

    Filename: /home/cp243694/public_html/modules/website/views/product/index.php

    Line Number: 189