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(10939740,10939744,10989202,10989203,10989204,7068773,7068774,7068775,7068776,7068777,7068778,7068779,7068780,7068781,10940519,4971139,8066947,7074329,8067324,8067650,8067652,10977407,10977408,10977409,10977410,10977411,10977412,10977413,10977414,10977415,10977416,10977417,11016511,11016512,10964550,10964581,10964606,8068029,7075284,7075291,8068260,8068317,8068323,8068324,8068326,8068328,8068332,10975150,10975152,10975157,10975169,10975177,8068400,10975195,10975203,10975206,10975208,10975217,10975220,11027221,10975234,10975240,10975241,10975244,10975249,10975268,10975272,10975274,10975282,10975303,10975309,10975310,10975316,10975317,10975321,10975325,10975350,10975352,10975361,10975362,7067686,10975390,8068627,8065255,8065350,10973171,10973172,10973173,8075289,10932192,10932265,10932293,8066216,8066424,11000193,11000207,11000212,11000213,11000214,10932949,8066626,8066652,8066829,8066833,10997870,10997871,10943150,10943151,10998413,10998414,10998420,10998421,10998452,10998453,10998454,10998455,10998456,10998457,10998458,10998459,10998460,10998461,10998462,10998477,10998478,10998479,10998505,10998506,10998507,10982620,10982621,10982622,10982623,10982624,10982625,10982626,10982627,10982628,10982629,10982630,10982631,10982632,10982633,10982634,10982635,10982636,10982637,10982638,10982639,10982640,10982641,10982642,10982643,10982644,10982645,10982646,10982647,10982648,10982649,10982650,10982651,10982652,10982653,10982654,10982655,10982656,10982657,10982658,10982659,10982660,10982661,10982662,10982663,10982664,10982665,10982666,10982667,10982668,10982669,10982670,10982671,10982672,10982673,10982674,10982675,10982676,10982677,10982678,10982679,10982680,10982681,10982682,10982683,10982684,10982685,10982686,10982687,10982688,10982689,10982690,10982691,10982692,10982693,10982694,10982695,10982696,10982697,10982698,10982699,10982700,10982701,10982702,10982703,10982704,10982705,10982706,10982707,10982708,10982709,10982710,7069026,10982711,10982712,10982713,10982714,10982715,10982716,10982717,10982718,10982719,10982720,10982721,10982722,10982723,10956724,10982724,10982725,10982726,10982727,10982728,10982729,10982730,10982731,10982732,10982733,10982734,10982735,10982736,10982737,10982738,10982739,10982740,10982741,10982742,10982743,10982744,10982745,10982746,10982747,10982748,10982749,10982750,10982751,10982752,10982753,10982754,10982755,10982756,10982757,10982758,10982759,10982760,10982761,10982762,10982763,10982764,10982765,10982766,10982767,10982768,10982769,10982770,10982771,10982772,10982773,10982774,10982775,10982776,10982777,10982778,10982779,10982780,10982781,10982782,10982783,10982784,10982785,10982786,10982787,10982788,10982789,10982790,10982791,10982792,10982793,10982794,10982795,10982796,10982797,10982798,10982799,10982800,10982813,11008818,10982868,7069241,7069242,7069253,10969994,10983147,10983200,10996223,10996224,10996225,10983246,10996271,10996272,10996273,10983286,10983466,10983491,10983492,11022761,3656662,3656663,3656664,3656665,3656666,10983992,10984013,7070752,11010576,10923650,10923654,11019806,11019807,10923855,10923856,10923857,10923858,10923859,10923860,10923861,10923862,10923863,10618385,10618386,10618387,10623491,10623492,10924063,10981243,10924097,10924098,10924099,10924100,10924101,10924102,10924103,10924104,10924105,10924106,10618674,10618889,11020568,11020667,11020672,10924560,10619149,10619150,10619356,10919893,10969071,10969087,10969089,10969094,10925101,10925102,10925103,10925104,10925109,10925110,11021465,11021467,11008594,10982596,10982602,10982603,10982604,10982605,10982606,10982607,10982608,10982609,10982610,10982611,10982612,10982613,10982614,10982615,10982616,10982617,10982618,10982619,10621977,10621993,10621994,10621995,10621996,10617124,11005790,11005791,11005875,11005876,11005877,11005968,11005969,11005995,10622360,10622363,11006024,10622367,11006051,11006053,11006054,11006056,11006059,11006064,11006066,11006083,11006091,11006092,11006093,11006094,11006095,11006102,11006109,11006128,11006154,11006155,11006205,11006206,11006207,11006208,11006209,10617573,11006277,11006318,11006386,11006411,10928352,11006572,10920600,10920634,10615245,10620411,10620413,10920964,10920965,10965126,10920978,10920979,10920980,10926110,10926186,10926187,10926188,10926189,10926190,10926191,10926192,10926193,10926194,10926195,10926196,10926197,10926198,10926199,10926200,10926201,10926202,10926203,10926204,10926241,10616089,10921617,10926711,10926712,10616234,10978944,10616335,10621438,10616544,10621658,10621708,10979400,10979412,10979413,10979414,10979415,10979416,10979417,10979418,10979419,10979420,10979421,10979422,10979423,10979424,10979425,10979426,10979427,10979428,10979429,10953460,10953461,10922322,10922327,10559345,10559346,10559347,10559348,10559351,10559352,10559353,10559355,10559356,9181720,9189746,10614452,10614453,10614454,10611475,10611641,10611642,10611643,10611644,9166042,9174066,10614744,9174089,9174090,10566067,10566068,10566069,10566070,9179332,9179333,9179334,9187351,7057541,10609400,10609401,10612403,10557618,9180112,9172201,9188279,9188281,9188282,9188283,10609954,10612963,8862849,8862860,8862869,8862870,8862875,10613056,10613057,10613058,10613066,10613108,10610245,9172678,10558665,10558680,9180926,9180943,9180944,9180945,9180946,9180947,9180948,9180949,9181024,9181025,9181026,9181027,9181028,9181029,9181030,9181031,9181042,9181043,9181060,9181061,9181062,9181063,9181064,9181065,9181066,9181067,9181068,9181069,10564882,9181070,9181071,9181072,9181073,9181074,9181075,9181076,9181077,9173080,9181132,9181133,10613832,10515113,10515114,4974625,4974648,4974649,9169834,9169835,10517681,9178025,9178026,9178027,9178028,9178029,9178030,9178031,9178032,9178033,9178034,9178035,9170048,7056588,7056589,9186754,7057020,7057021,7057022,7057023,7057024,7057025,7057026,7057058,10512770,10514784,10514845,10514846,10514847,10514848,10514849,10514850,10512852,10514893,10514894,8918051,10417363,10417389,9168504,10415487,10416516,7054864,7054865,10419688,10415882,8864925,8864929,8864930,8864931,8864932,8864933,8864934,8864935,8864936,8864937,8864938,8864939,8864940,8864941,8864984,9174514,10467110,10467111,10467112,10467128,10463327,10463337,10463429,10467437,6666867,6666868,9183009,10467628,4971942,4971943,4971944,4971945,4971946,4971947,10463753,10463780,10465805,10463882,10465911,10464042,8917219,10466321,10466322,10466323,10464350,10464351,10468393,10468394,10468395,10468396,10468397,10468398,10462410,10462411,9167854,10462436,10462437,10462489,9168028,9168096,10174627,10628239,10169767,10628266,10628267,10174812,10169853,10169856,10169967,10175066,10165194,10160289,10170304,10170312,10170317,10170336,10170337,10170338,10170339,10170340,10170341,10170342,10170343,10170344,10170345,10170346,10170347,10170348,10170349,10170350,10170351,10170352,10170353,10170354,10170355,10170356,10170357,10155357,10170358,10170359,10170360,10170361,10170385,10170412,10155415,10170457,10170464,10170472,10170473,10170691,10171041,10629586,10629608,10629610,10629661,10629664,10629666,10163535,10158720,10163787,10627297,10627298,10158873,10158878,10168920,10168921,10168922,10168923,10168924,10168925,10168926,10168927,10168928,10168929,10168930,10168931,10168932,10168933,10168934,10168936,10168944,10168992,10174022,10174023,10630051,10166885,10172141,10167320,10167321,10167322,10167323,10167435,10167441,10631013,10626227,10167753,10631277,10167941,10168139,10158248,10158276,10158306,10158346,10173360,10626841,10580565,10583813,10583814,10583901,10583902,10568937,10584020,10584021,10584022,10584023,10584024,10584025,10584026,10584027,10584028,10584029,10584030,10584031,10584032,10584033,10584034,10584035,10584036,10584037,10584038,10584039,10584040,10584041,10584042,10584043,10584044,10584045,10584046,10584047,10584048,10584049,10584050,10584051,10584052,10584053,10584054,10584055,10584056,10584057,10584058,10584059,10584060,10584061,10584062,10584063,10584064,10584065,10584066,10584067,10584068,10584069,10584070,10584071,10576229,10576254,10576255,10576256,10576257,10576258,10576295,10576380,10523676,10521865,10524347,10524348,10528357,10528358,10522498,10522502,10522503,10522654,10520862,10520889,10520890,10520911,10520912,10520913,10527005,10422526,10420568,10420586,10420587,10420588,10420589,10420591,10420592,10420595,10420596,10420598,10424654,10423980,10423983,10423984,10423985,10423031,10481039,10481042,10481045,10481049,10481051,10481053,10481058,10481067,10481076,10481077,10481086,10481087,10481094,10481095,10481108,10481109,10481110,10481121,10481122,10481123,10481124,10481125,10481126,10481131,10481138,10481139,10481152,10481159,10481160,10481163,10481164,10481192,10481193,10481212,10481213,10481214,10481222,10481229,10477237,10481238,10481242,10473350,10479854,10480041,10480130,10480131,10480135,10480136,10480142,10480143,10480151,10480152,10472303,10476536,10476599) 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'