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(10861572,10861573,10860573,10860758,10860760,10860761,10860796,10860797,10860798,10860799,10860800,10860806,10860807,10860808,10860809,10860812,10860813,10860815,10860816,7201274,7201661,7201758,10858816,8595198,8595251,8595252,8595253,8595254,5654562,5654670,3237356,3237357,7200903,7200904,10865992,7201120,7201121,7201122,10863436,10863437,10855625,10855626,10855627,10855628,10855629,10855630,10855631,10863830,10863833,7199442,7199443,7199444,7199445,7199556,7199557,7199558,7199559,7199560,7199561,7199562,7199563,7199564,7199565,7199566,10864859,10864860,10864861,10864862,10864863,10864864,10864865,10864866,10864867,10864868,11048481,11048482,10864869,10864870,10864871,10864872,10864873,10864874,10864875,10864876,10864877,10864878,10864879,10864880,10864881,10864882,10864883,10864884,10864885,10864886,10864887,10864888,10864889,10864890,10864891,10864892,10864893,10864894,10864895,10864896,10864897,10864898,10864899,10864900,10864901,10864902,10864903,10864904,10864905,10864906,10864907,10864908,10864909,10864910,10864911,10864912,10864913,10864914,10864915,10864916,10864917,10864918,10864919,10864920,10864921,10864922,10864923,10864924,10864925,10864926,10864927,10864928,10864929,10864930,10864931,10864932,10864933,10864934,10864935,10864936,10864937,10864938,10864939,10864940,10864941,10864942,10864943,10864944,10864945,10864946,10864947,10864948,10864949,10864950,10864951,10864952,10864953,10864954,10864955,10864956,10864957,10864958,10864959,10864960,10864961,10864962,10864963,10864964,10864965,10864966,10864967,10864968,10864969,10864970,10864971,10864972,10864973,10864974,10864975,10864976,10864977,10864978,10864979,10864980,10864981,10864982,10864983,10864984,10864985,10864986,10864987,10864988,10864989,10864990,10864991,10864992,10864993,10864994,10864995,10864996,10864997,10864998,10864999,10865000,10865001,10865002,10865003,10865004,10865005,3237340,3923639,10853753,8906542,8906543,8906544,8906545,8906546,8906547,8906548,10854051,10854056,10854103,10854139,10854141,10854213,7197283,10854415,10854416,7197458,7197459,7197460,10854882,10854884,10855001,10855004,10855005,8905010,10852313,10852314,10852315,10852316,10852317,10852318,10852319,10852320,10852321,10852322,10852323,10852324,10852325,10852326,10852327,10852328,10852329,10852330,10852331,10852332,10852333,10852334,10852335,10852336,10852337,10852338,10852339,10852340,10852341,10852342,10852343,10852344,10852345,10852346,10852347,10852348,10852349,10852350,10852351,10852352,10852353,8905124,10852354,8905125,10852355,8905126,10852356,8905127,10852357,10852358,10852359,10852360,10617175,10622525,10853089,10620119,10620120,10850602,10850603,3581889,10615879,10615880,10615881,10615882,10615883,10615884,10615885,10615886,10615887,10615888,10615889,10615890,10615891,10615892,10615893,10615894,10615895,10615896,10615897,10615898,10615899,10615900,10615901,10615902,10615903,10615904,10615905,10615906,10615907,10615908,10615909,10426405,10426406,10426407,8611437,10611349,10714184,10614503,10614504,10614505,7017421,7017422,7017423,7017424,7017425,7017426,7017427,7017428,7017429,7017430,7017431,7017432,7017433,7017434,7017435,7017436,7017437,7017438,7017439,7017440,7017441,7017442,7017443,7017444,7017445,7017446,7017447,7017448,7017449,7017450,7017451,7017452,7017453,7017454,7017455,7017456,7017457,7017458,7017459,7017460,7017461,7017462,7017463,7017464,7017465,7017466,7017467,7017468,7017469,7017470,7017471,7017472,7017473,7017474,7017475,7017476,7017477,7017478,7017479,7017480,7017481,7017482,7017483,7017484,7017485,7017486,7017487,7017488,7017489,7017490,7017491,7017492,7017493,7017494,7017495,7017496,7017497,7017498,7017499,7017500,7017501,7017502,7017503,7017504,7017505,7017506,7017507,7017508,7017509,7017510,7017511,7017512,10609842,8852017,8566742,8566743,10610108,10610120,10613180,8852523,8852524,8852525,10610368,10610369,10610370,10610371,10610372,10610373,10610374,9911581,9169434,9169467,10117784,10117785,9911803,9911812,9169653,9169654,9169655,9169656,9169657,9911975,9911976,9911977,10118170,10118171,10118172,10118173,6674192,6674193,10118215,10118497,10118498,8850152,9912894,8850604,9913176,9913177,9913178,9913179,9913180,9913181,9913182,9913183,9913184,9913185,9913284,10418221,7013953,10418222,7013954,10418223,7013955,10418224,7013956,7013957,10418225,7013958,10418226,7013959,10418227,7013960,10418228,7013961,10418229,7013962,10418230,10418231,10418232,10418233,10418234,10418235,10418236,10418237,10418238,10418239,10418240,10418241,10418242,10418243,10418244,10418245,10418246,10418247,10418248,10418249,10418250,10418251,10418252,10418253,10418254,10418255,10418256,10418257,10418258,10418259,10418260,10418261,10418262,10418263,10418264,10418265,10418266,10418267,10418268,10418269,10418270,10418271,10418272,10418273,10418274,10418275,10418276,10418277,10418278,10418279,10418280,10418281,10418282,10418283,10418284,10418285,10418286,10418287,10418288,10418289,10418290,10418291,10418292,10418293,10418294,6672610,6672715,6672716,6672717,6672718,6672719,10415469,10415470,10418689,9168954,10416971,10416972,10418178,10418179,10418180,10418181,10418182,10418183,10418184,10418185,10418186,10418187,10418188,10418189,10418190,10418191,10418192,10418193,10418194,10418195,10418196,10418197,10418198,10418199,10418200,10418201,10418202,10418203,10418204,10418205,10418206,10418207,10418208,10418209,10418210,10418211,10418212,10418213,10418214,10418215,10418216,10418217,10418218,10418219,10418220,8550093,8550094,8550095,8550102,8550106,8550207,8550208,8550235,10467820,10469901,976545,9167777,9167978,10470632,10470633,10470634,10470635,10470636,10470637,10470638,10470639,10470640,10470641,10470642,10470643,10470644,10470645,10470646,10470647,10470648,10470649,10470650,10470651,10470652,10470653,9168199,7013879,7013880,7013881,7013882,7013883,7013884,7013885,7013886,7013887,7013888,7013889,7013890,7013891,7013892,7013893,7013894,7013895,7013896,7013897,7013898,7013899,7013900,7013901,7013902,7013903,7013904,7013905,7013906,7013907,7013908,7013909,7013910,7013911,7013912,7013913,7013914,7013915,7013916,7013917,7013918,7013919,7013920,7013921,7013922,7013923,7013924,7013925,7013926,7013927,7013928,7013929,7013930,7013931,7013932,7013933,7013934,7013935,7013936,7013937,7013938,7013939,7013940,7013941,7013942,7013943,7013944,7013945,7013946,7013947,7013948,7013949,7013950,7013951,7013952,10888906,10888907,10888908,10888909,10888910,10888911,10888912,10888913,10888914,10888915,10888916,10888917,10888918,10888919,10888920,10888921,10889033,10884503,10884591,10889788,10890020,10885030,10885079,10885080,10885169,10882914,10887971,10887995,10883455,10625239,10625240,10885907,10162197,10162198,10647392,10647393,10647664,10603879,10603880,10604028,10508466,10507559,10409324,10413366,10413681,10410137,10410138,10410154,10410155,10410157,10410211,10410216,10410218,10494986,10410788,10410789,10410790,10410791,10410792,10410793,10410794,10408862,10408863,10408864,10408865,10408866,10408867,10408868,10408869,10408870,10408871,10408872,10408873,10408874,10408875,10408876,10408877,10408878,10408879,10408880,10408881,10408882,10408883,10408884,10408885,10408886,10408887,10408888,10408889,10408890,10408891,10408892,8562191) 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'