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(7067892,10943426,7067937,7067938,7076041,7076129,7076286,7076287,7076353,4970732,8569563,7065830,4968319,4968320,4968330,4968331,4968410,4968411,4968412,4968413,7066266,7066276,7074350,7074351,7066379,7066825,7067271,7067299,7067300,7067301,7075460,7071829,7072148,7072149,7072150,10932957,10932959,7073534,10942598,10942799,10942804,10942812,10942817,10942992,10943018,10943019,10943141,10943248,7071808,10944385,10944449,10940769,7069408,8859500,10941389,10941690,10941691,10941692,10941693,10941694,10941695,10941696,10941697,10941698,10941699,10941700,10941701,10941702,10941703,10941704,10941705,10941713,10941724,10941725,10941727,10941734,10941738,10941751,10941752,10941753,10941769,10941783,10941809,10941838,10942141,8860396,10942210,10942325,10942332,10942335,10942343,10942344,10942346,10942347,10942348,10942350,10942356,10942358,10942366,8860554,8860555,10942385,8860613,10942435,10942455,7070749,7070757,7070760,10623056,10623064,10618282,10618283,10618284,10618286,10618288,10618442,10623495,10619193,10619328,10619335,10619352,10619353,10619376,10619377,10619378,10619379,10619380,10619381,10619382,10619383,10619457,10619864,10619866,10619895,10619898,10619899,10621982,10927504,10927505,10927506,10617107,10617157,10617159,10622258,10622264,10622265,10622266,10622267,10622268,10622269,10617322,10927863,10927864,10927872,10922899,10922900,10617403,10617404,10617405,10617409,10617417,10617422,10617423,10617428,10617429,10617430,10922949,10617434,10617435,10622460,10615024,10620084,10620090,10620091,10620183,10620186,10620195,10620196,10620197,10620201,10615229,10620297,10620298,10620301,10620302,10620303,10620309,10620310,10620311,10620312,10620313,10620330,10620331,10620335,10620336,10620337,10615352,10615356,10615363,10620427,10615437,10620764,10615822,10615896,10615950,10615953,10616044,10616045,10616103,10616105,10616210,10616211,10616219,10616220,10616228,10616229,10616243,10616245,10616248,10616252,10616253,10616254,10616258,10616267,10616268,10616287,10616295,10616298,10616302,10616303,10616311,10616323,10616324,10616332,10616333,10616341,10616342,10616348,10616350,10616351,10616353,10616370,10616375,10616387,10616389,10616393,10616394,10616395,10616397,10616400,10616401,10616407,10616410,10616411,10616412,10616416,10616417,10616423,10616426,10616430,10616431,10616440,10616441,10616443,10616453,10616454,10616459,10616544,10922133,10922134,10922205,10922206,10922207,10922208,10922209,10922217,10922304,10922305,10562118,10562119,10562120,10562121,10562122,10562123,10562134,10562135,10562136,10562137,10562138,10562139,10562140,10562141,10562142,10562143,10562144,10562145,10562146,10562147,10562148,10565150,10565158,10565211,10565285,10565286,10565287,10565288,10565289,10559332,10565350,10565351,10565352,10565353,10565354,10565355,10565356,10565357,10565358,10565359,10565360,10565361,10565362,10565363,10565364,10565365,10565366,10565367,10565368,10565369,10565370,10565371,10565372,10565373,10565374,10565375,10565376,10565377,10565378,10565379,10565380,10565381,10565382,10565383,10565384,10565385,10565386,10565387,10565388,10565389,10565390,10565391,10565392,10565393,10565394,10565395,10565396,10565397,10565398,10565399,10565400,10565401,10565402,10565403,10565404,10565405,10565406,10565407,10565408,10565409,10565410,10565411,10565412,10565413,10565414,10565415,10565416,10565417,10565418,10565419,10565420,10565421,10565422,10565423,10565424,10565425,10565426,10565427,10565428,10565429,10565430,10565431,10565432,10565433,10565434,10565435,10565436,10565437,10565438,10565439,10565440,10565441,10565442,10565443,10565444,10565445,10565446,10565447,10565448,10565449,10565450,10565451,10565452,10565453,10565454,10565455,10565456,10565457,10565458,10565459,10565460,10565461,10565462,10565463,10565464,10565465,10565466,10565467,10565468,10565469,10565470,10565471,10565472,10565473,10565474,10565475,10565476,10565477,10565478,10565479,10565480,10565481,10565482,10565483,10565484,10565485,10565486,10565487,10565488,10565489,10565490,10565491,10565492,10565493,10565494,10565495,10565496,10565497,10565498,10565499,10565500,10565501,10565502,10565503,10565504,10565505,10565506,10565507,10565508,10565509,10565510,10565511,10565512,10565513,10565514,10565515,10565516,10565517,10565518,10565519,10565520,10565521,10565522,10565523,10565524,10565525,10565526,10565527,10565528,10565529,10565530,10565531,10565532,10565533,10565534,10565535,10565536,10565537,10565538,10565539,10565540,10565541,10565542,10565543,10565544,10565545,10565546,10565547,10565549,10565550,10565551,10565552,10565553,10565554,10565555,10565556,10565557,10565558,10565559,10565560,10565561,10565562,10565563,10565564,10565565,10565566,10565567,10565568,10565569,10565570,10565571,10565572,10565573,10565574,10565575,10565576,10565577,10565578,10565579,10565580,10565581,10565582,10565583,10565584,10565585,10565586,10565587,10565588,10565589,10565590,10565591,10565592,10565593,10565594,10565595,10565596,10565597,10565598,10565599,10565600,10565601,10565602,10565603,10565604,10565605,10565606,10565608,10565609,10565610,10565611,10565612,10565613,10565614,10565615,10565616,10565617,10565618,10565619,10565620,10565621,10559622,10565622,10565623,10565624,10565625,10565626,10565627,10565628,10565629,10565630,10565631,10565632,10565633,10565634,10565635,10565636,10565637,10565638,10565639,10565640,10565641,10565642,10565643,10565644,10565645,10565646,10565647,10565649,10565650,10565651,10565652,10565653,10614530,10614547,10562851,10614857,10566061,10566062,10612022,10612059,10612062,10612063,10612064,10612104,10612105,10612106,10612107,10612131,10612380,10557971,10557972,10557973,10557975,10557976,10612916,10612960,10612961,10613057,10613089,10613093,10613097,10613098,10613099,10613102,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,10613127,10613350,10613435,10613811,10613859,10515280,10515281,10515282,10515343,10513553,10513554,10513555,10513556,10513557,10513558,10517670,10513975,10514029,10514030,10516142,10516157,10516597,10516598,10516599,10516600,10516601,10516602,10516603,10516604,10516605,10516682,10516703,10516776,10514833,10514834,10512852,10516910,10516911,10516912,10516913,10516914,10516915,10516916,10516930,10516934,10516935,10514986,10514987,10514988,10514989,10417221,10417222,10417223,10417224,10417225,10416255,10416256,10417312,10417313,10417314,10417315,10416346,10416356,10416357,10416362,10416364,10416365,10416366,10416367,10416368,10416383,10416384,10416385,10416387,10419499,10419568,10419668,10419669,10419670,10419671,10419672,10419673,10419674,10419675,10418676,10419676,10419677,10419678,10419679,10419680,10419681,10419682,10419683,10419684,10419685,10419688,10418689,10419694,10419707,10418708,10419726,10419739,10418795,10418796,10418806,10418807,10418808,10418809,10418810,10418811,10417811,10418812,10419813,10419814,10417814,10419815,10419816,10417816,10419817,10419818,10418824,10417832,10417834,10419839,10419844,10419845,10419848,10417850,10417852,10417868,10417870,10417885,10417887,10419891,10419895,10419896,10419899,10417903,10419904,10419905,10417905,10419907,10417921,10417925,10417930,10417934,10417938,10419994,10419995,10419996,10419997,10419998,10420014,10420015,10420016,10420017,10420036,10420037,10420038,10420046,10420052,10420053,10420055,10420056,10420084,10420088,10420095,10418147,10418149,10420150,10418150,10420151,10420152,10420153,10420154,10420155,10420156,10420157,10420158,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10420167,10420168,10420169,10420170,10420171,10420173,10420174,10420203,10417212,10417213,10417214,10417215,10417216,10417217,10417218,10417219,10417220,10467108,10467109,10467125,10467126,10467127,10467132,10467134,10467135,10467146,10467147,10467433,10467434,10467437,10467438,10467440,10465682,10465683,10465684,10465685,10465689,10465691,10465692,10465694,10465696,10465759,10465760,10465766,10465769,10465770,10465771,10465772,10465773,10465774,10465775,10465792,10465793,10465796,10465797,10465798,10465799,10465800,10465801,10465802,10465822,10465824,10465829,10465830,10465831,10465845,10465846,10465854,10465857,10465858,10465859,10465860,10465861,10465862,10465863,10465864,10465865,10465866,10463876,10465877,10463877,10463878,10463879,10463880,10463881,10463882,10463895,10465897,10465898,10465906,10465909,10465910,10465912,10465913,10463921,10463922,10464040,10464043,10464044,10464079,10464080,10466206,10466207,10466208,10466209,10466210,10466220,10466229,10466303,10466304,10466308,10466310,10466311,10466312,10466313,10466314,10466315,10466316,10466317,10466318,10466336,10466343,10466344,10466345,10466346,10466347,10466348,10466349,10466350,10466351,10466352,10466357,10466360,10466369,10466371,10466372,10466374,10466376,10466392,10466402,10466403,10466404,10466405,10466406,10466407,10466408,10466409,10466410,10466411,10466412,10466424,10466456,10464800,10466848,10466850,10466851,10466860) 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'