SELECT p.name, p.name_ro, p.id, p.ref, p.size_id, pst.name as size_name, p.price, p.price_promo, p.promo, p.bulk_price_1, p.bulk_price_2, p.bulk_price_3, p.image

FROM products_params p 

INNER JOIN pages_text pst ON p.size_id = pst.page_id AND pst.language_id = 1

WHERE p.product_id = 

AND p.id = 170

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 'AND p.id = 170' at line 9