Троксерутин Врамед - Аптеки Лекарь

15/06/2026 16:06:22 | 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') )  ) GROUP BY p.products_id ORDER BY pd.products_name asc LIMIT 0 , 50 | /advanced_search_result.php?gent_id=10680&keywords=%D0%A2%D1%80%D0%BE%D0%BA%D1%81%D0%B5%D1%80%D1%83%D1%82%D0%B8%D0%BD+%D0%92%D1%80%D0%B0%D0%BC%D0%B5%D0%B4