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(10939642,10939643,10939725,10939733,10939734,10939736,10939742,10939757,10939772,10939792,4970403,4970404,10939876,10939882,10939916,10940017,4970721,4970722,4970738,10940147,10940224,10940225,10940283,10940284,10940285,10940286,10940287,10940293,10940297,10940298,10940299,10940300,10940301,4971081,10940524,4971143,4968319,4968320,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,4968410,4968411,4968412,4968413,8067286,4968613,4968614,4968622,4968623,4968624,4968625,4968631,8067524,10938787,10938791,10938792,10938794,10938795,10938797,10938832,10938842,10938854,10938881,10939383,10939439,10939467,8065088,8065089,8075288,8065791,8065853,8065932,8065933,8065934,8065935,8065957,8066177,4967870,4967871,4968076,4968077,4968078,8064474,8064475,8064476,8064656,8064672,8064673,8071672,8071673,8071676,8071678,8071679,8071680,8071681,8071682,8071683,8071684,8071685,8071686,8071687,8071688,8071689,8071690,8071691,8071692,8071693,8071694,8071695,8071696,8071697,8071698,8071699,8071700,8071701,8071702,8071703,8071704,8071705,8071706,8071707,8071723,8071724,8071725,8071726,8071731,8071732,8071733,8071737,8071738,8071741,8071743,8071744,8071745,8071746,8071747,8071748,8071749,8071750,8071751,8071752,8071753,8071754,8071755,8071756,8071757,8071758,8071759,8071760,8071761,8071762,8071763,8071764,8071765,8071766,8071767,8071768,8071769,8071770,8071771,8071772,8071788,8071789,8071790,8071791,8071796,8071797,8071798,8071802,8071803,8071806,8071808,8071809,8071810,8071811,8071812,8071813,8071814,8071815,8071816,8071817,8071818,8071819,8071820,8071821,8071822,8071823,8071824,8071825,8071826,8071827,8071828,8071829,8071830,8071831,8071832,8071833,8071834,8071835,8071836,8071837,8071853,8071854,8071855,8071856,8071861,8071862,8071863,8071867,8071868,8071871,8071873,8071874,8071875,8071876,8071877,8071878,8071879,8071880,8071881,8071882,8071883,8071884,8071885,8071886,8071887,8071888,8071889,8071890,8071891,8071892,8071893,8071894,8071895,8071896,8071897,8071898,8071899,8071900,8071901,8071902,8071918,8071919,8071920,8071921,8071926,8071927,8071928,8071932,8071933,8071936,8071938,8071939,8071940,8071941,8071942,8071943,8071944,8071945,8071946,8071947,8071948,8071949,8071950,8071951,8071952,8071953,8071954,8071955,8071956,8071957,8071958,8071959,8071960,8071961,8071962,8071963,8071964,8071965,8071966,8071967,8071983,8071984,8071985,8071986,8071991,8071992,8071993,8071997,8071998,8072001,8072003,8072004,8072005,8072006,8072007,8072008,8072009,8072010,8072011,8072012,8072013,8072014,8072015,8072016,8072017,8072018,8072019,8072020,8072021,8072022,8072023,8072024,8072025,8072026,8072027,8072028,8072029,8072030,8072031,8072032,8072048,8072049,8072050,8072051,8072056,8072057,8072058,8072062,8072063,8072066,8072068,8072069,8072070,8072071,8072072,8072073,8072074,8072075,8072076,8072077,8072078,8072079,8072080,8072081,8072082,8072083,8072084,8072085,8072086,8072087,8072088,8072089,8072090,8072091,8072092,8072093,8072094,8072095,8072096,8072097,8072113,8072114,8072115,8072116,8072121,8072122,8072123,8072127,8072128,8072131,8072133,8072134,8072135,8072136,8072137,8072138,8072139,8072140,8072141,8072142,8072143,8072144,8072145,8072146,8072147,8072148,8072149,8072150,8072151,8072152,8072153,8072154,8072155,8072156,8072157,8072158,8072159,8072160,8072161,8072162,8072178,8072179,8072180,8072181,8072186,8072187,8072188,8072192,8072193,8072196,8072198,8072199,8072200,8072201,8072202,8072203,8072204,8072205,8072206,8072207,8072208,8072209,8072210,8072211,8072212,8072213,8072214,8072215,8072216,8072217,8072218,8072219,8072220,8072221,8072222,8072223,8072224,8072225,8072226,8072227,8072243,8072244,8072245,8072246,8072251,8072252,8072253,8072257,8072258,8072261,8072263,8072264,8072265,8072266,8072267,8072268,8072269,8072270,8072271,8072272,8072273,8072274,8072275,8072276,8072277,8072278,8072279,8072280,8072281,8072282,8072283,8072284,8072285,8072286,8072287,8072288,8072289,8072290,8072291,8072292,3656698,3656993,8073529,10623056,10623065,10623169,10623310,10623311,10623312,10623313,10623314,10623315,10623316,10623317,10623318,10623319,10623320,10623321,10623322,10623323,10623324,10623325,10623326,10623327,10623328,10623329,10623330,10623331,10623332,10623333,10623334,10623335,10623336,10623337,10623338,10623339,10623340,10623341,10623342,10623343,10623344,10623345,10623346,10623347,10623348,10623349,10623350,10623351,10623352,10623353,10623354,10623355,10623356,10623357,10623358,10623359,10623360,10623361,10623362,10623363,10623364,10623365,10623366,10623367,10623368,10623369,10623370,10623371,10623372,10623373,10623374,10623375,10623376,10623377,10623378,10623379,10623380,10623381,10623382,10623383,10623384,10623385,10623386,10623387,10623388,10623389,10623390,10623391,10623392,10623393,10623394,10623395,10623396,10623397,10623398,10623490,10623491,10623492,10623660,10623661,10623662,10623707,10623708,10623709,10623710,10623721,10623722,10623726,10623733,10623734,10623739,10623768,10623805,10624122,10624123,10624131,10624132,10624133,10624414,10624582,10624628,10621982,10622095,10622154,10622257,10622402,10622405,10622408,10622429,10622430,10622445,10622548,10622549,10622672,10622673,10622674,10622675,10622677,10622678,10622679,10622680,10622681,10622714,10622811,10622812,10622813,10622814,10622815,10622816,10622817,10622818,10622819,10622820,10622828,10620076,10620079,10620080,10620096,10620108,10620118,10620187,10620189,10620190,10620191,10620192,10620193,10620194,10620198,10620199,10620200,10620202,10620208,10620337,10620438,10620439,10620440,10620711,10620712,10620778,10620779,10620780,10620781,10620782,10620893,10620894,10620895,10620920,10620921,10620922,10620923,10621034,10621036,10621037,10621038,10621041,10610987,10565144,10610999,10565155,10611025,10611037,10565200,10565225,10565271,10565272,10565273,10565274,10565275,10565276,10565277,10565282,10565283,10565284,10565299,10565300,10565303,10565328,10565349,10565646,10565647,10565654,10565655,10565656,10565657,10565658,10565659,10565660,10565661,10565662,10565663,10565664,10565665,10565666,10565667,10565668,10565669,10565670,10565671,10565672,10565673,10565674,10565675,10565676,10565677,10565678,10565679,10565680,10565681,10565682,10565683,10565684,10565685,10565686,10565687,10565688,10565689,10565690,10565691,10565692,10565693,10565694,10565695,10565696,10565697,10565698,10565699,10563565,10563566,10517222,10517223,10517224,10517614,10517615,10517616,10517670,10517799,10517801,10517802,10517805,10517806,10517994,10517995,10419256,10419271,10419306,10419307,10419370,10419437,10419438,10419439,10419450,10419454,10419455,10419457,10419470,10419494,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419539,10419540,10419541,10419542,10419543,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419551,10419552,10419553,10419554,10419556,10419557,10419558,10419559,10419560,10419561,10419562,10419563,10419564,10419565,10419566,10419567,10419673,10419674,10419675,10419677,10419678,10419703,10419704,10419705,10419706,10419707,10419708,10419709,10419710,10419712,10419720,10419725,10419727,10419732,10419734,10419735,10419739,10419742,10419793,10419802,10419803,10419804,10419805,10419806,10419808,10419809,10419810,10419819,10419820,10419823,10419824,10419826,10419827,10419829,10419831,10419832,10419833,10419888,10419889,10419890,10419897,10419904,10419966,10419971,10419994,10419997,10419999,10420000,10420001,10420002,10420004,10420006,10420008,10420011,10420037,10420038,10420039,10420040,10420041,10420042,10420043,10420044,10420054,10420055,10420056,10420057,10420058,10420059,10420060,10420086,10420089,10420092,10420102,10420103,10420104,10420105,10420108,10420109,10420110,10420111,10420113,10420117,10420118,10420125,10420126,10420127,10420149,10420150,10420151,10420152,10420153,10420154,10420155,10420156,10420157,10420158,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10420167,10420168,10420169,10420170,10420171,10420172,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420200,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10420216,10420217,10420219,10420220,10471122,10471173,10470724) 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'