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(10930241,10448021,10943672,8574601,8574602,8574603,8574604,8574605,10989398,10989399,10989400,10989401,10989402,10846534,10846538,10846569,10846570,7068847,7068884,8569867,8569868,8569869,4971145,4971146,4971147,10459505,7068935,10459607,10459615,10459623,10459631,4968328,4968338,4968412,8583815,8583816,8583817,8583818,8583819,8583820,8583821,8583822,8583823,8583824,8583825,8583826,7074375,7074383,7074395,7074400,7074404,7074424,7074425,10437289,10437290,7074445,7074446,7074451,7074453,7074467,7074482,7074490,7074491,7074504,7074511,8575693,7074520,7074521,8575701,7074533,7074534,7074535,7074542,7074546,7074547,10847328,10847329,10437433,4968849,8609566,10437588,10437595,10437596,10437600,10460391,11042523,8609675,8609676,8609677,10964548,10964576,10844878,10844879,10844883,10844952,10498044,10498045,10498061,10845030,8068462,8068463,10845325,10845326,8068470,10845340,10929924,8620500,11001370,8068602,8838295,8838298,8838304,8838307,8838308,8838309,8838316,8838317,8838318,8838322,8620676,8838336,8620683,10985653,8835547,8835548,8835549,8835550,8835551,8835552,8835553,8835554,8835555,8835556,10103318,10103403,3238788,10960088,10960089,10960090,10103560,10931919,10931937,10931944,10931957,10931958,10931959,10931960,10843493,10999495,8836335,8836336,10999538,10104102,3899504,3899505,3899506,10843786,10932608,10932615,10932639,10844074,10932680,10932689,7202608,8066458,7202733,7065604,7065605,3227057,3227058,3227059,10933105,10933107,10841711,8834574,8616951,8616952,8616953,8834706,8834707,8834708,11010911,11010912,11010913,10958942,10958951,7071355,7071386,7071387,11037072,11037073,11037074,11037109,11037110,10102563,11037168,8910556,8910558,8910562,5999940,5999941,8910755,8835251,8910833,7071811,10102942,10940568,10940569,8908014,7068974,7068975,7068976,7068999,7069022,10995735,10995736,10995737,10995738,10995739,10995740,7069070,7069071,7069074,8908307,8908308,10995974,10995975,11008998,11008999,8908427,8908428,8908429,8908430,8908431,8908432,8908433,8908434,8908435,8908436,8908437,8908438,8908439,10840221,10840222,8072314,8615570,8908806,8615672,8908979,8909025,8909050,8072773,8072774,8072775,8072776,8072777,10101338,10958012,8565119,10942114,10942115,10942117,11048398,8565265,8565279,11010255,11010278,11010292,10942277,11048603,10101886,10841568,10841569,10841676,10841677,10841678,10841679,10841680,10841681,10841682,10841683,10841684,10841685,4936809,10954780,10954781,4936930,10980892,10980893,10980894,10980895,10980896,10980897,10980898,10980899,10980900,10980901,10980902,10980903,10980905,10980906,10980907,10980908,10980909,10980911,10980912,10980913,10980914,10980915,10980916,10980917,10980918,10954923,10954924,10954938,4937066,4937078,4937090,4937102,10838134,10838135,10838136,10838137,10838138,10838139,10838140,10838141,11007397,8906880,8906881,10618968,8613778,10618969,8613779,8613780,8613781,8613782,8613783,8613784,8613785,8613786,8613787,8613792,8613793,8613797,8613798,8613807,8613808,8613809,8613810,8613811,8613812,10619117,11007821,11007822,8070925,8070929,8070952,8070954,8070959,4938052,8071163,8907524,8071321,8071333,8071349,8071361,4938477,4938478,4938479,4938480,4938481,10619844,8541516,8541518,10927561,10922603,10922610,10967042,10967043,10967044,10967045,10967046,10967047,10967048,10967049,10967050,10967051,10954282,8542114,10837541,10980473,8905867,10951679,11042902,11042903,10848253,10930624,10930837,10930881,10930882,10930898,10930899,8540580,10952787,10952803,10621371,10621372,10979046,10621427,10426851,10426852,10426897,10426898,10426926,8541140,8904704,10427015,10427016,10427017,10427018,10427019,10427020,10427021,10427022,10427023,10427024,10427025,10427026,10427027,10427028,10922205,8541262,8541294,8541311,10979484,10979485,8541313,8541314,10979486,10979487,10979488,10979489,10979490,10979491,10979492,10979493,10979494,10979495,10979496,10979497,8577990,8577991,10979498,10979499,10979500,10979501,10979502,10979503,10979504,10979505,11044523,8541378,10922459,9197453,9197459,9221435,9197462,9197463,9221436,9197464,9197466,9197473,9197479,9205482,8864228,10122142,6666008,6666009,6666010,9198099,8864649,8864650,8864687,8864688,8864797,8864799,8864800,9179339,9179343,8542706,9179706,9179707,9179708,9179709,9179710,9179711,9179712,9179713,9179714,9179715,9179716,9179717,9179718,9179719,9179720,9179721,9179722,9179723,9179724,9179725,9179726,9179727,9179728,9179729,9179730,9179732,9179733,9179734,9179735,9179736,9179737,9211818,7058004,10609709,10120455,10120484,10120485,10561108,10561109,10561110,10561137,10120555,10120579,10610067,9220512,9188595,7058811,9188718,9188719,9188737,10564639,10564659,9196942,9196943,8863469,8863470,8863471,10564770,10564771,10564772,10564773,10561778,10561779,9205002,10564830,10561912,10561913,10561914,9165254,10562070,9193357,9185413,9185414,10125848,4974752,4974753,10513735,10126216,9162129,10118456,7056491,7056492,10516185,9178534,9178535,9186538,9186565,9178685,7056869,7056870,7056871,7056872,7056873,7056874,7056875,7056876,7056877,7056878,7056879,7056880,2809399,10118973,9178811,9178812,9178813,9178814,9178815,9178816,9178817,9178818,9178852,9178853,9178854,9210917,2809651,9179050,9179051,9179052,9179053,9179054,9179055,9179056,9179057,10119349,10119350,10518980,4973349,4973350,10124769,10124770,10124810,10124811,10124835,4973555,10416739,10416742,10416744,10416746,10416747,10416749,10416750,10416754,10416756,10117045,10117046,4973707,4973708,4973709,4973850,4973851,4973852,4973853,10417032,10122586,9198391,9198392,10122596,9198517,9198530,9198552,10467175,10467176,10467177,9190717,9166895,9166896,9166897,9166898,9166899,9166900,9166901,6666971,6666972,6666973,9199085,8550363,6667243,4972105,4972115,4972116,10123499,9183364,10123572,10123704,8550819,8917325,6667776,8550973,8550983,8917482,8917483,8551005,10468428,10468430,10468432,10468434,8551044,8551045,8551046,8551054,8551064,8551070,8551071,8551072,8551091,8551116,8551117,8551125,8551126,8551139,8551140,8551141,8551166,8551167,8551168,8551181,8551182,8551183,8551189,10116287,8917878,9176278,10627978,8593818,8593819,8593820,8593931,8593932,10888940,10174987,10174994,10628527,10628528,8594268,8594571,8594572,10884609,8069016,8069017,8069018,8069024,8069025,10155847,10155851,10155852,8069241,10889950,10875028,10890086,10163524,10163525,10173786,10173787,10173788,10173789,10173812,10173813,7001093,10627540,10174104,10184244,10174278,10174279,10184295,10174318,10174319,10174320,10174321,10162127,10162128,10162129,10162130,10167281,10167282,10167283,10167284,10167285,10167286,10167287,10167288,10167289,10167290,10167291,10167292,10167293,10167294,10167295,10167299,10949324,10949325,10881515,10949326,10949327,10949328,10949329,10949330,10949331,10949332,10949333,10949334,10949335,10949336,10949337,10172540,10172541,10172542,10172557,10172558,10172559,10172560,10172561,10172562,10172563,10172564,10172565,10172566,10881557,10881565,10172596,10881593,10172623,10172650,10172651,10172652,10172653,10172654,10172655,10172656,10172657,10172693,10172694,10187826,10187827,10187828,10949886,10887080,10949892,10173369,10950196,10950197,10950206,10580527,10580538,10580539,10580540,10580541,10580542,10580543,10580556,10580557,10580561,10646998,10567586,10588724,10588725,10588727,10588731,10588733,10579793,10579794,10527154,10527155,10527156,10527157,10527158,10527159,10527160,10527161,10527162,10527163,10527164,10537650,10537651,10521837,10521838,10521839,10538275,10520304,10520305,10520306,10520307,10520308,10520309,10520310,10520311,10520312,10520313,10520314,10520315,10532656,10532657,10531028,10423383,10505544,10422756,10422757,10424068,10421113,10421114,10421115,10421116,10421117,10421118,10421119,10490045,10490049,10490050,10490056,10490066,10490081,10490109,10490110,10490131,10490132,10490133,10490134,10490135,10488221,10473330,10473331,10473350,10473404,10473405,10473406,10473407,10473408,10473443,10473444,10473445,10473446,10486477,10486478,10486479,10486480,10473493,10473494,10473495,10473516,10473517,10496600,10496601,10479894,10479923,10479924,10479925,10479926,10479927,10479928,10473959,10473960,10473961,10479991,10479993,10479994,10473996,10479996,10473997,10479997,10473998,10473999,10480000,10480005,10480008,10480014,10480015,10480018,10480019,10480026,10480027,10474028,10480028,10474029,10474030,10474031,10474038,10480040,10480042,10474049,10474050,10474055,10474060,10474062,10474068,10487205,10487206,10487207,10489350,10489351,10476357,10489394,10489412,10487436,10487437,10487444,10480467,10480478,10480492,10480493,10480497,10480498,10480499,10480504,10406873,10406874,10476589,10476590,10476591,10476592,10472822) 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'