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 ('e34'), 100, 0) + IF (products_name LIKE ('e34%'), 80, 0) + IF (products_name LIKE ('%e34'), 60, 0) + IF (products_name LIKE ('%e34%'), 40, 0) + IF (products_model LIKE ('%e34%'), 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 ('e30'), 100, 0) + IF (products_name LIKE ('e30%'), 80, 0) + IF (products_name LIKE ('%e30'), 60, 0) + IF (products_name LIKE ('%e30%'), 40, 0) + IF (products_model LIKE ('%e30%'), 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 ('%e34%') OR p.products_model LIKE ('%e34%') OR pd.products_name LIKE ('%e34%') OR pd.products_name LIKE ('%e34%') OR pd.products_name LIKE ('%e34%') OR pd.products_name LIKE ('%у34%') OR pd.products_name LIKE ('%e34%') OR pd.products_description LIKE ('%e34%') OR pd.products_short_description LIKE ('%e34%')  )  AND  ( pd.products_keywords LIKE ('%e30%') OR p.products_model LIKE ('%e30%') OR pd.products_name LIKE ('%e30%') OR pd.products_name LIKE ('%e30%') OR pd.products_name LIKE ('%e30%') OR pd.products_name LIKE ('%у30%') OR pd.products_name LIKE ('%e30%') OR pd.products_description LIKE ('%e30%') OR pd.products_short_description LIKE ('%e30%')  )  AND  ( pd.products_keywords LIKE ('%гладкие%') OR p.products_model LIKE ('%гладкие%') OR pd.products_name LIKE ('%гладк%') OR pd.products_name LIKE ('%gladkie%') OR pd.products_name LIKE ('%gladcie%') OR pd.products_name LIKE ('%гладкие%') OR pd.products_name LIKE ('%ukflrbt%') 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 ('%stekla%') OR pd.products_name LIKE ('%stecla%') OR pd.products_name LIKE ('%стекла%') OR pd.products_name LIKE ('%cntrkf%') 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 ('e34'), 100, 0) + IF (products_name LIKE ('e34%'), 80, 0) + IF (products_name LIKE ('%e34'), 60, 0) + IF (products_name LIKE ('%e34%'), 40, 0) + IF (products_model LIKE ('%e34%'), 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 ('e30'), 100, 0) + IF (products_name LIKE ('e30%'), 80, 0) + IF (products_name LIKE ('%e30'), 60, 0) + IF (products_name LIKE ('%e30%'), 40, 0) + IF (products_model LIKE ('%e30%'), 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 ('%e34%') AND pov.language_id = '1' )  AND  ( pov.products_options_values_name LIKE ('%e30%') 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 ('e34'), 100, 0) + IF (products_name LIKE ('e34%'), 80, 0) + IF (products_name LIKE ('%e34'), 60, 0) + IF (products_name LIKE ('%e34%'), 40, 0) + IF (products_model LIKE ('%e34%'), 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 ('e30'), 100, 0) + IF (products_name LIKE ('e30%'), 80, 0) + IF (products_name LIKE ('%e30'), 60, 0) + IF (products_name LIKE ('%e30%'), 40, 0) + IF (products_model LIKE ('%e30%'), 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 ('%e34%')  )  AND  (  specification like ('%e30%')  )  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 ('e34'), 100, 0) + IF (products_name LIKE ('e34%'), 80, 0) + IF (products_name LIKE ('%e34'), 60, 0) + IF (products_name LIKE ('%e34%'), 40, 0) + IF (products_model LIKE ('%e34%'), 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 ('e30'), 100, 0) + IF (products_name LIKE ('e30%'), 80, 0) + IF (products_name LIKE ('%e30'), 60, 0) + IF (products_name LIKE ('%e30%'), 40, 0) + IF (products_model LIKE ('%e30%'), 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 ('%e34%')  )  AND  (  pe.products_extra_fields_value LIKE ('%e30%')  )  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<br>
ERROR: Unknown column 'rev_rang' in 'order clause'<br>