SQL ERROR FOUND in SELECT SQL_CALC_FOUND_ROWS r.id AS rid, r.link_attributes,
rp.record, rp.title, rp.text,
ri.code, ri.code_2, ri.code_oem, ri.code_genuine,
CASE
WHEN ri.price THEN ri.price
WHEN ri.price_2 THEN ri.price_2
WHEN ri.price_oem THEN ri.price_oem
WHEN ri.price_genuine THEN ri.price_genuine
ELSE "0"
END AS price,
CASE
WHEN ri.price THEN ""
WHEN ri.price_2 THEN "_2"
WHEN ri.price_oem THEN "_oem"
WHEN ri.price_genuine THEN "_genuine"
ELSE ""
END AS item_type,
ri.discount,
v.value AS vat,
fi.img AS thumb
FROM records AS r
JOIN records_pages AS rp
ON rp.parent = r.id
JOIN records_items AS ri
ON ri.parent = r.id
JOIN items_availability AS ia
ON ri.availability = ia.id
JOIN shop_vats AS v
ON v.id = ri.vat
LEFT JOIN files_images AS fi
ON fi.id = rp.thumb WHERE (r.parent = '74' OR r.id IN (SELECT item_id FROM category_items WHERE category_id = "74"))
AND r.type = 3
AND r.cms_hidden = "0"
AND r.cms_readable = "1"
AND rp.visible = "1" AND r.default_lang = rp.lang
AND r.default_lang = ri.lang ORDER BY rp.title ASC
LIMIT 10 OFFSET -10 [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 '-10' at line 37]