SELECT SQL_CALC_FOUND_ROWS p.id, pt.name, p.promo_until,  p.slug, pt.price, pt.price_promo, 
		 -- i.image, 
		 pt.ohlajdane, pt.otoplenie, pt.konsumaciq,
		  t.name as type, t.slug as type_slug, b.name as brand, b.slug as brand_slug,
		  p.cop, IF( p.promo_until > 1743833835, 'yes', 'no' ) as promo,
		  IF( p.promo = 'yes', pt.price_promo, pt.price ) as actual_price,
		  btu_pt.name as btu, p.min_noise
	     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
	     LEFT JOIN pages_text t ON p.type_id = t.page_id AND t.language_id = 1
	     LEFT JOIN pages_text b ON p.brand_id = b.page_id AND b.language_id = 1
	     LEFT JOIN pages_text btu_pt ON p.btu = btu_pt.page_id AND btu_pt.language_id = 1
	     LEFT JOIN products_plosht pp ON p.id = pp.product_id
	     WHERE p.status != 'deleted'
	     AND CHAR_LENGTH( p.slug ) > 1
	     AND p.available = 'yes'
	      AND p.promo_until > 1743833835 
	     
	     
	     
	     
	     
	     
	     
	     
	     
	     
	     
	     GROUP BY p.id
	     
	     ORDER BY pt.price ASC 
	     LIMIT 21 OFFSET 21
	    

Server shutdown in progress