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(10939649,7076041,7076122,10939792,7076287,7076288,7076289,7076290,7076291,7076294,7076296,10940017,7068402,8569414,7068497,4970723,4970733,7068523,4970775,8569548,10940301,10933357,7066111,4968337,4968338,4968412,8067255,8067256,8067257,7074301,8067292,7074355,7074369,10437560,7066824,7066825,7066882,7066883,7066884,10437751,8067918,8067943,8067951,7067898,7072074,8065088,8065089,7072148,7072149,7072150,7072151,7072152,10931689,7072467,10931902,8065791,8065842,10932351,10932352,7073283,7065352,10932793,10932801,10932803,10932810,10932820,10932821,10932822,10932823,10932824,10932917,10932973,10932974,10932975,10933000,7065694,7065695,7065750,7065830,7065831,7065832,7065833,7065834,7065835,7065836,7065837,7065838,7065839,4968076,4968077,4968078,7065873,10943141,10943256,8064656,10943304,10943306,10943308,10943309,8064672,8064673,7071810,3655602,3655603,3655604,10944478,10940741,10944645,10944646,10940960,10941120,7069592,10941251,10941265,10941266,10941268,11047587,7069788,3656393,7069911,10941690,10941694,10941696,10941697,10941698,10941699,10941700,10941702,10941713,10941724,10941725,10941726,10941734,10941740,10941741,3656698,10941751,10941752,10941753,10941754,10941755,10941756,10941762,10941767,10941768,10941770,10941772,10941775,10941779,10941783,10941809,10941838,10942027,10942028,11048379,11048387,11048388,11048389,11048578,11048598,11048599,10942325,7070749,7070793,10942448,10928557,10623063,10623113,10623114,10623115,10623116,10928703,10928704,10618253,10618254,10618255,10618256,10618281,10618288,10618289,10618290,10618291,10618292,10618293,10618366,10618367,10618368,10618369,10618370,8070171,8070172,10623491,10623492,10623493,10623715,10623729,10623735,10624121,10624122,10624123,10619149,10619150,10619229,8070947,8070948,8070949,8070950,8070951,8070952,8070953,8070954,8070955,8070956,8070957,8070958,8070959,10619328,10619457,10619458,10619459,10624582,10619840,10619842,10619843,10619844,10619893,10619895,10619896,10619903,10922518,10617035,10927576,10927577,10927578,10617158,10617159,10622360,10927886,10617383,10617384,10622402,10622408,10617417,10622429,10617431,10617450,10617456,10617464,10622508,10622514,10622516,10928352,10622864,10622865,10614969,10615036,10620096,10615108,10615109,10615178,10620183,10615222,10615229,10620427,10620438,10620439,10620440,10926128,10926176,10926204,10615709,10926285,10620794,10620795,10615819,10615895,10615933,10615938,10615939,10615962,10616002,10616003,10616023,10922074,10922075,10922078,10922139,10922140,10922141,10922142,10922215,10922216,10922257,10922264,10922267,10922277,10922285,10922286,10922287,10922290,10922441,10922442,10922446,10922447,10922448,10922449,10610965,10613971,10613972,10613973,10613974,10613975,10613976,10613977,10613978,10613979,10613980,10613981,10613982,10613983,10613984,10613985,10613986,10613987,10613988,10613989,10613990,10613991,10613992,10613993,10613994,10610994,10613995,10613996,10613997,10565155,10565158,10611025,10565205,10565206,10565207,10614064,10614086,10565253,10565254,10565255,10565256,10565259,10611184,10611187,10611188,10611191,10611193,10611194,10614338,10611338,10611340,10611341,10611406,10611431,10611456,10611457,10611461,10614476,10614502,10611519,10614521,10614522,10614523,10614547,10614548,10611568,10611569,10611570,10611590,10559756,10611649,10611655,10611658,10611659,10611660,10611758,10611782,10611831,10611930,10611969,10611970,10611983,10612132,10612194,10612380,10609834,10609839,10609845,10609939,10609940,10609941,10609942,10609946,10612972,10613018,10610024,10610044,10613056,10610056,10613057,10610057,10613058,10610060,10610061,10610063,10610064,10610065,10613066,10613111,10613112,10613133,10613192,10613214,10613215,10613235,10610333,10610337,10613342,10610352,10610353,10613369,10613372,10610418,10613421,10613431,10613432,10613504,10610729,10613729,10613739,10610791,10610850,10610874,10610918,10610919,10610954,10517143,10517144,10513552,10513556,10513557,10513558,10513562,10513563,10513564,10517798,10517994,10517995,10514015,10514017,10514018,10514037,10514038,10514093,10518102,10518103,10518104,10518105,10518106,10518107,10518111,10518570,10512852,10515043,10515044,10515047,10515048,10515049,10515050,10515051,10515052,10515053,10515054,10515059,10515072,10513076,10515097,10416346,10419350,10416353,10416360,10416361,10416365,10416366,10416383,10416400,10416431,10416432,10416433,10416434,10419437,10419438,10419439,10417443,10417445,10419452,10419468,10419493,10419494,10417534,10415600,10415601,10415606,10415607,10416648,10416671,10416672,10415675,10419676,10415679,10419679,10415680,10419683,10419684,10419686,10419687,10419688,10419695,10419713,10419716,10419719,10419722,10419723,10419726,10419727,10419728,10419729,10415731,10415732,10415737,10419740,10419741,10419742,10419744,10419751,10419752,10415791,10415792,10419807,10415828,10419834,10415835,10419835,10419836,10419841,10419842,10419843,10419891,10419892,10419893,10419905,10419906,10420011,10420015,10420018,10420036,10420045,10420095,10420096,10420097,10420098,10418149,10420153,10420167,10420168,10420185,10420186,10420199,10420200,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10466954,10466955,10463004,10463011,10463012,10463031,10463034,10463035,10463044,10463060,10467069,10467070,10467092,10467093,10467094,10467095,10467096,10467097,10467098,10467099,10467100,10467101,10467102,10467103,10467104,10467105,10467106,10467107,10467108,10467109,10467110,10467111,10467112,10467113,10467114,10467115,10467116,10467117,10467118,10467119,10467120,10467121,10467122,10467123,10467124,10467125,10467126,10467127,10467128,10467129,10467130,10467131,10467132,10467133,10467134,10467135,10467136,10467137,10467138,10467139,10467140,10467141,10467142,10467143,10467144,10467145,10467146,10467147,10467148,10467149,10467150,10467151,10467152,10467153,10467154,10467155,10467156,10467157,10467158,10467159,10467160,10467171,10467172,10467173,10467174,10467217,10467218,10467219,10467220,10467221,10463313,10463314,10463398,10463402,10463403,10463429,10463430,10463432,10467432,10467442,10467444,10467449,10467457,10467458,10467459,10467474,10467475,10463554,10463555,10463588,10463594,10463595,10463596,10463649,10463653,10463655,10463665,10463671,10463672,10463673,10463674,10465681,10465682,10465683,10465686,10465687,10463691,10463694,10465697,10465701,10465702,10465707,10465708,10465709,10463729,10463736,10465737,10463737,10465738,10463738,10463757,10463758,10463759,10465759,10465760,10463762,10463763,10463765,10463766,10463767,10465768,10463769,10463780,10465781,10465783,10463786,10465786,10463787,10465787,10465788,10463789,10465789,10465792,10465793,10465794,10465795,10465796,10463797,10465799,10465800,10465801,10465806,10465807,10467821,10465823,10463823,10463824,10463827,10463828,10463829,10463830,10467831,10463831,10463832,10467838,10465843,10465844,10465847,10465848,10465849,10465850,10465851,10465852,10465853,10465854,10465855,10465868,10465875,10465876,10463877,10465880,10465884,10465885,10463885,10465887,10465891,10465894,10465895,10465896,10463897,10465903,10463903,10465904,10463904,10465905,10465906,10465907,10465908,10465911,10463911,10465912,10463912,10465913,10463913,10463914,10465915,10465916,10465917,10463919,10465920,10463920,10465921,10463926,10463928,10463929,10463930,10463948,10463949,10463997,10463998,8563358,8563361,8563363,10464042,10464043,10464044,10464045,10470084,10466206,10466207,10466210,10466211,10466214,10466232,10466233,10466240,10466241,10466242,10462299,10462300,10466303,10466308,10466309,10462314,10462315,10466318,10466319,10466321,10466322,10466323,10466324,10466325,10462325,10466328,10462328,10466329,10462329,10466336,10466337,10466338,10466339,10466340,10466341,10466342,10466345,10466349,10466350,10466370,10466375,10466394,10466395,10466396,10466397,10466398,10466399,10466400,10466401,10462403,10462405,10462406,10462409,10462410,10462411,10466414,10466420,10466421,10466422,10462422,10466423,10462423,10462424,10462427,10464427,10466429,10466432,10466433,10462436,10462437,10466439,10466440,10466444,10466448,10466449,10462449,10466450,10466451,10462451,10466452,10466453,10466454,10462454,10466455,10462455,10466456,10466457,10466458,10462458,10462459,10462460,10462461,10462462,10462463,10466471,10466472,10462472,10462478,10462479,10462480,10462481,10462487,10462488,10462495,10462496,10462497,10462501,10462502,10462503,10466504,10462504,10462505,10462514,10462518,10462521,10462522,10462540,10462541,10462542,10462543,10462544,10462545,10462546,10462579,10462580,10462583,10462585,10462589,10462590,10462599,10462618,10462619,10462623,10462624,10462626,10462627,10462628,10462629,10462630,10462631,10466845,10466846,10466847,10466848,10466849,10466850,10466851,10466852,10466853,10466854,10466855,10466856,10466857,10466858,10466859,10466860,10466861,10466862,10466863,10466864,10466865,10466866) 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'