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(7068009,10943429,10943430,7076017,10943439,7068023,7068025,10943449,10943456,7068047,7068049,7068051,7068060,7068076,7068093,7076093,7068094,7076096,7068096,7068097,10943521,7076117,10943536,10943547,10943555,7068145,10943567,10943578,10943581,10943587,10943598,7076183,7068183,10943631,10943640,7076227,7076232,10943682,10943714,7068299,7068308,10943731,10943742,7068324,7068339,10943795,10943801,10943802,7068383,7068386,4970607,4970608,4970609,4970610,4970611,7068400,7068402,7068406,7068414,10943851,8569451,7068492,7068493,7068495,8569484,7068519,10943955,10944009,10944023,10944027,10944040,10944056,10944062,8569621,7068648,10944082,7068664,8569653,10963385,10944123,4970929,10940338,8569692,4970949,10944168,10944171,8569733,8569734,7068759,10944192,8569751,7068792,8569775,8569776,10963485,10963486,10963487,8569782,10944244,7068826,10944245,10944261,10944262,8569825,10944277,8569841,10944327,10944354,10933302,10933310,10933315,10933333,10933375,7074041,7074062,10933419,10933432,10933440,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,7066544,7066551,7066552,7066553,7066573,7074574,7066574,10437486,7074648,7074650,7074656,7074664,7074666,7074667,7074681,7074744,7074745,7074749,7074751,7074753,7066760,7074789,7066791,10437663,7066823,7074846,7066847,7066855,7066856,10964545,7074899,7074906,7074909,7074912,7066930,7074940,7066941,7074951,7074964,7074971,7074975,7074979,7066980,7066981,7066983,7066991,8067902,7067043,10961727,10961728,7067046,7067055,7075059,7067061,7067063,7067067,7075086,7075092,7075099,7067106,7075122,10961810,10961811,7067137,7075150,7075152,10961837,7075155,10938795,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,7075606,7067606,10962302,7075618,7075623,7067625,7075634,7075638,7075639,7075648,7075665,7067690,10939361,7075749,7075755,7075818,7067819,7075849,7067851,7075870,7067877,7067881,10939505,7075883,7075885,7067893,7067895,7067897,7067901,10939543,7075923,7067934,7067935,10959641,7071985,8064971,6000279,6000280,6000281,6000282,7064038,7064045,7064053,7064055,7072063,7064113,7064117,7064126,7064142,10931526,7064179,7064188,7064189,7064191,7072217,7072218,7064219,7064220,7064232,7064235,7064240,7064252,7064261,7072263,7064276,10959998,10959999,7072341,10931703,7072360,7072381,10931738,7072415,7072417,7072432,7064434,10931823,7072480,10931837,8065480,10931865,10931868,7072522,7072523,10931878,7064534,10931887,7064541,7064557,7064610,7064611,7064616,7064622,7064641,10932030,7064687,10932050,10932057,10932059,10932060,10932063,10932068,7064732,7064734,10932100,10932127,7072788,7064789,10932140,7064795,7072810,10932171,7064831,7064833,7072849,7072851,7064866,7064885,10932236,7072890,7064891,7064896,10932244,7064899,7064903,7064919,7064923,7064924,7064934,7072942,7064944,7064947,7064955,7064962,7064967,7064990,7064994,7065007,7065018,8066005,7065030,7065031,10932379,10932382,10932383,10932385,7065040,7065050,7065052,7065056,7065057,7073080,7065104,7065109,7073112,7065125,7065127,7065128,7073128,7065132,10932487,7073150,7065151,7065158,10932511,10932517,10932521,7065183,7065188,10932539,7065200,10932557,7065221,7073223,7065239,7065255,10932623,7065295,7065296,7065297,10932648,7065323,7073381,7073406,10932754,10932755,7073408,7065453,7065460,7073460,7065462,7065481,7065482,7065486,7073502,7073508,7065518,7073518,7073540,7065546,7065552,7065554,8066558,7073612,7065630,7065646,7065650,7065668,8066649,7073673,7073676,10961366,10961367,7073683,7065700,7073701,7065720,7065742,7065745,7073748,7073756,7073761,7073774,7073775,7065780,7065795,7065809,10933171,7065831,7065836,7065846,7065860,10933210,10933214,7073868,10933231,10933233,10933240,7073903,10961591,10961594,10961595,10933263,10933268,7073928,10958621,7071003,7071021,7071032,7071041,10942709,7071146,7071287,7071314,7071318,7071332,7071338,7071431,7071439,7071440,7071456,7071513,7071563,10943241,10943297,7071675,7071699,7071701,7071705,7071710,7071712,7071715,7071745,7071746,7071748,7071769,7071777,7071780,7071785,7071787,7071796,8970220,7071853,10931208,7071878,7071879,7071906,7071907,7071908,7071909,7071923,7071925,7071932,10944356,10944357,7068947,7068948,10944370,7068953,10944387,7068989,10944441,10944456,3655629,7069078,7069098,10944520,7069105,7069106,3655683,3655685,3655686,3655707,10944557,7069140,7069146,7069151,10944579,10944580,3655733,7069167,7069169,7069170,7069176,3655782,10944643,7069273,3655845,7069302,10944763,10944796,3655947,7069409,7069438,10944867,10944870,10944875,10944876,7069460,7069479,7069496,10944921,7069502,10944929,7069511,7069512,10944932,7069514,7069530,7069531,3656115,7069550,10944970,10944974,10944980,10941195,7069613,7069616,7069622,10945071,10945083,7069702,3656289,7069740,7069741,7069743,7069759,7069763,7069774,7069818,7069820,7069829,7069830,7069832,7069836,7069843,7069859,7069870,7069876,7069895,3656485,7069936,7069943,7069947,3656522,7069953,7069966,7069980,10957668,10957670,7070034,7070043,7070065,7070110,7070116,3656735,7070213,3656788,7070224,8072966,8072967,8072968,8072969,8072970,8072971,8072972,8072973,7070242,7070245,7070256,7070271,3656842,7070272,7070274,7070275,7070282,7070290,3656861,3656863,7070299,7070304,7070306,7070309,7070317,7070321,7070343,7070365,7070366,7070371,7070377,7070378,3656958,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,7070579,7070589,7070590,7070608,7070611,7070612,7070634,7070636,3657268,10618013,10618014,10618015,10918594,10918595,10918596,10918597,10918601,10918602,10918717,10618210,10954967,10954997,10623397,10919172,10919173,10919174,10919175,10919465,10919466,10919468,10919469,10919470,10919471,10919472,10619126,10919810,10919811,10919812,10919908,10953713,10617505,10918115,10918469,8570016,10620097,8570054,8570087,8570175,8570224,8570235,8570294,8570296,10620369,8570400,8570408,8570470,10921032,10921033,10930528,10930530,10930531,10930533,10930534,10930537,10930551,10930555,10930561,10930581,10930588,10930589,10921197,10921198,10921199,10930624,10930649,10930654,10930672,10930674,10930675,10930684,10930690,10930696,10930706,10921325,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,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'