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_quantity_step,
p.products_price,
p.products_price_small_opt,
p.products_price_opt,
p.products_purchase_price,
p.small_opt_purchase_price,
p.count_small_opt_purchase_price,
p.count_opt_purchase_price,
p.opt_purchase_price,
p.postavshik,
p.suplier_catalog_id,
p.postavshik_comment,
p.name_catalog_id,
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 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 p.products_id IN(7067936,10962690,10962693,10962694,10943433,7068053,10939708,10939709,11001800,11001801,11001802,10988874,10988889,10988890,10988891,10988892,10988922,10988923,7076285,10989060,10989061,11002166,10944076,4971137,4971138,10963635,10963636,7065994,7074056,7066174,7074211,7074212,8067414,8067415,11016242,11016243,11016244,11016245,7066745,7066824,10964518,10964519,10938479,10964546,8067906,11013743,11013777,11013778,7067206,11013903,7067221,7067222,7067223,11026958,10962082,10962113,10962139,7075517,7067609,10962311,10962450,10939533,10939534,7067934,7067935,6000288,7064055,7064071,10985759,10985760,10985761,8065208,8065209,8065210,7064298,10999127,10999128,10931826,10931827,10960225,11012240,11012241,11012242,11012243,11012244,11012245,11012246,10973287,11012346,11012347,11012348,11012353,11012354,11012355,11012356,10960456,11012496,11012497,11012498,11012499,4967055,10932303,10999676,11012822,11012823,11012824,11012825,11012826,11012827,11012876,11012877,11012878,10999973,7065339,4967819,4967820,4967821,4967822,4967823,4967824,4967825,4967826,11013294,11013295,11013296,11013297,11013298,11013309,11013310,10933070,10933071,10961420,10933087,10933088,10933090,11013430,10933095,10933096,11013438,11013439,11013440,11013441,11013442,11013443,11013444,10933108,11013445,7073761,10933109,11013446,10933110,11013447,11013448,11013449,11013450,11013451,11013452,11013453,11013454,11013455,11013456,11013457,11013458,11013459,11013460,11013461,11013462,11013463,11013464,11013465,11013466,11013467,11013468,11013469,7073884,7073888,11013581,11013590,11013591,10942776,10997870,10997871,10997879,7071260,7071261,7071262,7071263,7071264,8064252,8064253,8064254,8064255,8064256,8064257,8064258,7071360,11049279,8064478,10943133,10943134,8064520,8064521,8064522,7071577,11011284,11011285,11011286,11024320,11024321,11024322,11024323,5999978,5999979,5999980,5999981,10998414,11011455,10998455,10998461,10998462,10998477,10998478,11011491,7071813,6000121,6000213,10995880,10995881,10995882,10940941,7069408,10944888,10996184,10996228,10996229,10996241,10996242,3656138,10996282,11047601,11047602,11047603,11009399,11047627,11047628,11047629,11047630,10996560,10996561,10996562,8072649,8072654,8072669,8072674,8072694,3656635,10941706,11022851,3656740,10996893,10996894,10941943,10941944,10958036,11023062,11023063,11048313,7070660,10971364,11048593,10971389,10997390,10971390,11049567,7070815,10958565,10958566,10958569,11049730,11019662,11019663,11019664,10967954,10618360,10618361,11020152,11020153,11020154,10994370,10994372,10623767,10623768,10623769,10623770,8071012,10995298,10995299,10995300,10995301,10995302,10995303,10995304,10995305,11008594,10953620,10927481,11005659,11005670,11005671,11005672,11005673,11005674,11005675,11005676,11005677,11005678,11005679,10922585,10922586,10922587,10922588,10922589,10922600,10992791,10992792,11005846,10617212,11005990,10954024,11006164,11006165,10617520,10617573,11006347,11006348,11006458,11006459,11006460,11006487,11006488,11006489,11006490,11006550,11006574,11006575,10615038,10615039,10620072,10920598,10920599,10920600,8570043,10920619,10615111,10615205,10615225,8570218,8570219,10620303,8570273,10991073,10991074,10991075,10991076,11004162,11004163,10926027,10926064,11004220,10620584,10620585,11004269,11004270,11004275,11004276,10965287,10991341,10930669,11004414,10965456,11004461,10930737,11004501,10991521,10991522,10991523,10991524,10991525,10615880,11004647,10991679,11004709,10991749,10991755,11004755,11004756,11004757,10991786,10952825,10952826,10952827,10978881,10616240,10952903,10952904,10952905,10952906,10953099,10953100,10953101,10953102,10953103,10953104,10953105,11005134,10953151,10953152,10953153,10953154,10616572,10953319,10616701,11005412,10953426,10953427,10953428,10953429,10616870,10616895,10927446,10922458,9189327,10610995,10610996,10611052,10611099,9189446,10565320,10565321,10565322,10565323,10562334,7059748,7059749,10614316,9189717,9189718,9189719,9189721,8864244,9189722,9189723,8864245,10611386,10611392,10611393,10611394,10611406,10611407,10611408,10611410,10611415,10611416,10611417,10611418,10611419,10611422,10611424,10611425,10611426,10611431,10611437,10611438,10611440,10559619,10559620,10559621,9173817,10614524,9173865,10611671,10611700,8864588,9166229,9166230,9166231,10566061,10566062,8864776,9171587,9171588,8862157,10609306,10612381,10612418,10612885,10612961,9188328,9188329,9188330,9188331,10610021,10610059,9188410,9188414,10613087,10613088,10613098,9172464,9172535,9164590,9164591,9164592,9164593,9164594,9164595,9188650,9188651,9172750,10558622,8863567,9173046,10610780,10610781,9161322,9169407,9161480,9161535,9169553,10515526,10515527,4974609,4974610,4974660,4974661,4974662,4974686,4974687,9169838,10517670,7056051,10515742,10515743,10515744,9170011,10513866,10513867,10513868,10513869,10513870,10513871,10513872,10513900,10513901,10513902,9170214,9170215,9170216,9170217,10514074,10514075,10514076,10514077,10514078,10514079,10514080,10514081,10514082,10514083,10514084,10514085,10514086,10514087,10514088,10514089,4975159,2809138,10516597,10516598,10516599,10516600,10516601,10516602,10516603,10516604,10516605,8861637,10513071,10513072,10513073,10513074,8861799,9160350,9160372,9160415,9160453,9160454,8918103,4973399,4973400,4973401,4973402,4973403,4973404,10415491,10415492,4973428,4973442,10416511,8918247,10416535,9176661,9160785,9160788,9160789,9160790,9168791,10416934,9161056,9177060,9161135,9161136,9161137,9161138,9161139,9161140,9161141,4974082,4974083,4974084,8864860,8864861,8864877,8864895,4971317,6666507,6666508,10463184,10463308,10463309,10463310,4971643,10469587,10469602,9175162,9175163,9175164,9175165,10465754,8916893,8916911,8916912,8916990,8563248,10469942,8917019,10469969,8563415,8917309,4972544,4972545,4972546,8917342,8917343,6667722,6667723,9167973,10462741,9168169,9168183,10468768,9176196,10468838,10468839,10468840,10468841,10468842,10159487,10159495,10159496,10159497,10159498,10159499,10159502,10159717,10159718,10159973,10159974,10159975,10159976,10159977,10155338,10155339,10155340,10155341,10155342,10155343,10155503,10155504,10629291,10629292,10155832,10155833,10629350,10629351,10629358,10629359,10629360,10629361,10629364,10629365,10629578,10629579,10166143,10156207,10156208,10626986,10158703,10158704,10168839,10153898,10153899,10153900,10153901,10153902,10153903,10153904,10153905,10153906,10153907,10168908,10168909,10168910,10168911,10164044,10164079,10627713,10627714,10164281,10154303,10154304,10154316,10154317,10154318,10161950,10625928,10625929,10625930,10625935,10625936,10167482,10162488,10167632,10626475,10626476,10626477,10626478,10626479,10626480,10626483,10626486,10626487,10163283,10168309,10163477,10163481,10570058,10570059,10570060,10570061,10570062,10570063,10570064,10570065,10570066,10567362,10567365,10567366,10570481,10567692,10567693,10567704,10567709,10567710,10579829,10525156,10525157,10521618,10521621,10521622,10521623,10521624,10521625,10521626,10521627,10521628,10521629,10521630,10521631,10521885,10521886,10528617,10528618,10528619,10528620,10528621,10528646,10520746,10520747,10520748,10520749,10520750,10520761,10520762,10524870,10528907,10528908,10528909,10422230,10422231,10422232,10422233,10422240,10422270,10422271,10420277,10423534,10423550,10420664,10423958,10422049,10422050,10474893,10474894,10474895,10474902,10474903,10474904,10474911,10474912,10474913,10474914,10474915,10474916,10474917,10474921,10474922,10474925,10474926,10474927,10474931,10474932,10474937,10474941,10474942,10474943,10474944,10474951,10474952,10474957,10474958,10480971,10480972,10480973,10480974,10474974,10480975,10480976,10480977,10480978,10474978,10480979,10474979,10474980,10474984,10474990,10474991,10474994,10474995,10474996,10475058,10475059,10475060,10475061,10475062,10475063,10475064,10475065,10475066,10475067,10475068,10475069,10475070,10475071,10475072,10475073,10475074,10475075,10475076,10475077,10475078,10475079,10475080,10475081,10475082,10475083,10475084,10475085,10475086,10475098,10475103,10475104,10475105,10475106,10477152,10475183,10475185,10475186,10475189,10475190,10475191,10475197,10475198,10475199,10475202,10475205,10475206,10475210,10475211,10475212,10475214,10475215,10475216,10475217,10475218,10475219,10475220,10475221,10475222,10475224,10475225,10476142,10476143,10478401,10476424,10476428,10476528,10476529,10476530,10476531,10476532,10474647,10474648,10474649,10474650,10474652,10474653,10474658,10474660,10474661,10474662,10474663,10474666,10474667,10474668,10474669,10474673,10474674,10474675,10474676,10474677,10474678,10474685,10474686,10474690,10474691,10474694,10474695,10474696,10474700,10474711,10474712,10474713,10474714,10474715,10474716,10474717,10474718,10474719,10474720,10474721,10474722,10474723,10474724,10474725,10474726,10474727,10474728,10474729,10474730) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'