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(8630514,8630515,8630516,8630517,8630518,8630519,8630520,8630521,8630522,8630523,8630524,8630525,8630526,8630527,8630627,8630628,8630629,8630630,8630631,8630633,8630635,8630636,8630642,8630786,8630789,8630810,8630811,8630818,8630820,8630821,8630823,8630825,8630827,8630829,8630831,8630843,8630845,8630847,8630849,8630854,8630855,8630856,8630866,8630870,8630872,8630873,8630890,8630993,8631003,8631119,8631120,8631121,8631188,3229008,3229106,3229107,3229108,3229110,3229182,8631611,8631622,8631623,8631624,8631625,8631635,8631681,8631697,8631698,8631702,8631704,8631822,8631824,8631826,8631856,8631857,8631859,3230230,8629690,8629691,8629692,8629693,8629929,8629930,8630134,8630135,8630136,8630137,8630138,8630139,8630140,8630141,8630142,8630143,8630144,8630145,8630146,8630147,8630148,8630149,8630150,8630151,8630152,8630153,8630154,8630155,8630156,8630157,8630158,8630159,8630160,8630161,8630162,8630163,8630164,8630165,8630166,8630167,8630168,8630169,8630170,8630171,8630172,8630173,10447545,8630420,7067801,7201080,8627530,8627531,8627532,8627533,8627534,8627535,8627536,8627537,8627538,8627539,8627540,8627541,8627542,8627543,8627544,8627545,8627546,8627547,8627548,8627549,8627550,8627551,8627552,8627553,8627554,8627555,8627556,8627557,8627558,8627559,8627560,8627561,8627562,8627563,8627564,8627565,8627566,8627567,8627568,8627569,8627570,8627571,8627572,8627573,10103110,7201253,7201309,7201354,7201368,8627822,8627879,8627880,7201624,8595055,8595056,8595092,8595093,8595101,8628118,8628119,8628148,8628229,8628230,7201844,8628265,10960336,7201902,7201976,10960474,8628626,8628627,8628641,8628654,8628662,8628665,8628666,8628667,8628668,8628669,8628678,8628680,8628699,7202312,8628713,7202313,7202314,7202315,7202316,7202317,7202318,8628718,7202319,8628719,8628720,7202320,7202321,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,7202345,7202346,7202347,7202364,7202365,8628787,5654537,5654555,5654577,5654578,5654579,5654580,5654581,5654588,5654651,8629340,8629341,3227207,7200123,7200124,7200125,7200126,8626613,8626926,10958987,10958988,10958989,7200607,7200608,8910445,8910446,8910447,8910448,8627085,7200753,8910599,8627221,8627223,8627224,8627225,8627227,8627228,8627230,8627231,8627232,8627233,8627234,8627235,8627236,8627237,8627238,8627239,8627240,8627241,8627242,8627243,8627244,8627246,8627247,8627248,8627249,8627250,8627251,8627252,8627288,8627293,7200904,8627310,7201013,8624470,7198108,10100083,8624611,7198391,7198408,7198409,7198410,7198411,7198412,7198413,7198414,7198415,7198416,7198417,7198418,7198419,7198457,7198458,7198459,7198460,7198461,7198462,7198463,7198464,7198465,7198694,7198725,8625157,8625158,8625267,8625268,8625364,8625368,8625371,7199061,7199063,7199449,7199480,7199569,7199571,10101492,10101493,8626050,8626134,8626135,8626136,8860395,8626137,8626138,8626148,8626149,8626151,8626152,8626154,8626157,8626158,8626159,8626161,8626164,8626165,8626166,8626167,8626170,8626171,8626172,8626174,8626175,8626365,7200030,8612652,10618178,10618179,10618180,10618181,3923467,3923489,3923490,10838801,10838806,3234729,7197582,7197923,7197940,7197941,8624345,8624346,8624348,8624350,8624351,8624354,8624356,8624358,8624450,8624454,8624455,8634652,8634653,8634654,8634655,8634656,8634657,10617171,8634738,8634739,8634740,8634741,8634742,8634743,8634744,8905156,8634745,8634746,8634747,10622258,10622264,10622265,10622266,10622267,10622268,10622360,10622405,10622408,10617425,10622431,10622447,10617448,10622514,10622516,10622523,8542165,8905822,8632496,8632498,8632518,10620195,10620196,10620197,10620198,10620199,10620201,10620202,8632830,8632831,8632832,8632833,8632834,8632835,8632836,8632837,10615339,10615340,10615341,10615342,10615389,8633127,8633171,8633184,8633265,3231052,8633282,10615889,10615890,10426253,10426254,10426339,8540599,8633975,8633976,8633978,8633979,8633984,10616644,8634177,8634182,8634183,10427106,10427112,10610994,10714020,10714023,9189545,10614243,10614246,10614257,10614260,10614261,10614262,10614263,10614264,10614267,10614268,10614269,10614270,6669828,10614376,10611428,10614475,10611476,10614476,10611477,10614518,10614548,10611550,10614552,10614553,10614554,10614565,10611778,10611789,10611804,10611808,10611812,10611821,10611830,10611831,10611832,10611833,10611834,10611835,10611856,10611891,10611892,10611906,10611907,10611908,10611909,10611910,10611911,10611912,10611913,10611914,10611915,10611916,10611917,10611918,10611919,10611920,10611921,10611922,10611923,10611924,10611925,10611926,10611927,10611928,10611929,10611930,10611931,10611932,10611933,10611934,10611935,10611936,10611937,10611938,10611939,10611940,10611941,10611944,10611945,10611946,10611947,10611948,10611949,10611950,10611951,10611952,10611953,10611954,10611957,8549450,10611969,10611970,10611976,10611983,10611995,10611996,10611997,10612000,10612001,10612002,10612003,10612004,10612060,10612086,10612191,10612192,10612193,10612194,10612195,10612196,10612197,10612198,10612201,10609287,8851584,8851657,8851658,8851659,8851660,7058247,7058248,7058249,7058250,8862672,8851990,10612909,10612916,10612935,10612936,10612937,10612938,10612939,10613024,10613025,10610026,10613026,10613097,10613098,10613099,10613102,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,8852376,10613235,10610292,10613337,10613434,10613435,10613760,10610917,10610918,10610919,10610958,10117664,10117679,6673692,6673718,6673719,9169520,6673738,7055724,9169864,10118171,6674248,6674249,6674332,10118342,10118451,10118452,8850547,9168359,9160361,9168366,9168367,10419306,10419307,10419349,10419350,10416362,10416363,10419370,10415373,10415374,10417398,10417399,10417400,10417401,10417402,10417406,10417407,10417408,6672697,6672698,10417424,10417443,10417444,10417445,10419494,10417535,10415585,10415604,10415605,10415606,10415607,7054861,6672903,9168721,6673017,6673019,6673020,6673021,6673022,9168817,6673023,6673024,6673025,6673035,6673036,6673051,10419802,10419803,10419804,10419805,10418806,10419806,10419807,10418807,10419808,10418808,10419809,10418809,10418810,10417811,10418811,10417812,10418812,10418813,10417814,10418814,10418815,10417816,10418816,10418817,10417818,10418818,10418819,10417820,10418820,10418821,10417822,10418822,10418823,10417824,10418824,10418825,10417826,10418826,10418827,10417828,10418828,10418829,10417830,10418830,10418831,10417832,10418832,10418833,10417834,10418834,10418835,10418836,10417837,10418837,10418838,10417839,10418839,10418840,10417841,10418841,10418842,10417843,10418843,10418844,10417845,10418845,10418846,10417847,10418847,10418848,10417849,10418849,10417850,10418850,10418851,10417852,9168930,10418852,9168931,10418853,10417854,9168932,10418854,10418855,10417856,10418856,10418857,10417858,10418858,10418859,6673143,10417860,10418860,6673144,10418861,6673145,10417862,10418862,6673146,10418863,6673147,10417864,6673148,6673149,10417866,6673151,10417868,10417870,10417872,10417874,6673159,10417876,10417878,10417881,10417883,10417885,10417887,10417889,10417891,10417893,10417895,10417897,10417899,10417901,10417903,10417905,10417907,10417909,10417911,10417913,10417915,9168995,10417917,10417919,10417921,10417922,10417925,10417927,10417930,10417932,10417934,10417938,10469289,8549957,8550018,8550075,10469502,8550087,8550184,10469949,10469950,10468239,10468410,10468411,10468412,10468413,10468414,10468415,10468416,10468417,10468418,10468419,10468420,9167953,10470721,10470722,10888565,10888566,10893804,10628321,10889451,10884600,10884629,10884631,10884652,10884653,10884697,10884698,10889707,10884738,10889997,10880306,10880307,10885465,10885468,10885469,10631994,10632010,10632011,10632012,10632013,10632014,10632018,10887545,7000826,10887724,10632300,10632301,10632302,10627321,10882916,10888067,10883140,10883142,10883143,10883325,10883326,10888381,10888382,10883392,10883398,10883406,10900846,10161926,10881491,10887096,10887097,10887098,10887120,10887121,10887122,10887123,10887124,10887126,10887127,10887132,10887250,10882353,10882354,10601964,10601969,10601985,10601997,10602005,10602036,10602058,10602243,10647475,10585350,10582561,10579878,10579879,10601756,10601759,10601760,10601787,10601799,10601805,10601910,10601930,10601947,10521871,10521872,10521873,10544310,10522594,10522595,10508584,10508590,10508591,10508592,10507632,10507670,10507671,10507804,10423923,10423924,10423925,10507861,10507862,10507863,10507876,10507887,10507888,10507889,10407778,10407779,10407780,10407781,10408157,10412174,10410323,10410324,10410325,10410326,10410327,10410328) 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'