<strong>SQL ERROR FOUND</strong> in SELECT SQL_CALC_FOUND_ROWS    r.id AS rid, r.link_attributes, r.ordering,
                 rp.record, rp.title, rp.text,
                 ri.code, ri.price AS default_price, ri.sale_from, ri.top, ri.bazaar,
                 dd.discount AS discount,
                 CASE
                  WHEN dd.discount
                    THEN ri.price - (ri.price / 100 * dd.discount)
                  ELSE ri.price
                 END AS price,
                 v.value AS vat,
                 fi.img AS thumb,
                 av_1.value AS manufacturer,
                 dd.discount, IF(rp.title = "naraku", 2, 0) AS score_equal, IF(rp.title LIKE "%naraku%", 1, 0) AS score_similar

       FROM      records AS r
       JOIN      records_pages AS rp
        ON       r.id = rp.parent
       JOIN      records_items AS ri
        ON       r.id = ri.parent
       JOIN      shop_vats AS v
        ON       v.id = ri.vat
       LEFT JOIN files_images fi
        ON       rp.thumb = fi.id
       LEFT JOIN items_parameters AS ip
        ON       ip.parent_id = r.id
        AND      ip.attribute_id = 1
       LEFT JOIN attributes_values AS av_1
        ON       av_1.id = ip.value_id
       LEFT JOIN dealers_discounts AS dd
        ON       dd.class_id = 0
        AND      dd.group_id = av_1.id

       WHERE     r.module = 5
        AND      r.type = 3
        AND      rp.visible = "1"
        AND      r.cms_hidden = "0"
        AND      r.cms_readable = "1"
        AND      (rp.title LIKE "%naraku%"
        OR        rp.text LIKE "%naraku%"
        OR        ri.code LIKE "%naraku%"
        OR        ri.ean LIKE "naraku")

       ORDER BY rp.title ASC
      LIMIT 12 OFFSET -12 [nativecode=1064 ** 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 '-12' at line 44]