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,10939567,10939587,10939597,10939636,10939734,10939749,10939751,10939752,10939753,10939754,10939755,7068485,10940195,10940196,7068597,10940265,10940404,10940405,10940406,10940407,10940408,10940409,10940410,7068827,7068828,8067208,8067216,8067288,8067289,8067290,8067291,4968617,4968618,4968619,4968620,4968621,4968622,4968623,4968624,4968625,4968626,4968627,4968628,4968629,4968636,4968637,8067375,10437253,10437254,10437255,8067385,8067386,8067506,8067525,8067526,10437404,8067529,8067530,10437487,10437559,10437560,10437561,10437562,10437563,10938478,10939174,10939175,10939368,10939403,10939416,10939442,10939467,10931640,10931717,10931718,10931774,10931892,10931895,10931976,10932077,4967144,4967145,4967146,10932280,8065988,8066009,10932482,10932483,10932565,10932566,10932644,10932645,10932743,10932749,10932797,10932800,10932814,10932815,10932816,10932817,10932818,10932831,10932926,10932927,10933157,10933158,10942536,10942538,10942541,10942637,8064012,10942659,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,10943139,10943141,10943163,8064692,8970230,3655576,3655643,3655660,3655661,3655664,3655666,3655669,3655671,3655673,3655784,3655785,3655794,3655795,10941120,3656215,3656216,3656231,3656232,3656290,3656291,3656292,3656293,3656294,10941356,3656353,3656438,8072718,8072719,8072720,8072721,8072722,3656684,3656685,8073011,8073013,8073081,8073090,10942083,10942167,10942168,10942169,10942194,8073497,8073518,8073530,8073531,10942430,10942505,10942515,10918519,10918520,10918619,10918703,10623327,10918922,10918923,10623421,10623485,10623489,10919264,10919265,10919266,10919267,10919293,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,10924612,10924613,10924614,10924615,10924616,10924617,10924618,10924619,10924620,10924621,10924622,10924623,10924624,10924625,10919625,10924626,10919626,10924627,10919627,10924628,10924629,10924630,10924631,10924632,10924633,10924634,10924635,10924636,10924637,10924638,10924639,10924640,10924641,10924642,10924643,10924644,10924645,10924646,10924647,10924648,10924649,10924650,10924651,10924652,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,10924685,10924686,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,10919850,10624843,10917508,10917509,10917510,10917511,10917512,10917513,10917514,10917515,10917516,10917517,10917518,10917519,10917520,10917521,10917522,10917523,10917524,10922601,10622121,10922901,10922902,10622400,10622401,10622402,10622403,10917966,10917967,10917968,10917969,10917970,10917971,10917972,10917973,10918158,10918356,10622917,10622918,10619995,10620079,10920773,10620340,10915884,10915885,10915886,10915887,10915888,10915889,10915890,10915891,10915892,10915893,10915894,10915898,10915899,10915900,10920984,10920985,10920986,10920987,10920988,10921265,10921266,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,10917088,10917089,10922256,10922257,10922258,10922269,10922272,10922273,10922274,10922275,10922276,10922277,10922278,10922279,10922280,10922281,10922282,10922283,10922284,10922299,10922461,10610998,10565312,10565313,10565314,10611179,10614634,10614636,10611694,10611806,10611807,10611837,10566088,10566089,10566090,10566091,10566092,10566093,10611964,10612028,10612040,10612042,10612044,10612047,10612048,10612061,10612104,10612106,10612209,10612213,10612260,10563417,10563418,10563419,10609327,10609340,10609341,10609342,10609343,10563548,10563549,10563550,10609400,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,10609640,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,10609825,10563977,10563978,10563979,10563980,10563981,10563982,10564008,10564009,10564010,10564044,10609902,10609903,10609904,10609907,10609908,10609909,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,10610305,10610354,10610357,10613369,10613753,10613754,10613755,10610824,10610862,10610865,10610878,10610909,10555486,10555487,10555488,10555489,10555490,10555491,10555833,10555834,10555835,10555838,10555839,10555840,10556027,10556028,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,10416402,10416428,10416442,10416501,10416502,10416558,10415598,10415740,10415816,10416823,10416825,10416826,10415831,10416834,10416836,10416839,10416840,10416846,10416850,10416856,10416860,10416865,10416867,10416870,10416872,10416874,10416876,10416882,10416885,10416890,10416891,10416894,10416898,10415899,10415900,10415901,10415902,10416043,10416044,10416045,10420078,10420082,10420110,10420111,10420112,10417117,10471104,10471113,10471115,10471487,10465757,8563210,10469914,10469926,8563249,8563250,8563251,8563252,8563253,8563254,10469966,10463979,10463980,10463981,10463982,10463983,10463984,10463985,10463986,10463987,10470062,10470067,10470126,10470145,8563559,10470502,10470507,10470631,10470728,10470731,10470734,10462741,10462742,10462743) 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'