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(7075818,7067819,10939543,7075849,7067851,7075870,7067877,7067881,7075883,7075885,7067893,7067895,7067897,7067901,10943429,10943430,7075923,10943439,7067934,7067935,10943449,10943456,7068009,10943521,7076017,7068023,10943536,7068025,10943547,10943555,7068047,7068049,7068051,10943567,7068060,10943578,10943581,7068076,10943587,10943598,7068093,7076093,7068094,7068096,7076096,7068097,7076117,10943631,10943640,7068145,10943682,7076183,7068183,10943714,10943731,7076227,10943742,7076232,4970607,4970608,4970609,4970610,4970611,10943795,10943801,10943802,7068299,7068308,7068324,7068339,10943851,7068383,7068386,7068400,7068402,7068406,7068414,10943955,8569451,7068492,7068493,7068495,10944009,8569484,10944023,10944027,7068519,10944040,10944056,10944062,10944082,4970929,10944123,4970949,10940338,8569621,7068648,10944168,10944171,7068664,8569653,10944192,10963385,8569692,10944244,10944245,10944261,10944262,8569733,8569734,7068759,10944277,8569751,7068792,8569775,8569776,10963485,10963486,10963487,8569782,10933263,10933268,7065831,7065836,7065846,7065860,10933302,7073868,10933310,10933315,10933333,7073903,7073928,10933375,10933419,10933432,10933440,7074041,7074062,7074095,7074147,7074155,7074161,7074167,7074185,7074219,7074220,7074232,7074274,7074298,7074357,7074368,7074402,7074443,7074444,7074446,7074449,7074459,7066461,7074487,7074492,7074522,7074523,7066535,7066539,10437486,7066544,7066551,7066552,7066553,7066573,7066574,7074574,7074648,7074650,7074656,7074664,7074666,7074667,7074681,10437663,7074744,7074745,7074749,7074751,7074753,7066760,7074789,7066791,7066823,7074846,7066847,7066855,7066856,7074899,7074906,10961591,7074909,10961594,10961595,7074912,8067902,7066930,7074940,7066941,7074951,7074964,7074971,7074975,7074979,7066980,7066981,7066983,7066991,7067043,10961727,10961728,7067046,7067055,7075059,7067061,7067063,7067067,10938795,7075086,7075092,7075099,7067106,7075122,10961810,10961811,7067137,7075150,7075152,10961837,7075155,7067173,10961863,7075197,7075244,7067265,7067320,7067330,7067353,7067354,7067356,7067369,7067371,7067372,7067383,7075417,7075423,7067436,7067447,7067463,7067465,7075486,7067492,7067498,7067505,7067512,7067517,7067529,7075534,7075544,7075575,7075581,7075596,7075597,7075599,7075601,7067606,7075606,10962302,7075618,7075623,7067625,7075634,7075638,7075639,10939361,7075648,7075665,7067690,7075749,7075755,10939505,7071853,7071878,7071879,8064971,7071906,7071907,7071908,7071909,7071923,7071925,7071932,10959641,7071985,6000279,6000280,6000281,6000282,7064038,7064045,7064053,7064055,7072063,10931526,7064113,7064117,7064126,7064142,7064179,7064188,7064189,7064191,7072217,7072218,7064219,7064220,7064232,7064235,7064240,7064252,7064261,7072263,10931703,7064276,10931738,10959998,10959999,7072341,7072360,7072381,10931823,10931837,8065480,7072415,7072417,10931865,10931868,7072432,7064434,10931878,10931887,7072480,7072522,7072523,7064534,7064541,7064557,10932030,7064610,10932050,7064611,7064616,10932057,10932059,10932060,7064622,10932063,10932068,7064641,10932100,7064687,10932127,10932140,7064732,10932171,7064734,7072788,7064789,7064795,10932236,10932244,7072810,7064831,7064833,7072849,7072851,7064866,7064885,7072890,7064891,7064896,7064899,7064903,7064919,7064923,7064924,7064934,8066005,10932379,7072942,10932382,7064944,10932383,10932385,7064947,7064955,7064962,7064967,7064990,7064994,7065007,7065018,7065030,7065031,7065040,10932487,7065050,7065052,7065056,7065057,10932511,10932517,7073080,10932521,10932539,7065104,7065109,7073112,10932557,7065125,7065127,7065128,7073128,7065132,7073150,7065151,7065158,7065183,10932623,7065188,7065200,10932648,7065221,7073223,7065239,7065255,7065295,7065296,7065297,10932754,10932755,7065323,7073381,7073406,7073408,7065453,7065460,7073460,7065462,7065481,7065482,7065486,8066558,7073502,7073508,7065518,7073518,7073540,7065546,7065552,7065554,8066649,7073612,7065630,7065646,7065650,7065668,7073673,7073676,10961366,10961367,7073683,7065700,7073701,7065720,10933171,7065742,7065745,7073748,7073756,7073761,10933210,7073774,10933214,7073775,7065780,10933231,10933233,7065795,10933240,7065809,10958621,10942709,7071003,7071021,7071032,7071041,7071146,7071287,7071314,7071318,7071332,7071338,7071431,7071439,7071440,7071456,7071513,10943241,7071563,10943297,7071675,7071699,7071701,7071705,7071710,7071712,7071715,8970220,7071745,7071746,7071748,10931208,7071769,7071777,7071780,7071785,7071787,7071796,10944327,7068826,10944354,10944356,10944357,10944370,10944387,10944441,3655629,10944456,7068947,7068948,7068953,7068989,3655683,3655685,3655686,10944520,3655707,3655733,10944557,10944579,10944580,7069078,3655782,7069098,7069105,7069106,10944643,7069140,7069146,7069151,3655845,7069167,7069169,7069170,7069176,10944763,3655947,7069273,10944796,7069302,10944867,10944870,10944875,10944876,7069409,10944921,10944929,10944932,3656115,7069438,10944970,7069460,10944974,10944980,7069479,10941195,7069496,7069502,7069511,7069512,7069514,7069530,7069531,7069550,10945071,10945083,3656289,7069613,7069616,7069622,7069702,7069740,7069741,7069743,7069759,7069763,7069774,3656485,7069818,7069820,7069829,7069830,3656522,7069832,7069836,7069843,7069859,7069870,7069876,7069895,7069936,7069943,7069947,7069953,7069966,7069980,10957668,10957670,7070034,7070043,3656735,7070065,3656788,7070110,8072966,8072967,8072968,8072969,7070116,8072970,8072971,8072972,8072973,3656842,3656861,3656863,7070213,7070224,7070242,7070245,7070256,3656958,7070271,7070272,7070274,7070275,7070282,7070290,7070299,7070304,7070306,7070309,7070317,7070321,7070343,7070365,7070366,7070371,7070377,7070378,7070411,7070417,7070418,7070420,7070423,7070424,7070430,7070444,7070476,7070478,7070480,7070481,7070520,7070522,7070526,7070530,7070532,7070538,7070541,7070542,7070545,7070551,7070569,7070571,7070574,7070575,7070576,3657268,7070579,7070589,7070590,7070608,7070611,7070612,7070634,7070636,10618013,10618014,10618015,10918594,10918595,10918596,10918597,10918601,10918602,10918717,10618210,10623397,10954967,10954997,10919172,10919173,10919174,10919175,10919465,10919466,10919468,10919469,10919470,10919471,10919472,10619126,10919810,10919811,10919812,10919908,10953713,10617505,10918115,10918469,8569825,8569841,10620097,8570016,8570054,8570087,8570175,10620369,8570224,8570235,8570294,8570296,10921032,10921033,8570400,8570408,8570470,10921197,10921198,10921199,10930528,10930530,10930531,10930533,10930534,10930537,10930551,10930555,10930561,10930581,10930588,10930589,10930624,10921325,10930649,10930654,10930672,10930674,10930675,10930684,10930690,10930696,10930706,10930760,10930779,10930792,10930808,10930811,10930817,10930832,10930833,10930842,10930846,10930849,10930860,10930869,10930894,10930899,10930905,10930914,10930921,10930922,10930939,10930945,10930947,10930953,10930956,10930957,10930985,10930987,10930991,10930998,10931001,10931002,10931014,10931018,10931019,10921866,10921867,10921868,10953146,8863842,8863995,8864008,8864040,8864048,8864118,8864142,8864152,8864180,8864202,8864223,8864268,8864274,8864374,8864376,8864382,8864497,8864505,8864526,8864539,8864569,8864572,8864579,8864601,8864606,8864609,8864616,8864624,8864625,8864630,8864642,8864643,8864650,8864679,8864685,8864708,8864720,8864789,8864790,8864791,8864810,8861838,8861843,8861873,8862027,8862056,8862058,8862059,8862065,8862091,8862111,8862119,8862192,8862200,8862207,8862208,8862209,8862223,8862235,8862268,8862269,8862274,8862276,8862279,8862286,8862297,8862311,8862316,8862371,8862401,8862417,10612558,8862426,8862434,8862500,8862587,8862599,8862603,8862642,8862649,8862650,8862656,8862659,8862732,10609943,8862886,8862908,8862916,8862934,8862936,8862988,8863074,8863220,8863252,8863296,8863379,8863405,8863420,8863422,8863426,8863429,8863431,8863452,8863484,8863539,10610683,8863560,8863565,8863577,8863624,8863641,8863645,8863681,8863685,8863691,8863704,8863705,8863715,8863772,8863785,8863792,4974184,4974604,10513759,4975169,4975170,4975171,2809223,2809350,8861557,8861558,8861559,8861601,8861608,10516902,8861619,8861663,8861679,8861710,8861712,8861714,8861753,8861770,8861802,10417160,10467062,4971372,8563234,8563238,8563254,8563279,8563296,8563299,4972335,8563403,8563408,8563424,8563428,10470135,8563517,8563545,8563570,8563572,8563574,8563583,8563598,10470309,10470444,10470446,4972760,10470571,10470573) 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'