QUERY: ( SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_price,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id ,( IF (products_name LIKE ('jaguar'), 100, 0) + IF (products_name LIKE ('jaguar%'), 80, 0) + IF (products_name LIKE ('%jaguar'), 60, 0) + IF (products_name LIKE ('%jaguar%'), 40, 0) + IF (products_model LIKE ('%jaguar%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('xj8'), 100, 0) + IF (products_name LIKE ('xj8%'), 80, 0) + IF (products_name LIKE ('%xj8'), 60, 0) + IF (products_name LIKE ('%xj8%'), 40, 0) + IF (products_model LIKE ('%xj8%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('ксенон'), 100, 0) + IF (products_name LIKE ('ксенон%'), 80, 0) + IF (products_name LIKE ('%ксенон'), 60, 0) + IF (products_name LIKE ('%ксенон%'), 40, 0) + IF (products_model LIKE ('%ксенон%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('в'), 100, 0) + IF (products_name LIKE ('в%'), 80, 0) + IF (products_name LIKE ('%в'), 60, 0) + IF (products_name LIKE ('%в%'), 40, 0) + IF (products_model LIKE ('%в%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('фару'), 100, 0) + IF (products_name LIKE ('фару%'), 80, 0) + IF (products_name LIKE ('%фару'), 60, 0) + IF (products_name LIKE ('%фару%'), 40, 0) + IF (products_model LIKE ('%фару%'), 20, 0) ) AS `relevant` FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND ( ( pd.products_keywords LIKE ('%jaguar%') OR p.products_model LIKE ('%jaguar%') OR pd.products_name LIKE ('%jaguar%') OR pd.products_name LIKE ('%jaguar%') OR pd.products_name LIKE ('%jaguar%') OR pd.products_name LIKE ('%офпгфк%') OR pd.products_name LIKE ('%jaguar%') OR pd.products_description LIKE ('%jaguar%') OR pd.products_short_description LIKE ('%jaguar%') ) AND ( pd.products_keywords LIKE ('%xj8%') OR p.products_model LIKE ('%xj8%') OR pd.products_name LIKE ('%xj8%') OR pd.products_name LIKE ('%xj8%') OR pd.products_name LIKE ('%xj8%') OR pd.products_name LIKE ('%чо8%') OR pd.products_name LIKE ('%xj8%') OR pd.products_description LIKE ('%xj8%') OR pd.products_short_description LIKE ('%xj8%') ) AND ( pd.products_keywords LIKE ('%ксенон%') OR p.products_model LIKE ('%ксенон%') OR pd.products_name LIKE ('%ксен%') OR pd.products_name LIKE ('%ksenon%') OR pd.products_name LIKE ('%xenon%') OR pd.products_name LIKE ('%ксенон%') OR pd.products_name LIKE ('%rctyjy%') OR pd.products_description LIKE ('%ксенон%') OR pd.products_short_description LIKE ('%ксенон%') ) AND ( pd.products_keywords LIKE ('%в%') OR p.products_model LIKE ('%в%') OR pd.products_name LIKE ('%в%') OR pd.products_name LIKE ('%v%') OR pd.products_name LIKE ('%v%') OR pd.products_name LIKE ('%в%') OR pd.products_name LIKE ('%d%') OR pd.products_description LIKE ('%в%') OR pd.products_short_description LIKE ('%в%') ) AND ( pd.products_keywords LIKE ('%фару%') OR p.products_model LIKE ('%фару%') OR pd.products_name LIKE ('%фар%') OR pd.products_name LIKE ('%faru%') OR pd.products_name LIKE ('%pharu%') OR pd.products_name LIKE ('%фару%') OR pd.products_name LIKE ('%afhe%') OR pd.products_description LIKE ('%фару%') OR pd.products_short_description LIKE ('%фару%') ) ) GROUP BY p.products_id ) UNION ( SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_price,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id ,( IF (products_name LIKE ('jaguar'), 100, 0) + IF (products_name LIKE ('jaguar%'), 80, 0) + IF (products_name LIKE ('%jaguar'), 60, 0) + IF (products_name LIKE ('%jaguar%'), 40, 0) + IF (products_model LIKE ('%jaguar%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('xj8'), 100, 0) + IF (products_name LIKE ('xj8%'), 80, 0) + IF (products_name LIKE ('%xj8'), 60, 0) + IF (products_name LIKE ('%xj8%'), 40, 0) + IF (products_model LIKE ('%xj8%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('ксенон'), 100, 0) + IF (products_name LIKE ('ксенон%'), 80, 0) + IF (products_name LIKE ('%ксенон'), 60, 0) + IF (products_name LIKE ('%ксенон%'), 40, 0) + IF (products_model LIKE ('%ксенон%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('в'), 100, 0) + IF (products_name LIKE ('в%'), 80, 0) + IF (products_name LIKE ('%в'), 60, 0) + IF (products_name LIKE ('%в%'), 40, 0) + IF (products_model LIKE ('%в%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('фару'), 100, 0) + IF (products_name LIKE ('фару%'), 80, 0) + IF (products_name LIKE ('%фару'), 60, 0) + IF (products_name LIKE ('%фару%'), 40, 0) + IF (products_model LIKE ('%фару%'), 20, 0) ) AS `relevant` FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) LEFT JOIN products_attributes AS pa ON (p.products_id = pa.products_id) LEFT JOIN products_options_values AS pov ON (pa.options_values_id = pov.products_options_values_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND ( ( pov.products_options_values_name LIKE ('%jaguar%') AND pov.language_id = '1' ) AND ( pov.products_options_values_name LIKE ('%xj8%') AND pov.language_id = '1' ) AND ( pov.products_options_values_name LIKE ('%ксенон%') AND pov.language_id = '1' ) AND ( pov.products_options_values_name LIKE ('%в%') AND pov.language_id = '1' ) AND ( pov.products_options_values_name LIKE ('%фару%') AND pov.language_id = '1' ) ) GROUP BY p.products_id ) UNION ( SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_price,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id ,( IF (products_name LIKE ('jaguar'), 100, 0) + IF (products_name LIKE ('jaguar%'), 80, 0) + IF (products_name LIKE ('%jaguar'), 60, 0) + IF (products_name LIKE ('%jaguar%'), 40, 0) + IF (products_model LIKE ('%jaguar%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('xj8'), 100, 0) + IF (products_name LIKE ('xj8%'), 80, 0) + IF (products_name LIKE ('%xj8'), 60, 0) + IF (products_name LIKE ('%xj8%'), 40, 0) + IF (products_model LIKE ('%xj8%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('ксенон'), 100, 0) + IF (products_name LIKE ('ксенон%'), 80, 0) + IF (products_name LIKE ('%ксенон'), 60, 0) + IF (products_name LIKE ('%ксенон%'), 40, 0) + IF (products_model LIKE ('%ксенон%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('в'), 100, 0) + IF (products_name LIKE ('в%'), 80, 0) + IF (products_name LIKE ('%в'), 60, 0) + IF (products_name LIKE ('%в%'), 40, 0) + IF (products_model LIKE ('%в%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('фару'), 100, 0) + IF (products_name LIKE ('фару%'), 80, 0) + IF (products_name LIKE ('%фару'), 60, 0) + IF (products_name LIKE ('%фару%'), 40, 0) + IF (products_model LIKE ('%фару%'), 20, 0) ) AS `relevant` FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) LEFT JOIN products_specifications psv ON (p.products_id = psv.products_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND ( ( specification like ('%jaguar%') ) AND ( specification like ('%xj8%') ) AND ( specification like ('%ксенон%') ) AND ( specification like ('%в%') ) AND ( specification like ('%фару%') ) ) GROUP BY p.products_id ) UNION ( SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_price,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id ,( IF (products_name LIKE ('jaguar'), 100, 0) + IF (products_name LIKE ('jaguar%'), 80, 0) + IF (products_name LIKE ('%jaguar'), 60, 0) + IF (products_name LIKE ('%jaguar%'), 40, 0) + IF (products_model LIKE ('%jaguar%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('xj8'), 100, 0) + IF (products_name LIKE ('xj8%'), 80, 0) + IF (products_name LIKE ('%xj8'), 60, 0) + IF (products_name LIKE ('%xj8%'), 40, 0) + IF (products_model LIKE ('%xj8%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('ксенон'), 100, 0) + IF (products_name LIKE ('ксенон%'), 80, 0) + IF (products_name LIKE ('%ксенон'), 60, 0) + IF (products_name LIKE ('%ксенон%'), 40, 0) + IF (products_model LIKE ('%ксенон%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('в'), 100, 0) + IF (products_name LIKE ('в%'), 80, 0) + IF (products_name LIKE ('%в'), 60, 0) + IF (products_name LIKE ('%в%'), 40, 0) + IF (products_model LIKE ('%в%'), 20, 0) + IF (products_name LIKE ('or'), 100, 0) + IF (products_name LIKE ('or%'), 80, 0) + IF (products_name LIKE ('%or'), 60, 0) + IF (products_name LIKE ('%or%'), 40, 0) + IF (products_model LIKE ('%or%'), 20, 0) + IF (products_name LIKE ('фару'), 100, 0) + IF (products_name LIKE ('фару%'), 80, 0) + IF (products_name LIKE ('%фару'), 60, 0) + IF (products_name LIKE ('%фару%'), 40, 0) + IF (products_model LIKE ('%фару%'), 20, 0) ) AS `relevant` FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) LEFT JOIN products_to_products_extra_fields AS pe ON (p.products_id = pe.products_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND ( ( pe.products_extra_fields_value LIKE ('%jaguar%') ) AND ( pe.products_extra_fields_value LIKE ('%xj8%') ) AND ( pe.products_extra_fields_value LIKE ('%ксенон%') ) AND ( pe.products_extra_fields_value LIKE ('%в%') ) AND ( pe.products_extra_fields_value LIKE ('%фару%') ) ) GROUP BY p.products_id ) ORDER BY CASE WHEN products_quantity > 0 THEN 1 WHEN products_quantity <= 1 THEN 0 END DESC ,rev_rang desc , relevant DESC
ERROR: Unknown column 'rev_rang' in 'order clause'