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(7074036,7074037,7074038,7074040,7074041,7074042,7074043,7074044,10704012,10704013,10704014,10704015,10704016,10704017,10704018,10704019,10704020,10704021,10704022,10704023,10704024,10704025,10704026,10704027,10704028,10704029,10704030,10704031,10704032,10704033,10704034,10704035,10704036,10704037,10704038,10704039,10704040,10704041,10704042,10704043,10704044,10704045,10704046,10704047,10704048,10704049,10704050,10704051,10704052,10704053,10704054,10704055,10704056,10704057,10704058,10704059,10704060,10704061,10704062,10704063,10704064,10704065,10704066,10704067,10704068,10704069,10704070,10704071,10704072,10704073,10704074,10704075,10704076,10704077,10704078,10704079,10704080,10704081,10704082,10704083,10704084,10704085,10704086,10704087,10704088,10704089,10704090,10704091,10704092,10704093,10704094,10704095,10704096,10704097,10704098,10704099,10704100,10704101,10704102,10704103,10704104,10704105,10704106,10704107,10704108,10704109,10704110,10704111,10704112,10704113,10704114,10704115,10704116,10704117,10704118,10704119,10704120,10704121,10704122,10704123,10704124,10704125,10704126,10704127,10704128,10704129,10704130,10704131,10704132,10704133,10704134,10704135,10704136,10704137,10704138,10704139,10704140,10704141,10704142,10704143,10704144,10704145,10704146,10704147,10704148,10704149,10704150,10704151,10704152,10704153,10704154,10704155,10704156,10704157,10704158,10704159,10704160,10704161,10704162,10704163,10704164,10704165,10704166,10704167,10704168,10704169,10704170,10704171,10704172,10704173,10704174,10704175,10704176,10704177,10704178,10704179,10704180,10704181,10704182,10704183,10704184,10704185,10704186,10704187,10704188,10704189,10704190,10704191,10704192,10704193,10704194,10704195,10704196,10704197,10704198,10704199,10704200,10704201,10704202,10704203,10704204,10704205,10704206,10704207,10704208,10704209,10704210,10704211,10704212,10704213,10704214,10704215,10704216,10704217,10704218,10704219,10704220,10704221,10704222,10704223,10704224,10704225,10704226,10704227,10704228,10704229,10704230,10704231,10704232,10704233,10704234,10704235,10704236,10704237,10704238,10704239,10704240,10704241,10704242,10704243,10704244,10704245,10704246,10704247,10704248,10704249,10704250,10704251,10704252,10704253,10704254,10704255,10704256,10704257,10704258,10704259,10704260,10704261,10704262,10704263,10704264,10704265,10704266,10704267,10704268,10704269,10704270,10704271,10704272,10704273,10704274,10704275,10704276,10704277,10704278,10704279,10704280,10704281,10704282,10704283,10704284,10704285,10704286,10704287,10704288,10704289,10704290,10704291,10704292,10704293,10704294,10704295,10704296,10704297,10704298,10704299,10704300,10704301,10704302,10704303,10704304,10704305,10704306,10704307,10704308,10704309,10704310,10704311,10704312,10704313,10704314,10704315,10704316,10704317,10704318,10704319,10704320,10704321,10704322,10704323,10704324,10704325,10704326,10704327,10704328,10704329,10704330,10704331,10704332,10704333,10704334,10704335,10704336,10704337,10704338,10704339,10704340,10704341,10704342,10704343,10704344,10704345,10704346,10704347,10704348,10704349,10704350,10704351,10704352,10704353,10704354,10704355,10704356,10704357,10704358,10704359,10704360,10704361,10704362,10704363,10704364,10704365,10704366,10704367,10704368,10704369,10704370,10704371,10704372,10704373,10704374,10704375,10704376,10704377,10704378,10704379,10704380,10704381,10704382,10704383,10704384,10704385,10704386,10704387,10704388,10704389,10704390,10704392,10704393,10704394,10704395,10704396,10704397,10704398,10704399,10704400,10704401,10704402,10704403,10704404,10704405,10704406,10704407,10704408,10704409,10704410,10704411,10704412,10704413,10704414,10704415,10704416,10704417,10704418,10704419,10704420,10704421,10704422,10704423,10704424,10704425,10704426,10704427,10704428,10704429,10704430,10704431,10704432,10704433,10704434,10704435,10704436,10704437,10704438,10704439,10704440,10704441,10704442,10704443,10704444,10704445,10704446,10704447,10704448,10704449,10704450,10704451,10704452,10704453,10704454,10704455,10704456,10704457,10704458,10704459,10704460,10704461,10704462,10704463,10704464,10704465,10704466,10704468,10704472,10704473,10704478,10704480,10704481,10704482,10704483,10704484,10704485,10704487,10704488,10704489,10704490,10704491,10704494,10704495,10704496,10704503,10704504,10704506,10704510,10704512,10704513,10704514,10704518,10704521,10704524,10704525,10704527,10704528,10704531,10704538,10704539,10704548,10704549,10704556,10704557,10704561,10704564,10704565,10704567,10704571,10704573,10704574,10704575,10704576,10704577,10704578,10704579,10704580,10704581,10704582,10704585,10704586,10704587,10704588,10704589,10704590,10704591,10704592,10704593,10704594,10704595,10704596,10704597,10704598,10704599,10704600,10704601,10704602,10704604,10704605,10704612,10704613,10704614,10704616,10704617,10704618,10704619,10704620,10704621,10704625,10704626,10704630,10704632,10704633,10704636,10704637,10704638,10704641,10704648,10704649,10704650,10704651,10704652,10704653,10704654,10704655,10704661,10704662,10704665,10704666,10704667,10704670,10704671,10704672,10704673,10704674,10704675,10704676,10704677,10704678,10704679,10704680,10704681,10704682,10704683,10704684,10704685,10704686,10704687,10704689,10704690,10704691,10704692,10704693,10704694,10704695,10704696,10704697,10704698,10704699,10704700,10704701,10704702,10704703,10704704,10704705,10704706,10704707,10704708,10704709,10704710,10704711,10704712,10704713,10704714,10704715,10704716,10704717,10704718,10704719,10704720,10704721,10704722,10704723,10704724,10704725,10704726,10704727,10704728,10704729,10704730,10704731,10704732,10704733,10704734,10704735,10704736,10704737,10704738,10704739,10704740,10704741,10704742,10704743,10704744,10704745,10704746,10704747,10704748,10704749,10704750,10704751,10704752,10704753,10704754,10704755,10704756,10704757,10704758,10704759,10704760,10704761,10704762,10704763,10704764,10704765,10704766,10704767,10704768,10704769,10704770,10704771,10704772,10704773,10704774,10704775,10704776,10704777,10704778,10704779,10704780,10704781,10704782,10704783,10704784,10704785,10704786,10704787,10704788,10704789,10704790,10704791,10704792,10704793,10704794,10704795,10704796,10704798,10704799,10704800,10704811,10704812,10704813,10704814,10704817,10704824,10704825,10704826,10704828,10704831,10704832,10704833,10704834,10704845,10704850,10704853,10704857,10704862,10704863,10704866,10704867,10704868,10704880,10704881,10704883,10704884,10704885,10704886,10704887,10704888,10704889,10704890,10704892,10704893,10704896,10704897,10704898,10704901,10704903,10704906,10704909,10704912,10704918,10704925,10704926,10704930,10704932,10704935,10704936,10704938,10704939,10704940,10704941,10704942,10704943,10704944,10704945,10704946,10704950,10704952,10704953,10704954,10704955,10704956,10704957,10704964,10704967,10704971,10704978,10704980,10704981,10704982,10704986,10704989,10704995,10704996,10704997,10704998,10705002,10705003,10705010,10705013,10705014,10705015,10705016,10705017,10705018,10705019,10705020,10705021,10705022,10705023,10705024,10705025,10705026,10705027,10705028,10705029,10705030,10705031,10705032,10705033,10705034,10705035,10705036,10705037,10705038,10705039,10705040,10705041,10705042,10705043,10705044,10705045,10705046,10705047,10705048,10705049,10705050,10705051,10705052,10705053,10705054,10705055,10705056,10705057,10705058,10705059,10705060,10705061,10705062,10705063,10705064,10705065,10705066,10705067,10705068,10705069,10705070,10705071,10705072,10705073,10705074,10705075,10705076,10705077,10705078,10705079,10705080,10705081,10705082,10705083,10705084,10705085,10705086,10705087,10705088,10705089,10705090,10705091,10705092,10705093,10705094,10705095,10705096,10705097,10705098,10705099,10705100,10705101,10705102,10705103,10705104,10705105,10705106,10705107,10705108,10705109,10705110,10705111,10705112,10705113,10705114,10705115,10705116,10705118,10705122,10705123,10705124,10705125,10705128,10705129,10705130,10705131,10705144,10705145,10705146,7058685,4974396,4974397,8864749,10629547,10629548,10629549,10629550,10629551,10629552,10629553,10629554,10629555,10629556,10629557,10574839,10574840,10574841,10574842,10574843,10574844,10574845,10574846,10574847,10574848,10574849,10574850,10574851,10574852,10574853,10574854,10574855,10574856,10574857,10574858,10574859,10574860,10574861,10574862,10574863,10574864,10574865,10574866,10574867,10574868,10574869,10574870,10574871,10574872,10574873,10574874,10574875,10574876,10574877,10574878,10574879,10574880,10574881,10574882,10574883,10574884,10574885,10574886,10574887,10574888,10574889,10574890,10574891,10574892,10574893,10574894,10574895,10574896,10574897,10574898,10574899,10574900,10574901,10574902,10574903,10574904,10574905,10574906,10574907,10574908,10574909,10574910,10574911,10574912,10574913,10574914,10574915,10574916,10574917,10574918,10574919,10574920,10574921,10574922,10574923,10574924,10574925,10574926,10574927,10574928,10574929,10574930,10574931) 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'