15/06/2026 17:06:11 | 1034 - Incorrect key file for table 'os_products_to_categories'; try to repair it | SELECT distinct p.products_id, (select categories_name from os_categories_description cn where cn.categories_id =(select max(pco.categories_id) from os_products_to_categories pco where pco.products_id=p.products_id)) as category_name, (select manufacturers_name from os_manufacturers where os_manufacturers.manufacturers_id=p.manufacturers_id) as manufacturers_name, p.products_price, p.products_model, p.unpack_kol, p.products_quantity, p.products_shippingtime, p.products_fsk18, p.products_image, p.products_weight, p.products_tax_class_id, pd.products_name, pd.products_short_description, pd.products_description , pd.products_description as apt_inform,pd.products_description as work_time,pd.products_description as is_shop FROM os_products AS p LEFT JOIN os_products_description AS pd ON (p.products_id = pd.products_id) LEFT OUTER JOIN os_products_attributes AS pa ON (p.products_id = pa.products_id) LEFT OUTER JOIN os_products_options_values AS pov ON (pa.options_values_id = pov.products_options_values_id) LEFT OUTER JOIN os_specials AS s ON (p.products_id = s.products_id) AND s.status = '1' LEFT OUTER JOIN os_products_to_products_extra_fields AS pe ON (p.products_id = pe.products_id) LEFT OUTER JOIN os_products_to_categories AS pc ON (p.products_id = pc.products_id) left join os_param pm on p.products_id = pm.product_id WHERE p.products_status = '1' AND pd.language_id = '1' AND ( ( pd.products_name LIKE ('%доппельгерц%') OR pe.products_extra_fields_value LIKE ('%доппельгерц%') OR (pov.products_options_values_name LIKE ('%доппельгерц%') AND pov.language_id = '1') ) and ( pd.products_name LIKE ('%актив%') OR pe.products_extra_fields_value LIKE ('%актив%') OR (pov.products_options_values_name LIKE ('%актив%') AND pov.language_id = '1') ) and ( pd.products_name LIKE ('%капилляр%') OR pe.products_extra_fields_value LIKE ('%капилляр%') OR (pov.products_options_values_name LIKE ('%капилляр%') AND pov.language_id = '1') ) and ( pd.products_name LIKE ('%капс%') OR pe.products_extra_fields_value LIKE ('%капс%') OR (pov.products_options_values_name LIKE ('%капс%') AND pov.language_id = '1') ) and ( pd.products_name LIKE ('%500мг%') OR pe.products_extra_fields_value LIKE ('%500мг%') OR (pov.products_options_values_name LIKE ('%500мг%') AND pov.language_id = '1') ) and ( pd.products_name LIKE ('%n30%') OR pe.products_extra_fields_value LIKE ('%n30%') OR (pov.products_options_values_name LIKE ('%n30%') AND pov.language_id = '1') ) and ( pd.products_name LIKE ('%бл%') OR pe.products_extra_fields_value LIKE ('%бл%') OR (pov.products_options_values_name LIKE ('%бл%') AND pov.language_id = '1') ) and ( pd.products_name LIKE ('%пк%') OR pe.products_extra_fields_value LIKE ('%пк%') OR (pov.products_options_values_name LIKE ('%пк%') AND pov.language_id = '1') ) ) GROUP BY p.products_id ORDER BY pd.products_name asc LIMIT 0 , 50 | /advanced_search_result.php?keywords=%D0%94%D0%9E%D0%9F%D0%9F%D0%95%D0%9B%D0%AC%D0%93%D0%95%D0%A0%D0%A6+%D0%90%D0%9A%D0%A2%D0%98%D0%92+%D0%9A%D0%90%D0%9F%D0%98%D0%9B%D0%9B%D0%AF%D0%A0+%D0%9A%D0%90%D0%9F%D0%A1+500%D0%9C%D0%93+N30+%D0%91%D0%9B+%D0%9F%D0%9A