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(4970157,4970158,4970159,4970161,4970162,4970167,4970168,4970174,4970175,4970177,4970178,4970179,4970180,4970181,4970182,4970183,4970188,4970193,4970194,4970195,4970196,4970197,4970198,4970200,4970204,4970207,4970211,4970212,4970217,4970218,4970219,4970220,4970221,4970222,4970223,4970224,4970225,4970226,4970227,4970228,4970229,4970230,4970233,4970241,4970242,4970245,4970246,4970247,4970250,4970252,4970255,4970260,4970261,4970262,4970264,4970268,4970269,4970270,4970275,4970283,4970292,4970302,4970303,4970304,4970310,4970311,4970314,4970318,4970319,4970320,4970322,4970324,4970330,4970343,4970344,4970345,4970346,4970347,4970354,4970355,4970358,4970361,4970362,4970363,4970366,4970367,4970368,4970371,4970375,4970376,4970377,4970379,4970382,4970388,4970390,4970392,4970393,4970394,4970395,4970396,4970397,4970400,4970401,4970402,4970407,4970408,4970409,4970414,4970415,4970418,4970424,4970425,4970429,4970430,4970438,4970441,4970443,4970444,4970445,4970447,4970448,4970449,4970450,4970451,4970452,4970453,4970454,4970455,4970456,4970457,4970458,4970459,4970460,4970461,4970462,4970463,4970464,4970465,4970466,4970467,4970468,4970469,4970470,4970471,4970472,4970473,4970474,4970475,4970476,4970477,4970478,4970479,4970480,4970481,4970482,4970483,4970484,4970485,4970486,4970487,4970488,4970489,4970490,4970491,4970492,4970493,4970494,4970495,4970496,4970497,4970498,4970499,4970500,4970501,4970502,4970503,4970504,4970505,4970506,4970507,4970508,4970509,4970510,4970511,4970512,4970513,4970514,4970515,4970516,4970517,4970518,4970519,4970520,4970521,4970522,4970523,4970524,4970525,4970526,4970527,4970528,4970529,4970530,4970531,4970532,4970533,4970534,4970535,4970536,4970537,4970538,4970539,4970540,4970541,4970542,4970543,4970544,4970545,4970546,4970547,4970548,4970549,4970550,4970551,4970552,4970553,4970554,4970555,4970556,4970557,4970558,4970559,4970560,4970561,4970562,4970563,4970564,4970565,4970566,4970567,4970568,4970569,4970570,4970574,4970576,4970581,4970582,4970584,4970585,4970590,4970595,4970596,4970597,4970599,4970600,4970601,4970602,4970603,4970604,4970605,4970607,4970608,4970609,4970612,4970613,4970614,4970616,4970617,4970618,4970619,4970621,4970623,4970624,4970625,4970626,4970627,4970628,4970629,4970630,4970631,4970634,4970637,4970638,4970656,4970669,4970672,4970714,4970715,4970716,4970738,4970740,4970755,4970756,4970763,4970765,4970766,4970770,4970778,4970784,4970852,4970862,4970864,4970869,4970870,4970873,4970881,4970882,4970884,4970885,4970886,4970889,4970890,4970892,4970895,4970896,4970899,4970900,4970903,4970904,4970905,4970906,4970910,4970911,4970912,4970914,4970915,4970917,4970918,4970919,4970921,4970922,4970924,4970925,4970926,4970927,4970928,4970930,4970931,4970932,4970933,4970934,4970935,4970940,4970944,4970946,4970948,4970949,4970950,4970952,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970964,4970965,4970966,4970967,4970968,4970969,4970973,4970975,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4970995,4971007,4971008,4971010,4971011,4971012,4971017,4971018,4971024,4971025,4971026,4971027,4971028,4971034,4971035,4971036,4971070,4971109,4971119,4971128,4971129,4971130,4971131,4971132,4971133,4971134,4971135,4968168,4968169,4968170,4968175,4968184,4968211,4968214,4968215,4968216,4968217,4968229,4968260,4968268,4968269,4968270,4968327,4968329,4968336,4968339,4968340,4968441,4968469,4968471,4968481,4968503,4968510,4968526,4968527,4968529,4968532,4968533,4968535,4968536,4968537,4968538,4968539,4968546,4968563,4968579,4968581,4968582,4968587,4968593,4968595,4968609,4968620,4968624,4968670,4968681,4968682,4968685,4968692,4968716,4968722,4968754,4968764,4968773,4968793,4968800,4968840,4968860,4968897,4968929,4968933,4968945,4968946,4968953,4968958,4968959,4969025,4969039,4969045,4969051,4969052,4969055,4969154,4969160,4969164,4969170,4969175,4969199,4969223,4969229,4969252,4969263,4969264,4969266,4969280,4969281,4969290,4969330,4969331,4969340,4969341,4969357,4969363,4969382,4969418,4969419,4969438,4969440,4969454,4969461,4969469,4969503,4969552,4969553,4969571,4969572,4969576,4969579,4969581,4969582,4969584,4969585,4969588,4969589,4969591,4969592,4969594,4969595,4969596,4969599,4969600,4969606,4969609,4969610,4969615,4969616,4969617,4969618,4969619,4969621,4969626,4969629,4969632,4969633,4969635,4969637,4969638,4969640,4969642,4969643,4969644,4969645,4969646,4969648,4969650,4969654,4969655,4969656,4969657,4969658,4969659,4969660,4969661,4969662,4969665,4969666,4969668,4969673,4969674,4969675,4969676,4969679,4969681,4969682,4969683,4969685,4969686,4969687,4969690,4969691,4969692,4969702,4969703,4969706,4969708,4969710,4969711,4969712,4969713,4969714,4969715,4969716,4969717,4969720,4969721,4969722,4969723,4969724,4969725,4969726,4969727,4969730,4969731,4969732,4969733,4969734,4969736,4969737,4969739,4969741,4969742,4969743,4969744,4969745,4969746,4969747,4969753,4969754,4969755,4969757,4969758,4969759,4969760,4969761,4969766,4969767,4969769,4969770,4969772,4969773,4969776,4969777,4969779,4969780,4969784,4969785,4969790,4969792,4969794,4969795,4969796,4969797,4969800,4969803,4969804,4969806,4969807,4969808,4969809,4969810,4969811,4969812,4969813,4969814,4969816,4969818,4969819,4969820,4969822,4969824,4969825,4969827,4969828,4969829,4969830,4969831,4969832,4969833,4969838,4969839,4969840,4969845,4969846,4969847,4969848,4969849,4969850,4969851,4969852,4969853,4969857,4969861,4969862,4969863,4969868,4969874,4969878,4969879,4969881,4969886,4969888,4969889,4969894,4969895,4969897,4969898,4969902,4969907,4969910,4969915,4969918,4969922,4969923,4969924,4969925,4969926,4969928,4969932,4969934,4969935,4969936,4969940,4969945,4969951,4969953,4969954,4969955,4969957,4969958,4969965,4969966,4969967,4969968,4969970,4969981,4969985,4969990,4969992,4969994,4969995,4969996,4969997,4969999,4970002,4970003,4970007,4970008,4970009,4970011,4970015,4970023,4970026,4970027,4970029,4970030,4970032,4970034,4970035,4970036,4970038,4970039,4970041,4970044,4970045,4970047,4970052,4970059,4970062,4970066,4970068,4970069,4970070,4970080,4970083,4970085,4970086,4970089,4970091,4970094,4970099,4970102,4970108,4970112,4970113,4970121,4970122,4970124,4970125,4970127,4970130,4970131,4970132,4970133,4970134,4970135,4970136,4970138,4970142,4970144,4970145,4970146,4970147,4970148,4970149,4970151,8074897,8074898,8074899,8074900,8074901,8074940,8074941,8074942,8074943,8074944,8074945,8075263,8075288,4967046,4967064,4967094,4967095,4967113,4967130,4967212,4967216,4967228,4967230,4967231,4967232,4967239,4967245,4967246,4967247,4967251,4967270,4967272,4967275,4967283,4967284,4967286,4967287,4967306,4967310,4967312,4967323,4967325,4967326,4967351,4967352,4967383,4967391,4967403,4967483,4967484,4967486,4967517,4967520,4967524,4967525,4967526,4967528,4967529,4967532,4967533,4967548,4967549,4967552,4967557,4967558,4967561,4967563,4967565,4967569,4967570,4967573,4967581,4967582,4967584,4967586,4967589,4967590,4967591,4967593,4967596,4967603,4967604,4967606,4967610,4967613,4967614,4967616,4967619,4967624,4967629,4967631,4967632,4967634,4967636,4967638,4967642,4967645,4967646,4967648,4967649,4967650,4967651,4967652,4967654,4967656,4967657,4967658,4967660,4967662,4967663,4967664,4967666,4967668,4967669,4967670,4967676,4967677,4967678,4967681,4967682,4967683,4967691,4967693,4967695,4967696,4967697,4967698,4967699,4967702,4967706,4967707,4967709,4967710,4967715,4967718,4967721,4967724,4967728,4967729,4967733,4967735,4967741,4967746,4967748,4967749,4967751,4967758,4967759,4967763,4967771,4967772,4967773,4967774,4967775,4967776,4967780,4967781,4967784,4967787,4967789,4967808,4967809,4967816,4967817,4967818,4967827,4967829,4967831,4967832,4967836,4967838,4967839,4967859,4967931,4967932,4967933,4967934,4967935,4967936,4967937,4967938,4967939,4967946,4967958,4967959,4967960,4967961,4967962,4967963,4967964,4967965,4967966,4967981,4968009,4968015,4968033,4968035,4968049,4968058,4968086,4968093,4968118,4968122,4968124,4968125) 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'