SELECT * FROM Products JOIN category_product on category_product.product_id = id AND category_id = 7 WHERE id > 0 AND is_active = 1 ORDER BY id ASC SELECT * FROM Products JOIN category_product on category_product.product_id = id AND category_id = 7 WHERE id > 0 AND is_active = 1 ORDER BY id ASC LIMIT 9 OFFSET 0