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(8068841,8068850,8068880,8068895,10943672,4970639,4970640,4970641,4970642,4970643,4970644,4970685,4970775,4970892,4970927,4970934,4971046,4971047,4971048,10944263,4971145,4971146,4971147,4968234,4968328,4968337,4968338,4968360,4968363,4968364,4968365,4968412,4968443,10437194,10437200,10437289,10437290,10437332,10437333,10437334,10437335,10437336,10437402,10437409,10437433,4968849,4968862,10437588,10437594,10437595,10437596,10437600,4969177,4969303,4969304,4969305,4969306,4969307,4969308,4969309,4969310,4969311,8067960,4969317,4969324,4969325,4969330,4969331,4969332,4969333,4969334,4969335,4969336,4969337,8067997,8067999,8068000,8068001,8068002,8068003,8068004,8068005,8068006,8068007,8068008,8068009,8068010,8068011,8068012,8068050,8068051,8068052,8068053,8068054,8068055,8068056,8068116,8068117,8068118,8068119,8068120,8068121,8068122,8068140,8068141,8068219,8068222,8068223,8068224,8068225,8068226,8068227,8068228,8068229,8068230,8068231,8068232,8068233,8068234,8068235,8068236,8068237,8068238,8068239,8068240,8068241,8068255,8068288,8068289,8068290,8068293,8068294,8068295,8068296,8068304,8068305,8068308,8068309,8068343,8068344,8068345,8068346,8068369,8068370,8068371,8068372,8068374,8068375,8068376,8068377,8068378,8068379,8068380,8068381,8068382,8068383,8068384,8068385,8068412,8068413,8068414,8068415,8068434,8068440,8068441,8068442,8068443,8068455,8068456,8068462,8068463,8068470,8068481,8068490,8068508,8068571,8068572,8068573,8068574,8068575,8068576,8068577,8068578,8068602,8068609,8068611,8068616,8068617,8068618,8068619,8068620,8068621,8068622,8068623,8068644,8068654,8068655,8068656,8068657,8068666,8068667,8068668,8068669,8068670,8068671,8068672,8068673,8068674,8068675,8068676,8068677,8068678,8068679,8068685,8068688,8068690,8068696,8068709,8068710,8068725,8068726,8068743,8068744,8068745,8068751,8068759,8068760,8074803,10931527,10931538,10931539,10931540,10931654,10931854,10931857,8075272,10931858,10931919,10931937,10931944,10931957,10931958,10931959,10931960,10931961,10932035,10932036,10932095,10932165,10932214,10932255,10932318,10932343,10932608,10932615,10932639,10932680,10932689,10932747,10932870,10932879,10932899,10932949,10932950,10933053,10933054,10933055,10933056,10933057,10933071,10933075,10933100,10933104,10933105,10933107,10933126,10933127,10942632,10942751,10942752,10942895,10942924,10942925,10943003,10943057,10943075,10943082,10943099,10943100,10943101,10943135,10943145,10943175,10943179,10943181,10943219,10943249,10943254,10943255,10943256,8970217,10940534,10940535,10940556,10940557,10940568,10940569,10940743,10940857,8072314,8072427,8072428,8072441,8072467,8072468,8072469,10941342,10941343,10941344,8072773,8072774,8072775,8072776,8072777,10941712,10941750,8072917,8072918,8072919,8072920,8072921,8072922,8072923,8072924,8072925,8072926,8072927,8072928,8072929,8072930,8072931,8072932,8072933,8072934,10941809,10941949,10941951,10942114,10942115,10942117,10942150,10942234,10942238,10942242,10942262,10942276,10942277,8073503,10942433,10942447,10942448,10923517,10923518,10623043,10623063,10923573,10923574,10923606,10923698,10923699,10923803,10923804,10923805,10923806,10923807,10923808,10923809,10923810,10623308,10923855,10923856,10923857,10923858,10923859,10923860,10923861,10623366,10923927,10923928,10923929,10923930,10923931,10623457,10623491,10623492,10623493,10623503,10924017,10924018,10924019,10924020,10924021,10924097,10924098,10924099,10924100,10924101,10924102,10924103,10924104,10924108,10623653,10623654,10924208,10924209,10924210,10924211,10924212,10924213,10924261,10924262,10924270,10924289,10924547,10924548,10924549,10924550,10924551,10924552,10924553,10924554,10924555,10924556,10924557,10924558,10924559,10924560,10924561,10924562,10924563,10924564,10924565,10924566,10924567,10924568,10924569,10924570,10924571,10924572,10924573,10924574,10924744,10924745,10924746,10924747,10924748,10924749,10924837,10924838,10924839,10924840,10924944,10924945,10924946,10924947,10924948,10924949,10924950,10924951,10924952,10924953,10924954,10924955,10924956,10924957,10924958,10924959,10925068,10925069,10925070,10925071,10925072,10925073,10925074,10925075,10925076,10925077,10925078,10925079,10925110,10925122,10925166,10925167,10624731,10624732,10925339,10925340,10925341,10925342,10925343,10925344,10925345,10925346,10925347,10925348,10925349,10925350,10925351,10925352,10925424,10925425,10922477,10922481,10922482,10922483,10922484,10922485,10922486,10922487,10621978,10922488,10922489,10922490,10922491,10922492,10922493,10922494,10621992,10922544,10922566,10922596,10922598,10922601,10922603,10622093,10922610,10922611,10922612,10922613,10622122,10922807,10922808,10922837,10922838,10922839,10922840,10922841,10922897,10622438,10923015,10622506,10622507,10622508,10622509,10622510,10622511,10622512,10622513,10622517,10923075,10923097,10923166,10923167,10923219,10923220,10923221,10923262,10923263,10923264,10923265,10923317,10923318,10923319,10923320,10923321,10923353,10923354,10923355,10923356,10923375,10923376,10923377,10622880,10923391,10622889,10622911,10619980,10620048,10620055,10620096,10920607,10920608,10920609,10620180,10620181,10620182,10620183,10920720,10620219,10620220,10920739,10920832,10920833,10920834,10620344,10620345,10620365,10920901,10920935,10921020,10921021,10921022,10921158,10921159,10921160,10921161,10620669,10921223,10921224,10921225,10921226,10921227,10921228,10921229,10921230,10921303,10921304,10921305,10921306,10921307,10921308,10921309,10921367,10921368,10921369,10921370,10921492,10921517,10921608,10621125,10621133,10621135,10621155,10621156,10621157,10621158,10621159,10621164,10621251,10621252,10621253,10621254,10621255,10621256,10621257,10621258,10621259,10621260,10621261,10621300,10921833,10921834,10921835,10921836,10921837,10921838,10921839,10921840,10921841,10621342,10621349,10621350,10621352,10621353,10621354,10621355,10621356,10621371,10621372,10621380,10621411,10921923,10621427,10621438,10921956,10921957,10921958,10921959,10921960,10921962,10921963,10621454,10621464,10621465,10621466,10621467,10621468,10621469,10621470,10621471,10621472,10621473,10621474,10621475,10621498,10621505,10621506,10621509,10621515,10621564,10621570,10621578,10621579,10621586,10621626,10621627,10621628,10922144,10621642,10621644,10621666,10621683,10621684,10621685,10621686,10621687,10922205,10922206,10621696,10621698,10621699,10621700,10621713,10621720,10621726,10621735,10621736,10621737,10621738,10621739,10621740,10621741,10922368,10922371,10922372,10922373,10922374,10922378,10922379,10922393,10922421,10922422,10922423,10922424,10922425,10922426,10922427,10922428,10922432,10922459,10922464,10922465,10922466,10922468,10922469,10922470,10565223,10565259,10565315,10565323,10614229,10614238,10614248,10614253,10614254,10614338,10614446,10614452,10614455,10614456,10614457,10614468,10614471,10614548,10614570,10614571,10614592,10614595,10614662,10614663,10614664,10614665,10614666,10614667,10614668,10614669,10614670,10614671,10614672,10614673,10614674,10614675,10614676,10614677,10614678,10614679,10614680,10614681,10614682,10614683,10614684,10614685,10614686,10614687,10614688,10614689,10614690,10614691,10614692,10614693,10614694,10614695,10614696,10614697,10614698,10614699,10614700,10614701,10614702,10614703,10614704,10614705,10614706,10614707,10614708,10614709,10614710,10614711,10614712,10614713,10614714,10614715,10614716,10614717,10614789,10614813,10566066,10611991,10611992,10611993,10612046,10612047,10612048,10612049,10612082,10612083,10612132,10612191,10612258,10612320,10612321,10563602,10612518,10612536,10612539,10612546,10612555,10612570,10612571,10612619,10612623,10612715,10612763,10612910,10612911,10612970,10612971,10612972,10613006,10613011,10613012,10613016,10613036,10613042,10613219,10613366,10613369,10564639,10564659,10613611,10564770,10564771,10564772,10564773,10564830,10613701,10613702,10613810,10511115,10511116,10511117,10511118,10511119,10511120,10511121,10511122,10511123,10511124,10511125,10511126,10511127,10511128,10511129,10511130,10511131,10511136,10511137,10511138,10511139,10511141,10511142,10511143,10511149,10511150,10511151,10517273,10517274,10517275,10517276,10517287,10517288,10517541,10517542,10517543,10517569,10517570,10517571,10517572,10517593,10517669,10517672,10517676,10518980,10419330,10419331,10419350,10419417,10419575,10419584,10419587,10419588,10419589,10419590,10419741,10419744,10419807,10419841,10419842,10419843,10419917,10419918,10419919,10419920,10419921,10419922,10419923,10420095,10420096,10420097,10420098,10420122,10420123,10420124,10420134,10420186,10420199,10420200,10420201,10420202,10471214,10471491,10471492,10471528,10471566,10469912,10469916,10469919,10469921,10470081,10470095,10470125,10470426,10470427,10470428,10470551,10470552,10470553,10470554,10470611,10470674) 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'