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(10939732,10939794,7068160,10943690,7068232,7068266,7068267,7068268,10939985,7068296,7068329,4970918,10940400,10940401,4971026,7068800,7068801,7068802,7068803,7068804,10940520,7068805,10940521,10940522,10940523,10940524,10940525,10940526,10940527,10940528,10940529,10940530,7065857,8066953,7065954,4968615,8067509,10437405,7066598,7066599,7066698,7066793,7066800,10938729,10938730,7067044,7067171,7067239,7067282,7067283,7067284,7067285,7067541,7067542,8068603,8068604,8068605,8068606,8068607,8068608,8068609,8068610,8068611,8068612,8068613,8068614,8068615,8068616,8068617,8068618,8068619,8068620,8068621,8068622,8068623,8068624,8068625,8068626,8068627,8068628,8068629,8068630,8068631,8068632,8068633,8068634,8068635,8068636,8068637,8068638,8068639,8068640,8068641,8068642,8068643,8068644,8068645,8068646,8068647,8068648,8068649,8068650,8068651,8068652,8068653,8068654,8068655,8068656,8068657,8068658,8068659,8068660,8068661,8068662,8068663,8068664,8068665,8068666,8068667,8068668,8068669,8068670,8068671,8068672,8068673,8068674,8068675,8068676,8068677,8068678,8068679,7067814,7067815,6000112,6000113,10931720,7064341,7064342,7064477,7064478,7064479,10932072,10932244,10932290,10932291,10932292,10932293,10932294,10932295,10932296,10932297,10932298,10932299,10932300,10932301,10932302,10932303,10932304,10932319,10932320,10932321,10932323,10932324,10932326,10932327,10932328,10932329,8065986,8066013,8066189,10932579,10932644,10932645,8066286,8066287,8066288,8066289,8066290,8066291,8066292,8066293,8066294,8066295,8066296,8066297,8066298,8066299,8066300,8066301,8066302,8066303,8066304,8066305,10932681,10932690,10932733,10932741,7065351,7065352,10932803,10932820,10932821,10932822,10932834,10932835,8066565,8066566,8066567,8066568,8066569,8066570,8066571,8066572,8066573,8066574,8066575,8066576,8066577,8066578,8066579,8066580,8066581,8066582,8066583,8066584,8066585,8066586,8066587,8066588,8066589,8066590,8066591,8066592,8066593,8066594,8066595,8066596,8066597,8066598,8066599,8066600,8066601,8066602,8066603,8066604,8066605,8066606,8066607,8066608,8066609,8066610,8066611,8066612,8066613,8066614,8066615,8066616,8066617,8066618,8066619,8066620,8066621,8066622,8066623,8066624,8066625,8066626,8066627,8066628,8066629,8066630,8066631,8066632,8066633,8066634,8066635,8066636,8066637,8066638,8066639,8066640,8066641,8066642,8066643,8066644,8066645,8066646,8066647,8066648,8066649,8066650,8066651,8066652,8066653,8066654,8066655,8066656,8066657,8066658,8066659,8066660,8066661,8066662,8066663,8066664,8066665,8066666,8066667,8066668,8066669,8066670,8066671,8066672,8066673,8066674,4967941,8066675,8066676,8066677,8066678,8066679,8066680,8066681,8066682,8066683,8066684,8066685,8066686,8066687,8066688,8066689,8066690,8066691,8066692,8066693,8066694,8066695,8066696,8066697,8066698,8066699,8066700,8066701,8066702,8066703,8066704,8066705,8066706,8066707,8066708,8066709,8066710,8066711,8066712,8066713,8066714,8066715,8066716,8066717,8066718,8066719,8066720,8066721,8066722,8066723,8066724,8066725,8066726,8066727,8066728,8066729,8066730,8066731,8066732,8066733,8066734,8066735,8066736,8066737,8066738,8066739,8066740,8066741,8066742,8066743,8066744,8066745,8066746,8066747,8066748,8066749,8066750,8066751,8066752,8066753,8066754,4968048,4968049,4968050,4968051,4968052,4968053,4968054,4968055,4968056,4968057,4968058,4968059,10942638,8861253,8861312,10943148,8064657,8064658,8064659,6000025,6000026,6000027,6000028,3655607,3655608,3655609,3655610,3655611,10944926,8072411,8072412,8072420,8072422,8072454,8072683,8072684,8072685,8072686,8072687,3656657,3656670,3656688,3656689,3656690,3656691,8072996,8072997,8072998,8072999,8073000,10942151,8860401,8860406,8860407,8860408,8860409,8860474,8860475,8860476,8073439,8860540,10942409,8860658,10942498,10918488,10918489,10918509,10918510,10623042,10623044,10623045,10918588,10918589,10918699,10918737,10918774,10918775,10918776,10918777,10918778,10918779,10918780,10918781,10918782,10623320,10918846,10918847,10918848,10918849,10918852,10918853,10918854,10918855,10918856,10623414,10919214,10919215,10919216,10919217,10919218,10919219,10919220,10919511,10919512,10919569,10919570,10919571,10919572,10919573,8070811,8070854,10919845,10919902,10919909,8071124,8071125,10920000,10920001,10920002,10920102,10920103,10920104,10920105,10920106,10920107,10920108,10920109,10622191,10917710,10917711,10927805,10622371,10622372,10622373,10622374,10622375,10917905,10917906,10917907,10917908,10917909,10918001,10918002,10918024,10622548,10918125,10918126,10918127,10918128,10918129,10918130,10918286,10918287,10918288,10918338,10918339,10925487,10920520,10920521,10620033,10915699,10915700,10915701,10915702,10915703,10915704,10920856,10920857,10920858,10920859,10920966,10920967,10920981,10620488,10921044,10921045,10921046,10921047,10921048,10921049,10921050,10921051,10921052,10921053,10926167,10926168,10926169,10926202,10926203,10921241,10921242,10921243,10921244,10921245,10921246,10921247,10926253,10921259,10921260,10921261,10926284,10921397,10921568,10621110,10621111,10921621,10621112,10621113,10621114,10621115,10921698,10921736,10621284,10621285,10621286,10621287,10921862,10921863,10621439,10621440,10621441,10621442,10621443,10621444,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621453,10621454,10621455,10621456,10621457,10621458,10621459,10621460,10621461,10621462,10621463,10621464,10621465,10621466,10621467,10621468,10621469,10621470,10621471,10621472,10621473,10621474,10621475,10621476,10621477,10621478,10621479,10621480,10621481,10621482,10621483,10621484,10621485,10621486,10621487,10621488,10621489,10621490,10621491,10621492,10917032,10917033,10917069,10917071,10917072,10917073,10917074,10917075,10917076,10621716,10922259,10922260,10922261,10922285,10922286,10922287,10922288,10611123,10565335,10565336,10565337,10559392,10559471,10559472,10559473,10559474,10559475,10559486,10559492,10559493,10559494,10559495,10559496,10559497,10614357,10611372,10614403,10614404,10614405,10565608,10565609,10565610,10565611,10565612,10565613,10565614,10565615,10565616,10565617,10565618,10565619,10565620,10565621,10565622,10565623,10565624,10614572,10614634,10614636,10611714,10614730,10611763,10614778,10614799,10614800,10614849,10614857,10614862,10612260,10609443,10609444,10557639,10612513,10612586,10612677,10612683,10612713,10609816,10609843,10612908,10609922,10609923,10609924,10609976,10558322,10558324,10558325,10558326,10558327,10558328,10558329,10558330,10558331,10558332,10558333,10558334,10558335,10558336,10558337,10558338,10558339,10558340,10558341,10558342,10558343,10558344,10558345,10558346,10558347,10558348,10558349,10558350,10558351,10558352,10558353,10558354,10558355,10558356,10558357,10558358,10613210,10558366,10558367,10558368,10558369,10558370,10558371,10558372,10558400,10558401,10558402,10558403,10558404,10558405,10558406,10558407,10558408,10558415,10558416,10558417,10558418,10558419,10558420,10558421,10558422,10558423,10558424,10558425,10558426,10558427,10558428,10558429,10558430,10558431,10558432,10558433,10558434,10558435,10613384,10613386,10558612,10558613,10564634,10564635,10613488,10564655,10613551,10613569,10613613,10564774,10564775,10613665,10613669,10613671,10613674,10564826,10564827,10513120,10555356,10555357,10555358,10555808,10555809,10513810,10555810,10513811,10513812,10513813,10513953,10555954,10555964,10555965,10555966,10555967,10555968,10518144,10512577,10512789,10512790,10512791,10512802,10512822,10512823,10512824,10512825,10512826,10512827,10512828,10512829,10518996,10518997,10518998,10518999,10419272,10419274,10419275,10419276,10419278,10419279,10419280,10419281,10419282,10419284,10419293,10419294,10415296,10415297,10415298,10419299,10415299,10415320,10415322,10415326,10419339,10419340,10419341,10419370,10415381,10417390,10417394,10417396,10417398,10417402,10419539,10419540,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10416553,10419555,10419557,10415623,10415626,10416657,10419686,10419689,10415814,10419828,10419829,10419830,10419831,10415871,10415872,10415946,10415973,10416992,10417011,10420064,10416093,10420109,10416135,10416136,10417158,10417159,10416164,10416165,10463005,10463011,10463043,10463046,10463434,10471490,10471493,10471494,10463718,10463719,10463720,10463721,10463722,10463723,10463724,10463725,10463726,10463727,10463736,10465748,10465749,10465750,10465751,10465752,10463753,10463764,10463767,10463790,10465791,10463792,10463793,10465803,10465804,10465812,10465813,10463833,10469984,10469985,8563324,8563335,10470079,10462400,10462412,10462413,10462414,10470485,10462525,10462526,10462530,10462531,10470667,10462728) 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'