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(7067912,7076227,7068485,8569556,7068597,8569704,8569786,8569787,8569788,8569789,8569790,8569791,7073996,7074012,7074033,7074160,7066174,7066213,7066248,7066249,4968617,4968618,4968619,4968620,4968621,4968622,4968623,4968624,4968625,4968626,4968627,4968628,4968629,4968636,4968637,7074301,7074303,10437253,10437254,10437255,7074355,7074356,7074357,7074358,7074359,7074393,7074394,7074395,7074396,7074397,10437404,10437487,10437559,10437560,10437561,10437562,10437563,7074672,7074715,7075014,7075015,7067071,7067072,7075209,7075320,7067370,7067390,6000104,7071866,7071979,7071980,7064091,7064092,10931640,10931717,10931718,7072280,10931774,10931892,10931895,7064502,7072503,7064503,7064504,10931976,7072561,7072562,7072567,7072568,7072609,10932077,7064690,7072711,4967144,4967145,4967146,10932280,10932482,10932483,10932565,10932566,10932644,10932645,10932743,10932749,10932797,10932800,10932814,10932815,10932816,10932817,10932818,10932831,10932926,10932927,10933157,10933158,10942536,10942538,10942541,10942637,10942659,8861006,8861040,8074037,8074038,8074039,8074040,8074041,8074042,8074043,8074044,8074045,8074046,8074047,8074048,8074049,8074050,8074051,8074052,8074053,8074054,8074055,8074056,8074057,8074058,8074059,8074060,8074061,8074062,8074063,8074064,8074065,8074066,8074067,8074068,8074069,8074070,8074071,8074072,8074073,8074074,8074075,8074076,8074077,8074078,8074079,8074080,8074081,8074082,8074083,8074084,8074085,8074086,8074087,8074088,8074089,8074090,8074091,8074092,8074093,8074094,8074095,8074096,8074097,8074098,8074099,8074100,8074101,8074102,8074103,8074104,8074105,8074106,8074107,8074108,8074109,8074110,8074111,8074112,8074113,8074114,8074115,8074116,8074117,8074118,8074119,8074120,8074121,8074122,10943009,10943010,8861254,8861300,8861311,10943139,10943141,10943163,8861395,5999930,5999937,5999958,5999964,5999966,5999984,5999986,5999988,5999990,5999992,5999993,5999996,5999998,6000000,6000002,6000004,6000005,6000006,6000007,6000008,6000009,6000010,6000011,6000014,6000017,6000021,6000022,6000023,6000024,8970230,6000097,10944861,10941120,10945086,10941356,8072718,8072719,8072720,8072721,8072722,8073011,8073013,8073081,8073090,10942083,8860324,8860355,10942167,10942168,10942169,8860366,10942194,8860393,8860397,8860399,8860513,8860520,8073497,8073518,8073530,8073531,10942430,8860642,8860644,8860653,8860654,10942505,10942515,8070022,8070023,10623327,10623421,10623485,10623489,10924575,10924576,10924577,10924578,10924579,10924580,10924581,10924582,10924583,10924584,10924585,10924586,10924587,10924588,10924589,10924590,10924591,10924592,10924593,10924594,10924595,10924596,10924597,10924598,10924599,10924600,10924601,10924602,10924603,10924604,10924605,10924606,10924607,10924608,10924609,10924610,10924611,8070809,10924612,10924613,10924614,10924615,10924616,10924617,10924618,10924619,10924620,10924621,10924622,10924623,10924624,10924625,10924626,10924627,10924628,10924629,10924630,8070829,10924631,10924632,10924633,10924634,10924635,10924636,10924637,10924638,8070837,10924639,10924640,10924641,8070840,10924642,10924643,10924644,10924645,10924646,8070844,8070845,10924647,10924648,10924649,10924650,10924651,10924652,8070851,10924653,10924654,10924655,10924656,10924657,10924658,10924659,10924660,10924661,10924662,10924663,10924664,10924665,10924666,10924667,10924668,10924669,10924670,10924671,10924672,10924673,10924674,10924675,10924676,10924677,10924678,10924679,10924680,10924681,10924682,10924683,10924684,8070883,10924685,10924686,8070885,10924687,10924688,10924689,10924690,10924691,10924692,10924693,10924694,10924695,10924696,10924697,10924698,10924699,10924700,10924701,10924702,10924703,10924704,10924705,10924706,10924707,10924708,10924709,10924710,10924711,10924712,10924713,10924714,10924715,10924716,10924717,10924718,10924719,10924720,10924721,10924722,10924723,10924724,10924725,10924726,10924727,10924728,10924729,10924730,10924731,10924732,10924733,10924734,10924735,10924736,10924737,10924738,10924739,10924740,10924741,10924742,10924743,10924744,10924745,10924746,10924747,10924748,10924749,10924750,10924751,10924752,10924753,10924754,10924755,10924756,10924757,10924758,10924759,10924760,10924761,10924762,10924763,10924764,10924765,10924766,10924767,10924768,10924769,8071142,8071143,8071144,10624843,10922601,10622121,10922901,10922902,10622400,10622401,10622402,10622403,10622917,10622918,10619995,10620079,10920773,10620340,10925870,10920984,10920985,10920986,10920987,10920988,10926146,10926175,10926176,10921265,10921266,10926279,10926285,10620874,10921416,10921424,10621117,10621118,10621119,10621120,10621121,10621122,10621123,10621124,10621125,10621126,10621127,10621128,10621129,10621130,10921641,10621131,10621132,10621133,10621134,10621135,10621136,10921763,10926835,10922256,10922257,10922258,10922269,10922272,10922273,10922274,10922275,10922276,10922277,10922278,10922279,10922280,10922281,10922282,10922283,10922284,10922299,10922461,10565312,10565313,10565314,10559499,10559504,10559507,10559508,10559692,10559768,10614634,10614636,10566088,10566089,10566090,10566091,10566092,10566093,10611964,10612028,10612040,10612042,10612044,10612047,10612048,10612061,10612104,10612106,10557343,10557344,10557345,10612209,10612213,10612260,10563417,10563418,10563419,10563548,10563549,10563550,10557562,10563583,10563592,10563593,10563594,10563595,10563596,10563597,10563598,10563599,10563600,10563601,10563627,10563628,10612487,10563693,10563694,10563695,10563696,10563699,10563709,10563714,10563715,10563716,10563717,10563718,10563719,10563728,10563729,10563730,10563731,10563732,10563742,10563743,10563744,10563789,10563791,10563792,10563793,10563794,10563798,10563799,10563800,10563801,10563802,10563803,10563804,10563806,10563807,10563808,10563809,10563810,10563811,10563812,10563822,10563823,10563824,10563825,10563826,10563836,10563837,10563838,10563850,10612702,10612703,10563880,10612740,10612756,10563910,10563911,10563912,10563913,10563914,10612764,10563915,10563916,10563923,10563927,10563928,10563929,10563930,10563931,10563932,10563933,10563938,10563939,10563940,10563941,10563942,10563943,10563944,10563947,10563948,10563949,10563950,10563951,10563952,10563953,10563954,10563957,10563958,10563959,10563960,10563961,10563970,10563971,10563972,10563973,10563974,10563977,10563978,10563979,10563980,10563981,10563982,10564008,10564009,10564010,10564044,10564130,10564131,10564132,10564133,10564134,10564135,10564136,10564146,10564147,10564155,10564156,10564157,10564158,10564159,10564160,10564164,10564165,10564166,10564167,10564168,10564169,10564170,10564171,10564172,10564173,10564174,10564175,10564176,10564177,10564178,10564179,10564180,10564181,10564182,10564183,10564184,10564185,10564188,10564189,10564190,10564191,10564192,10564193,10564194,10564195,10564196,10564197,10564263,10564264,10564265,10564266,10564267,10564268,10564269,10564270,10613168,10564320,10564321,10564322,10564323,10564324,10613180,10564389,10564390,10564414,10564428,10564444,10564445,10564446,10613298,10564450,10558452,10558454,10558455,10558456,10558457,10558468,10558471,10613369,10558578,10558588,10558589,10558590,10613753,10613754,10613755,10513124,10513398,10513627,10513790,10513791,10513792,10513793,10513794,10513795,10513796,10513797,10513798,10513799,10513800,10513801,10513802,10513803,10513804,10513805,10513806,10513807,10513808,10513809,10513810,10513811,10513812,10513813,10513814,10513815,10513816,10513817,10513818,10513819,10513820,10513821,10514025,10514026,10518076,10518556,10512813,10512860,10512861,10512862,10512863,10512864,10512865,10512866,10512867,10512868,10512869,10512870,10512871,10512872,10512873,10512874,10512875,10512876,10512877,10512878,10512879,10512880,10512881,10512882,10512883,10512884,10512885,10512886,10512887,10512888,10512889,10512890,10512891,10512892,10512893,10512894,10512895,10512896,10512897,10512898,10512899,10512900,10512901,10512902,10513027,10416237,10416254,10419306,10419307,10419308,10419309,10419310,10419311,10419312,10419313,10419314,10419315,10419316,10419317,10419318,10419319,10419320,10419321,10419322,10419323,10419324,10419325,10419326,10419327,10419328,10419329,10417356,10417392,10416402,10416428,10416442,10417465,10416501,10416502,10416558,10417734,10416823,10416825,10416826,10416834,10416836,10416839,10416840,10416846,10416850,10416856,10416860,10416865,10416867,10416870,10416872,10416874,10416876,10416882,10416885,10416890,10416891,10416894,10416898,10420078,10420082,10420110,10420111,10420112,10417117,10471104,10471113,10471115,10471487,10467617,10467618,10467619,10467620,10467621,10465757,10469914,10469926,10469966,10463979,10463980,10463981,10463982,10463983,10463984,10463985,10463986,10463987,10470062,10470067,10470126,10470145,10466244,10466250,10470502,10470507,10470631,10470728,10470731,10470734) 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'