SELECT SQL_CALC_FOUND_ROWS p.id, pt.name, p.slug, p.price, i.image, p.ref_num, pt.meta_description, p.promo, p.price_promo, p.created_at,

				    pt.price as actual_price, p.promo

			FROM products p

			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

			WHERE TRUE

			AND p.status != 'deleted'

			AND p.promo = 'yes'

			AND p.id IN(9570,22131,28981)

			GROUP BY p.id

			

Table 'luxknl0d_site.products_text' doesn't exist