A Database Error Occurred

Error Number: 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 'row_number, @prev := category_id FROM posts J...' at line 2

SELECT id FROM (SELECT id, category_id, @row_number := IF(@prev = category_id, @row_number + 1, 1) AS row_number, @prev := category_id FROM posts JOIN (SELECT @prev := NULL, @row_number := 0) AS vars WHERE posts.is_scheduled = 0 AND posts.visibility = 1 AND posts.status = 1 ORDER BY category_id, created_at DESC ) AS table_posts WHERE row_number <= 10

Filename: models/Post_model.php

Line Number: 74