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(7067892,7067895,7067897,7067899,7067901,7067903,7075912,7075913,10943594,10943595,7068094,10943628,7076127,7076128,10939907,10939908,7068220,7068221,7068222,7068223,7068224,4970671,10989094,10989096,10940145,10940146,10940147,10940148,7068519,7068520,7068521,7068522,7068523,10940297,10940298,10940299,10940300,10940301,8569757,7065830,7065831,7065832,7065834,10963520,10963521,7065838,7065839,10976624,10976625,10976626,10976627,10976628,10976629,10976630,10976631,10976632,10976633,10976634,10976635,10976636,10976637,10976744,10963879,8067396,7066344,7066348,10990171,10990172,10990173,10990174,10990175,10990176,10990177,10990178,10990179,10990180,10990181,10990182,10990183,10990184,10990185,10990186,10990187,10990188,10990189,10990190,10990191,10990192,10990193,10964440,10964441,10964442,10964443,10964444,10964445,10964446,10964447,10964448,10964449,10964450,8067903,10938673,7067196,7067236,7067298,10962361,7067697,10939443,10939465,7075776,7075778,10959567,10972643,10972645,10985771,10985861,7072263,10931830,10960218,10960219,10960220,10960221,10960305,7064733,7064735,8065804,7064771,10960527,10960528,10960529,10960530,10960531,10960532,10960533,10960534,10960535,10960536,10960537,10960538,10960539,10960540,10960541,10960542,10960543,10960544,10960545,10960546,8065953,8065954,8065955,8065956,8065957,8065958,7064892,8066127,8066177,10974474,10974475,10974476,10974477,10974478,10974479,10984541,10984542,10984543,10984577,10984578,10984579,10984580,10984581,10984582,10984583,10984584,10984585,10984586,10984587,10984588,10984589,10984590,10984591,7071093,7071267,7071325,8064474,8064475,8064476,10985141,8064555,8064556,10943257,10943289,10943342,7069346,10941262,10941703,10941705,10941771,10941777,10941781,10941839,7070342,8860418,8860419,8860420,10942385,8073529,10928700,10928701,10618209,10954779,10967846,10954847,10954925,10967930,8070134,8070136,8070139,10623494,10623496,10623507,8070224,8070225,10623730,10619352,10624548,10619891,10619892,10619900,10953500,10927507,10927508,10617035,10953670,10953671,10953672,10953673,10953674,10953675,10622258,10622264,10622265,10622267,10622268,10617322,10617327,10617333,10617334,10617335,10617336,10617337,10617338,10617349,10617350,10617351,10617352,10617355,10617356,10617357,10617358,10617359,10622360,10617360,10617361,10617362,10617363,10617364,10617365,10617366,10617367,10617368,10617369,10617376,10617383,10922896,10617395,10622402,10622408,10617418,10617419,10617420,10617421,10617422,10617423,10617427,10622431,10617432,10617433,10622447,10617451,10617453,10617456,10954004,10928007,10617510,10622514,10622516,10622523,10954113,10954114,10622677,10622678,10622679,10622680,10622681,10617804,10615036,10615076,10620085,10620172,8570040,10615229,10620254,10620255,10620256,10620257,10620258,10620259,8570094,8570115,10620297,10620298,10620301,10620302,10620303,10615329,10615330,10615338,10615340,10615341,10615342,10615343,10615344,10620717,10620718,10930665,10930666,10930667,10615896,10620920,10620921,10930732,10620922,10620923,10616044,10616243,10616245,10616248,10616252,10616253,10616258,10616287,10616329,10616332,10616333,10616370,10616417,10616423,10616426,10616648,10616649,10927260,10953318,10610964,10610985,10613998,10613999,10614000,10614001,10614002,10614003,10614004,10614005,10614006,10614007,10614008,10614009,10614010,10614011,10614012,10614013,10614014,10614015,10614016,10614017,10614018,10614019,10614064,8863986,8864011,10614221,7059777,10559609,10614497,10614498,10611659,6665998,6666004,10611758,10611782,10611832,6666208,6666209,6666213,6666217,6666218,6666219,6666220,6666259,10611954,10611969,10611970,10612059,10612086,10612106,10609155,7057713,7057714,10609285,8862146,7057799,10609375,10612381,7058023,8862481,8862558,10557973,10557975,10557976,10609913,10612937,10612960,10612961,10610057,10610060,10558318,10558320,10613179,10610233,10610247,10610248,10610249,10610250,10610251,10610292,10613306,10610312,10613341,10613391,10613392,10613393,10613394,10561561,10561562,10610429,10610435,10610480,10610481,10610482,10613506,10613524,10613525,10610634,10610635,10610636,10610637,10610638,10610639,10610640,10610729,10610730,10610739,10613740,10613750,10610777,10610850,10610890,8863778,10610947,10610954,9161354,9161355,9161361,10515328,7055775,10513565,7055956,10515683,10515684,10515685,10515686,10515687,10515688,10515689,10515690,10515692,10515693,10515694,10515695,10515696,10515697,10515698,10515699,10515700,10515701,10515702,10515703,10515704,10515705,10515706,10515707,9161895,10515708,10515709,10515710,10515711,10513914,9162137,7056334,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,10516865,10516866,10516867,9160319,9160334,9160335,10419271,10416354,10416355,10416362,10416369,4973319,4973335,4973336,4973337,4973338,10416429,10417443,10417444,10419471,10419480,10419481,10419482,10419483,10419484,4973428,4973429,4973434,4973435,4973436,10419520,10419668,10415675,10419676,10419689,10419693,10419706,10419720,10419725,10419728,10419729,10419732,10419733,10415733,10415734,10419739,10419748,10419749,10419750,10415793,10415829,10418832,10418833,10418834,10419837,10419838,10419840,10418853,10418854,9160967,10419899,10419900,7055155,10419994,10419997,10419999,10420000,10420004,10420006,10420008,10420011,10417058,10417063,10417071,10417076,10417077,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10419108,10417109,10417110,10417111,10419111,10417112,10417113,10417114,10417115,10417116,10417117,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,9161218,10417140,10417141,10417142,10417143,10417144,10417145,10417146,10417147,10417148,10417149,10417150,10417151,10417152,10417153,10417154,10417155,10417156,10417157,10417158,10417159,10417160,10419188,7055458,7055459,10463007,10463008,10463013,10467097,10467107,10467142,10463181,10463182,10463183,4971462,4971463,10467219,10467220,10467221,10469245,10469277,10469278,10469372,10469373,10469374,10469375,10469376,10469377,10463378,10469378,10463379,10463380,8916476,10467443,6666946,4971825,8916645,4971883,10463654,10463668,10463669,10463672,10463675,8916759,10465703,10463738,10463747,10465758,10465765,10465767,10465769,10463777,10463778,10463779,10465780,10463788,10463827,10467831,10465849,10465851,10465863,10465864,10467871,10465874,10463886,10463887,10463888,10465891,10463892,10465902,10465904,10465905,10463906,10467909,10465909,10467910,10467911,10467912,10463913,10467913,10467914,10467915,10465916,10463927,8563250,8563252,4972257,8563358,8563359,10464079,10464080,4972481,10466225,10466226,10466235,10466236,10466243,10462299,10462301,10462303,10462304,10462309,10462322,10462323,10468329,10466330,10466331,10466384,10466390,4972672,10466398,10462401,10462404,10462405,10466410,10466411,10466416,10466417,10466418,10466419,10466422,10466423,10466429,10466430,10466431,10466438,10462450,10466452,10462453,6667875,10466455,10462479,10462480,10462481,10462489,10462496,10462497,10462540,10462542,10462588,10462593,10462594,10462595,10462602,10462605,10462609,10462611,10462622,10462624,10462631,6668126,10462726,10466845,10628321,10628325,10628383,10159957,10628513,10628534,10155731,10156041,10156108,10627085,10632161,10632162,10632163,10632164,10632165,10632169,10627319,10153863,10627583,10627585,10627587,10630147,10630176,10630177,10630272,10626134,10626139,10626140,10626205,10626375,10626378,10626379,10631430,10631431,10631432,10631446,10631447,10631448,10631449,10626453,10626454,10631546,10626602,10626787,10626842,10631859,10158446,10568112,10568294,10568302,10568303,10567578,10567621,10522293,10522294,10522295,10522299,10522305,10522311,10522316,10522317,10522353,10522373,10524419,10522450,10522463,10522612,10522613,10420313,10420319,10420320,10420322,10420324,10420326,10421399,10421403,10421404,10421405,10421408,10421409,10421410,10420424,10420425,10420428,10420429,10420432,10420441,10420442,10421488,10422598,10421600,10421633,10421891,10421966,10421983,10423000,10423014,10423015,10423016,10423017,10423018,10423020,10421036,10421037,10423160,10477731,10477733,10477785,10472764) 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'