15/06/2026 16:06:46 | 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 ('%aura%') OR pe.products_extra_fields_value LIKE ('%aura%') OR (pov.products_options_values_name LIKE ('%aura%') AND pov.language_id = '1') ) and ( pd.products_name LIKE ('%beauty%') OR pe.products_extra_fields_value LIKE ('%beauty%') OR (pov.products_options_values_name LIKE ('%beauty%') AND pov.language_id = '1') ) and ( pd.products_name LIKE ('%n160%') OR pe.products_extra_fields_value LIKE ('%n160%') OR (pov.products_options_values_name LIKE ('%n160%') 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%92%D0%90%D0%A2%D0%9D%D0%AB%D0%95+%D0%9F%D0%90%D0%9B%D0%9E%D0%A7%D0%9A%D0%98+AURA+BEAUTY++N160+%D0%9F%D0%90%D0%9A+%D0%9F%D0%AD