SELECT SQL_CALC_FOUND_ROWS p.id, pt.name, p.slug, p.price, i.image, p.price_sale, p.promo, p.price_promo, p.created_at, pt.meta_description, p.new, pt.price as actual_price
FROM products p
INNER JOIN products_linked pl ON p.id = pl.link_id AND pl.product_id =
INNER JOIN products_text pt ON p.id = pt.product_id AND pt.language_id = 1
LEFT JOIN products_images i ON p.id = i.page_id
LEFT JOIN pages_text c ON p.category = c.page_id AND c.language_id = 1
LEFT JOIN pages_text sc ON p.subcategory = sc.page_id AND sc.language_id = 1
WHERE p.status != 'deleted'
AND p.available = 'yes'
GROUP BY p.id
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 'INNER JOIN products_text pt ON p.id = pt.product_id AND pt.language_id = 1
...' at line 4
file -
line -