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(7075880,10198316,10198317,10198318,7076115,7076160,10224407,10224439,10224440,10224550,10224582,10224770,4970927,7066054,10264311,10264312,10264313,10264314,10264315,10264316,10264317,10264318,10264319,10264320,10264379,10264380,10264381,10264382,10264383,10264384,10264385,10264386,10264387,10264388,7074181,7074182,10437220,10251816,10262123,10262126,7066888,7066910,10262168,8834982,8834986,10262264,7067033,7067034,7067035,7067045,7067067,7067068,7067069,7067070,10262402,7075219,10197598,10197711,10197712,7075546,10249877,10210939,7067734,10247285,10247286,10234399,10234416,10234417,10931676,10931696,10931712,7064312,7064316,10234715,10234716,10234717,10234726,10234727,10221740,10221741,10221762,7072524,10221798,10208862,10208863,10221864,10208864,10208865,10221866,10208866,10208867,10208868,10208869,10208870,10208871,10208872,10208873,10208874,10208875,10208876,10208877,10208878,10208879,10208880,10208881,10208882,10208883,10208884,10208885,7072648,10208886,10208887,10208888,10208889,10208890,10208891,10208892,10208893,10208894,10208895,10208896,10208897,10208898,10208899,10208900,10208901,10208902,10208903,10208904,10208905,10208906,10208907,10208908,10208909,10208910,10208911,10208912,10208913,10208914,10195952,10260977,7072739,10260978,10260979,10221979,10260980,10260981,10260982,10261002,7072842,7072932,10209215,10209216,10274222,10274223,10235241,10235242,10235246,7073028,10209350,10209353,10209354,10235359,10209425,10222453,10222454,10248614,10248615,10248616,10248617,10248618,7073409,10932865,10261721,4967842,4967843,4968139,10262052,10259135,10259136,10259137,10259138,10259139,10259140,10259141,10259257,10259258,10259259,10259260,10259264,8860932,10207292,10207293,10207294,10207295,10207302,10207303,7071154,7071195,8861101,10207446,10207710,10272781,10272782,10272783,10272784,10272785,10207914,10207915,10272932,10220933,10220934,10220935,10259945,10259946,10259947,10259948,10259949,10259950,10259951,10259952,10259953,10259954,10259955,10259956,8563947,7071734,7071736,10272977,10273000,10944371,10944372,10944373,10283338,10283339,10244346,10244347,10244348,10244361,10940857,10244778,10244786,10244787,10283835,10283836,10270921,10270922,10270923,10244970,10206052,10206053,10206054,10206055,10206056,10206075,10206076,10206077,10206078,10206079,10232523,10271625,10232637,10232638,10232639,10232640,10206667,10245821,8860535,8860547,10942425,10232969,10942447,10232970,10232971,10232972,10232973,10232974,7070774,10242073,10618084,10242357,10623369,10623460,10623491,10623492,10268704,10268705,10268706,10268707,10268708,10268709,10268710,10268711,10268712,10268721,10242769,10242770,10204059,10269127,10269128,10269132,10282284,10619257,10619258,10282372,10269464,10269465,10269466,10269467,10269530,10269531,10282806,10282810,10282811,10624731,10624732,10243841,10243942,10243943,10243950,10619893,10257035,10257036,10257037,10257038,10257039,10257040,10257041,10257042,10257043,10257044,10617045,10617046,10241587,10241803,10241804,10241805,10241806,10241807,10241808,10228838,10254881,10241932,10241933,10268006,10268007,10268008,10268009,10268010,10268011,10268012,10268013,10268014,10268015,10268016,10268043,10268044,10200134,10200135,10200136,10200137,10200138,10200139,10200140,10200141,10200142,10200143,10200144,10200145,10200146,10200147,10200148,10200149,10200150,10200151,10200159,10620096,10200220,10200221,10200222,10200223,10200224,10200225,10200226,10200227,10200228,10200229,10200230,10200231,10200232,10200233,10200234,10252308,10200404,10200405,10200406,10200407,10200408,10200409,10200410,10200411,10200412,10200413,10200414,10200415,10200416,10200417,10200418,10200419,10200420,10200421,10200422,10200423,10200424,10200425,10200426,10200427,10200428,10200429,10200430,10200431,10200432,10200433,10200434,10200435,10620343,10620344,10200436,10200437,10620345,10200438,10200439,10620365,10921020,10921021,10921022,10615527,10921158,10921159,10921160,10921161,8570490,10926175,10926176,10239830,10926278,10926285,10921303,10921304,10921305,10921306,10930664,10279115,10253272,10253322,10253341,10921833,10921834,10926840,10266534,10266535,10266536,10266537,10266538,10266539,10266540,10266541,10266542,10240543,10266543,10266544,10266545,10240570,10240571,10253574,10253575,10253577,10240601,10266621,10266622,10266623,10266624,10266625,10266626,10266627,10266628,10266629,10266630,10266631,10266632,10266633,10266634,10266635,10266636,10927063,10279965,9189344,9173357,9173358,9173359,9173360,9173361,9173362,9173363,9173419,9173420,9173421,9173422,9173423,9173424,9173425,9173426,9173475,9173476,9173477,9173478,9173479,9173480,9173481,9173482,9173483,9173484,9173485,10614229,10614471,10614514,10614515,9190034,9190068,9195340,9195341,9203622,9203623,9203724,9203725,9203726,9203727,9203728,9187756,10557585,9179835,10612518,10612555,9203910,9188037,9188038,9188042,9180061,9196062,9172145,9172397,9204541,7058710,9204562,9204633,9204711,9204712,9204713,10561582,10561586,10561587,10561592,10561593,10561594,10561595,10561608,10561609,10561610,10561621,10561640,10561641,10561644,10561645,10561650,10561651,10561652,10561662,10561663,10561664,10561670,10561671,10561683,10561684,10561685,10561686,10561687,10561688,10561689,10561690,10561691,10561692,10561693,10561699,10561711,10561731,9172939,9189078,9189211,8863797,10517145,10517146,10517147,10517148,9201418,9193468,9193469,9161598,9193741,9161795,10513747,9194013,9194014,9202164,10517993,10517994,10517995,10517996,10517997,10517998,10517999,10518000,10518001,10518002,10518003,10518004,10518005,10518006,10518007,10518008,10518009,10518010,10518011,10518012,10518013,10518014,10518015,10518016,10518017,10518018,10518019,10518020,10518021,10518022,10518023,10518024,10518025,10518149,10518150,10518151,10518152,10518153,10518154,10518155,9202353,9202361,9202498,9202499,9194543,9194545,10518489,9194676,10518490,10518491,10518492,10518493,10518494,9202682,10518495,9202683,10518496,9202684,10518497,10518498,10518499,10518500,10518501,9202689,10518502,9202690,10518503,10518504,10518505,10518506,10518507,10518508,10518509,10518510,10518511,10518512,10518513,10518514,10518515,10518516,10518517,10518518,10518519,10518520,10518521,10518522,10518523,10518524,10518525,10518526,10518527,10518528,10518529,10518530,10518531,10518532,10518533,10518534,10518535,9194762,9194785,9202794,9195009,9195010,9203015,9203016,9171167,10516984,10516985,10516986,9171197,9160302,8918054,10417355,4973307,9200553,9200554,9200555,9200557,9176557,9200561,9176578,9184580,8918243,9184600,8918265,8918266,9184619,9184620,9176637,9200644,9176729,9176730,7054927,9200794,9200795,9200871,9176905,9176940,9176941,9176942,9176943,9169205,8864917,8864970,8864975,8864985,9182604,9182613,8865206,6666729,9166801,9166802,9174841,9198933,9183021,9183048,8917295,9175888,9199913,9167964,10470551,9200130,9200131,9200141,9200142,9200143,9168156,6668176,9200196,9200197,9200198,10179591,10174697,10164719,10164720,10164721,10164722,10164723,10164724,10164832,10165000,10165303,10165304,10165307,10165308,10180332,10180333,10180334,10180335,10180344,10180345,10180346,10180347,10180348,10180349,10155362,10155363,10155364,10155365,10628921,10180766,10180767,10180768,10180774,10180775,10180776,10180777,10165806,10165807,10165808,10165809,10170900,10181073,10181079,10181080,10181081,10181082,10181083,10181084,10166135,10166208,10166209,10181345,10181346,10181347,10181348,10181349,10181350,10181351,10181352,10181356,10183515,10183516,10632059,10632060,10632061,10632062,10632063,10183700,10183701,10183702,10183779,10184193,10174413,10166585,10181597,10181598,10181604,10181605,10176676,10166993,10167007,10167020,10167052,10162107,10182122,10182123,10182283,10182284,10182288,10182289,10177383,10177384,10177414,10182423,10177436,10162578,10162579,10162580,10162581,10162582,10162596,10182712,10172720,10631290,10631291,10182881,10182882,10182890,10183027,10631558,10631817,10163369,10163370,10163371,10163378,10163379,10163380,10163393,10163394,10163395,10163396,10163397,10163449,10574229,10574230,10574231,10574232,10577274,10571593,10568820,10568821,10568827,10568916,10575050,10587050,10575051,10587051,10575052,10587052,10575053,10587053,10587054,10572127,10572128,10572129,10572142,10572143,10572144,10569243,10569244,10569245,10569246,10569247,10569248,10569249,10569250,10569251,10569252,10578272,10575323,10575324,10575325,10575326,10575327,10572343,10572388,10572389,10572390,10575511,10575512,10578705,10578708,10578709,10578710,10578711,10572834,10578854,10578855,10578950,10585255,10585256,10579414,10567663,10567676,10567677,10579792,10577050,10523036,10523037,10523038,10523039,10523040,10523041,10424464,10420502,10420503,10421933,10425025,10421198,10479141,10473862,10473863,10473864,10477987,10477988,10478092,10478093,10478094,10472609,10472610,10472622,10472623,10472624,10472625,10472626) 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'