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(7067979,7067984,7067987,10975736,10975737,10975738,10975739,10975740,10975741,10975742,10975832,10975833,10975834,10975835,10975836,10975837,10975838,10975839,10975840,10975841,10975842,10975843,10975844,10975845,10975846,10975847,10975848,7068338,10976036,10976037,10976038,10989045,10989046,10989047,10989048,10976125,10976126,10976127,10976128,10976129,10976130,10976131,10976132,10976133,10976134,10976135,10976136,10976137,10976138,10976139,10976140,10976141,10976142,10976143,10976144,7068460,10976145,10976146,10976147,10976148,10976149,10976150,10976151,10976152,10976153,10976154,10976155,10976156,10976157,10976158,10976159,10976160,10976161,10976162,10976163,10976164,10976165,10976166,10976167,10976168,10976169,10976170,10976171,10976172,10976173,10976174,10976175,10976176,10976177,10976178,10976179,10940263,4970960,8569743,10950429,10950430,8569817,8569820,7074157,7074158,7074159,7074162,8067235,8067236,7074377,10951058,8067549,7074600,7074607,7074622,7074625,7074641,7074644,7074648,7074652,8067637,7074664,7074665,8067659,8067660,8067661,8067662,10437598,10437629,11042478,7074845,7074862,7074863,10938495,7074875,7074876,10938719,11039952,11039957,11039958,11039959,11039960,11039961,11039962,11039963,11039964,11039965,11039966,11039967,11039968,11039969,11039970,11039971,11039979,11039980,11039988,11039989,11039992,11039994,11039995,8068321,8068322,8068323,8068324,8068325,8068326,8068327,8068328,8068349,8068351,8068352,8068375,8068376,8068377,8068378,8068389,8068390,8068391,8068392,8068393,8068394,10975570,10975571,10975572,10975573,10975574,10975575,10975576,10975577,10975578,10975579,10975580,10975581,10975582,8838388,10975583,10975584,8838389,10975585,10975586,10975587,10975588,10975589,10975590,10975591,10975592,10975593,10975594,8838417,11037622,11037623,11037624,11037625,10931336,8835485,10931358,10931407,10931408,7064086,7064087,10972801,10972802,10972812,10972813,10972814,10972815,10972816,10972854,10972858,10972859,10972906,10972907,10972912,10972913,10972915,10972916,10972928,10972929,10972933,10972934,7072347,7072348,7072349,7072358,7072359,7072360,8075145,8075146,8075147,8075188,8075189,8075190,11038285,11038286,11038287,7064773,7064774,10932178,10932205,4967126,4967127,4967128,4967129,4967130,4967131,4967132,4967133,4967135,8836565,10999832,10999833,10999834,10999835,10999836,10999837,11038907,11038908,11038909,11038910,11038911,11038912,11038913,11038914,11038915,11038916,11038917,11038918,11038919,11039002,8066375,8066376,8066407,8066408,8066412,8066413,8066414,8066415,8066416,10932914,10932919,10933082,10933148,10933182,8073670,8073671,8073672,8073673,11049781,10997643,8073722,8073723,8073724,8073725,8073726,8073727,8064009,8073776,8073777,8073778,10984749,10984755,10984756,8073825,8073826,8073827,8073828,10942784,11036856,11049091,11036877,10942890,8064248,10942957,11037021,11037043,10942988,10942989,10942990,10942991,10942992,10942993,10942994,10942995,10942996,10942997,10942998,10942999,10943000,10943001,10943002,10943003,10943007,10943048,11049344,10985476,10985477,11037488,7071820,8970235,11037530,8970236,8970237,11037536,11037537,10931204,10931248,11037617,10944916,10944917,10944918,10944919,3656403,3656424,3656425,3656426,3656427,3656428,3656429,3656430,3656431,3656432,3656433,3656434,3656435,3656436,11047794,3656468,3656479,11047895,11047906,11047921,10941654,11047980,11048008,11048013,11048046,11048103,7070558,8565297,8565312,10942421,11036580,10923568,10923569,10923570,10618507,10618516,10618517,10618519,10618522,10618527,10955200,8070338,8070344,10955401,10955402,10924255,10924266,10924319,10924320,10924321,10924322,10968637,10955819,10924800,10924801,10924802,10924803,10924804,10924805,10619410,10619411,8071216,10956191,10956224,10956378,10956379,10619852,10925387,10925388,10925389,10925390,10925391,10925392,10925393,10925394,10925395,10925396,10922619,10922646,10922647,10922648,10922649,10922650,10922651,10922652,10922658,10922663,10922666,10922667,10967286,10967287,10967288,10622653,10622654,10622655,10964661,10964662,8570344,8570354,10615516,10991297,10991298,10930963,10930964,10621335,10621336,10621357,10621358,11044524,11044525,11044526,10992594,9205315,9205317,7059599,9189443,9205458,9205459,9205460,9205461,10611226,9205701,9205702,10614401,9205778,9205796,9205803,9205804,9205805,9205806,9205807,9205808,9205812,9205813,9205814,9205815,9205816,9205818,9205819,9205820,9205827,9181922,9181932,9206187,9206189,9206190,9206191,9206192,9206193,9174272,9174273,9174274,9174275,8864798,9190289,9179542,9163700,9164026,9164107,9164114,9164244,9164245,9164336,7058843,7058844,7058845,7058846,9188876,8863428,8863429,8863430,7059161,7059162,7059163,7059164,7059165,7059166,7059167,7059168,7059188,7059191,7059307,7059308,7059309,7059310,7059311,7059312,7059313,7059314,7059315,7059316,7059317,7059318,7059319,7059320,7059321,7059322,10610824,10610850,7059450,7059451,7059452,10517243,4974773,4974774,4974775,7056312,2809376,9162845,9162846,9162847,9162848,9162849,9162853,9162854,9162855,9162858,9162862,9162863,9162867,9162868,7057135,9178996,9178997,9179001,9179005,8861570,10415288,9192724,9192725,9192740,9192757,10418683,10418684,9176956,9176957,9177035,10416055,9185218,10419142,8864834,9190339,4971686,4971687,4971688,4971689,4971690,4971691,10465676,10471800,10471809,10471837,10471845,10471853,10471858,10471872,8563370,8563371,8563392,6667796,9192146,6668179,6668180,9192271,9192272,9192273,9192274,10170783,10161298,10629929,10629930,10168553,10168554,10168555,10168556,10168557,10168576,10168578,10168579,10168593,10168594,10168595,10168598,10168599,10168600,10168601,10168602,10168603,10168604,10173903,10173904,10173905,10173941,10174084,10174085,10627602,10627603,10627604,10627605,10627683,10627684,10627685,10627686,10627687,10627688,10174216,10156750,10156783,10630264,10156787,10156848,10156904,10156921,10156999,10157152,10157172,10167261,10167262,10167265,10167269,10167271,10167279,10157301,10157357,10157377,10625876,10625877,10172403,10157407,10630896,10157419,10630897,10630898,10630899,10630900,10630901,10630902,10630903,10630904,10630905,10630906,10630907,10630908,10630909,10630910,10630911,10630912,10630913,10630914,10630915,10630916,10630941,10630943,10630945,10630948,10167496,10167497,10167498,10630977,10630978,10630979,10630980,10157503,10630981,10167504,10630982,10630983,10630984,10630985,10630986,10630987,10157510,10630988,10630989,10167512,10630990,10167513,10630991,10167514,10630992,10630993,10630994,10630995,10630996,10630997,10630998,10630999,10167525,10167526,10167527,10157551,10157591,10157612,10157668,10157719,10157851,10157903,10157921,10157922,10157923,10157924,10157925,10172926,10157928,10172984,10157995,10631509,10173044,10173094,10173213,10158219,10158416,10158417,10580521,10580651,10580652,10580719,10572312,10572313,10581533,10581534,10581535,10581536,10581537,10581538,10581539,10581540,10581541,10581542,10581543,10581544,10581545,10581546,10581547,10581548,10581549,10581550,10581551,10581552,10575563,10575564,10575565,10575566,10575567,10575568,10575569,10575570,10575571,10581583,10581584,10581585,10581596,10581597,10581598,10581599,10569742,10569743,10569744,10569767,10569768,10569769,10581787,10581798,10581799,10581800,10581801,10578841,10578842,10581852,10581853,10581854,10581855,10581856,10581857,10581894,10581895,10581942,10573028,10579100,10579101,10579102,10576180,10576181,10523223,10519425,10421329,10421461,10421478,10422602,10423791,10500080,10500081,10500082,10500083,10500084,10500085,10500086,10500087,10500088,10500089,10500090,10500091,10500092,10500093,10500094,10500095,10500096,10500097,10500098,10500099,10500104,10472927,10472930,10472943,10473178,10473180,10473257,10473284,10473300,10473362,10473395,10473414,10473472,10473480,10475487,10475488,10475489,10475504,10475511,10475512,10475513,10475514,10475519,10473525,10475596,10475597,10475598,10475601,10475602,10475603,10475622,10475627,10473701,10473735,10473740,10479756,10479757,10479758,10479759,10473767,10473772,10473773,10473788,10473789,10473793,10473796,10473797,10473817,10473824,10473846,10473856,10473857,10473858,10473861,10473863,10471890,10471891,10473894,10471903,10473907,10473915,10473916,10471917,10473919,10471921,10473931,10473946,10473954,10473959,10473963,10473973,10471976,10473976,10471986,10471989,10471995,10472018,10472056,10474081,10474084,10472095,10474104,10472109,10472112,10474127,10474128,10472129,10472131,10472132,10472133,10472135,10472137,10472138,10472139,10472140,10472141,10472145,10474160,10472189,10472190,10474197,10472207,10482324,10474324,10474336,10482490,10474519,10474520,10474530,10474532,10474575,10472725,10474741,10474742,10474769,10472781,10485782,10485783,10485784,10474784,10485785,10474802,10474826,10474827) 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'