ВИЗОМИТИН КАП ГЛАЗН 0,155МКГ/МЛ 5МЛ N1 ФЛ ПЭ ПРОБКА-КАП ПК

15/06/2026 17:06:06 | 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 ('%0,155мкг/мл%')  OR pe.products_extra_fields_value LIKE ('%0,155мкг/мл%') OR (pov.products_options_values_name LIKE ('%0,155мкг/мл%') AND pov.language_id = '1') )  and  (  pd.products_name LIKE ('%5мл%')  OR pe.products_extra_fields_value LIKE ('%5мл%') OR (pov.products_options_values_name LIKE ('%5мл%') AND pov.language_id = '1') )  and  (  pd.products_name LIKE ('%n1%')  OR pe.products_extra_fields_value LIKE ('%n1%') OR (pov.products_options_values_name LIKE ('%n1%') 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 ('%пк%')  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%98%D0%97%D0%9E%D0%9C%D0%98%D0%A2%D0%98%D0%9D+%D0%9A%D0%90%D0%9F+%D0%93%D0%9B%D0%90%D0%97%D0%9D+0%2C155%D0%9C%D0%9A%D0%93%2F%D0%9C%D0%9B+5%D0%9C%D0%9B+N1+%D0%A4%D0%9B+%D0%9F%D0%AD+%D0%9F%D0%A0%D0%9E%D0%91%D0%9A%D0%90-%D0%9A%D0%90%D0%9F+%D0%9F%D0%9A