Портативная электроника, Страница 6 - Интернет-магазин "Антенный маркет"

20/08/2025 02:08:44 | 126 - Incorrect key file for table '/tmp/#sql_484_0.MYI'; try to repair it | 
		SELECT 
			*, p.products_quantity > 0 as instock , po.personal_offer AS po_personal_offer    
		FROM
			os_products p
				LEFT JOIN os_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
				LEFT JOIN os_featured f ON (f.products_id = p.products_id AND f.status = 1)
				LEFT JOIN os_specials s ON (p.products_id = s.products_id AND s.status = 1)
				 LEFT JOIN os_personal_offers_by_customers_status_2 po ON (p.products_id = po.products_id AND po.quantity = 1) 
				,
			os_products_description pd,
			os_categories c,
			os_categories_description cd,
			os_products_to_categories p2c 
		WHERE
			pd.language_id = '1' AND
			pd.products_id = p.products_id AND
			p.products_id = p2c.products_id AND
			pd.products_id = p2c.products_id AND
			p2c.categories_id = c.categories_id AND 
			c.categories_id = cd.categories_id
			
			
			 AND p.products_status = '1' 
			 AND c.categories_status = '1' 
			
			 AND p2c.categories_id IN (76,107,120,77,121,122,123,124,126,101,125,79,78,80,85) 
			
			
			ORDER BY
				instock DESC,  (CASE WHEN s.specials_new_products_price IS NOT NULL THEN s.specials_new_products_price ELSE p.products_price END) ASC 
			
		 LIMIT 80, 16 | /portativnaya-elektronika?page=6&typeview=1