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(10939537,10939617,4970732,4970733,4971037,4968319,4968320,4968410,4968411,4968412,4968413,4968613,4968614,4968622,4968623,4968624,4968625,4968631,8075333,8075334,8075335,8075336,8075357,8075419,8075457,4967460,4967985,8073065,8073068,8073070,8073128,8073136,8073171,8073172,8073179,8073180,8073181,8073209,8073210,8073251,8073292,8073293,8073294,8073335,8073456,10623064,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,10623399,10623400,10623401,10623402,10623403,10623404,10623405,10623406,10623407,10623408,10623409,10623410,10623411,10623412,10623413,10623414,10623415,10623416,10623417,10623418,10623419,10623420,10623421,10623422,10623423,10623424,10623425,10623426,10623427,10623428,10623429,10623430,10623431,10623432,10623433,10623434,10623435,10623436,10623437,10623438,10623439,10623440,10623441,10623442,10623443,10623444,10623445,10623446,10623447,10623448,10623449,10623450,10623451,10623452,10623453,10623454,10623455,10623456,10623457,10623458,10623459,10623460,10623461,10623462,10623463,10623464,10623465,10623466,10623467,10623468,10623469,10623470,10623471,10623472,10623473,10623474,10623475,10623476,10623477,10623490,10623495,10623496,10623507,10623723,10623810,10624632,10624633,10622095,10622217,10622224,10622225,10622235,10622258,10622264,10622265,10622266,10622267,10622268,10622447,10622460,10622514,10622533,10620081,10620084,10620085,10620086,10620087,10620088,10620089,10620090,10620091,10620092,10620093,10620094,10620096,10620117,10620118,10620183,10620201,10620202,10620203,10620204,10620205,10620206,10620208,10620289,10620290,10620291,10620292,10620297,10620298,10620301,10620302,10620303,10620528,10621034,10621036,10621037,10621038,10621041,10565150,10565211,10565220,10565234,10565235,10565236,10565237,10565238,10565239,10565240,10565241,10565242,10565247,10565248,10565252,10565285,10565286,10565287,10565288,10565289,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,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,10565654,10565655,10565656,10565657,10565658,10565659,10565660,10565661,10565662,10565663,10565664,10565665,10565666,10565667,10565668,10565669,10565670,10565671,10565672,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,10565700,10565701,10565702,10565703,10565704,10565705,10565706,10566061,10566062,10563574,10563575,10563581,10563582,10564664,10564666,10564669,10564883,10564885,10564886,10564887,10564888,10564889,10564890,10564891,10564892,10564893,10564894,10564895,10564896,10564897,10564973,10564995,10565037,10565038,10565039,10565040,10565041,10517143,10517144,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517222,10517223,10517224,10517614,10517615,10517616,10517617,10517618,10517670,10517820,10517821,10517994,10517995,10518648,10518649,10518650,10518651,10518652,10518653,10518654,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,10518664,10518665,10518666,10518667,10518668,10518669,10518670,10518671,10518672,10518673,10518674,10518675,10518676,10518677,10518678,10518679,10518680,10518681,10518682,10518683,10518684,10518685,10518686,10518687,10518688,10518689,10518690,10518691,10518692,10518693,10518694,10518695,10518696,10518697,10518698,10518699,10518700,10518701,10518702,10518703,10518704,10518705,10518706,10518707,10518708,10419307,10419375,10419376,10419450,10419452,10419454,10419469,10419470,10419493,10419494,10419495,10419496,10419499,10419500,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419524,10419525,10419526,10419527,10419528,10419529,10419530,10419531,10419532,10419533,10419534,10419535,10419536,10419537,10419538,10419539,10419540,10419541,10419542,10419543,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419551,10419552,10419553,10419554,10419555,10419556,10419557,10419558,10419559,10419560,10419561,10419562,10419563,10419564,10419565,10419566,10419567,10419568,10419668,10419669,10419670,10419673,10419674,10419675,10419676,10419679,10419681,10419682,10419683,10419684,10419685,10419686,10419688,10419689,10419690,10419693,10419694,10419695,10419703,10419705,10419707,10419708,10419709,10419714,10419715,10419716,10419718,10419719,10419720,10419721,10419722,10419723,10419724,10419725,10419726,10419727,10419728,10419729,10419730,10419731,10419732,10419733,10419734,10419735,10419736,10419737,10419738,10419739,10419740,10419741,10419742,10419743,10419744,10419745,10419746,10419747,10419748,10419749,10419750,10419751,10419752,10419753,10419754,10419755,10419756,10419793,10419813,10419814,10419815,10419816,10419817,10419818,10419832,10419833,10419834,10419835,10419836,10419888,10419889,10419890,10419891,10419892,10419893,10419894,10419895,10419896,10419897,10419898,10419899,10419900,10419904,10419905,10419906,10419907,10419971,10419983,10419995,10420009,10420014,10420015,10420016,10420036,10420040,10420044,10420053,10420054,10420055,10420056,10420057,10420058,10420059,10420060,10420147,10420149,10420150,10420151,10420152,10420153,10420154,10420155,10420156,10420157,10420158,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10420167,10420168,10420169,10420170,10420202,10471171,10471172,10471173,10471174,10471175,10469949,10469950,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'