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(4970339,4970340,4970341,4970342,4970376,4970405,4970406,4970407,4970408,4970429,4970430,4970431,4970432,4970433,4970434,4970435,4970436,4970437,4970438,4970439,4970440,4970441,4970442,4970443,4970444,4970445,4970446,4970447,4970448,4970449,4970450,4970646,4970647,4970648,4970649,4970650,4970667,4970668,4970672,4970681,4970683,4970687,4970688,4970730,4970731,4970732,4970733,4970734,4970735,4970747,4970753,4970768,4970771,4970772,4970817,4970818,4970875,4970876,4970877,4970886,4970887,4970888,4970889,4970910,4970916,4970954,4970964,4970968,4970973,4971030,4971061,4971062,4971072,4971090,4971094,4971121,4968517,4968687,4968692,4968693,4968694,4968695,4968696,4968697,4968801,4968848,4969009,4969108,4969163,4969164,4969165,4969166,4969167,4969172,4969173,4969174,4969360,4969361,4969362,4969363,8075064,8075065,8075066,8075067,8075068,8075111,8075112,8075113,8075114,8075115,8075155,8075156,8075157,8075158,8075159,8075197,8075198,8075199,8075200,8075201,8075251,8075252,4967029,4967342,4967396,4967510,4967767,4967782,4967785,4967786,4967869,4967870,4967871,4967872,4967883,4967884,4967992,4968024,4968039,4968040,4968041,4968042,4968079,4968080,8073974,8073975,8073976,8073977,8073978,8074020,8074021,8074022,8074023,8074024,8074150,8074151,8074152,8074153,8074154,8074195,8074196,8074197,8074198,8074199,8074336,8074337,8074338,8074339,8074340,8074388,8074389,8074390,8074391,8074392,8072293,8072294,8072295,8072296,8072297,8072312,8072521,8072522,8072523,8072524,8072525,8072526,8072527,8072528,8072529,8072530,8072531,8072532,8072782,8072885,8072886,8072887,8072888,8072889,8072890,8072891,8072892,8072893,8072894,8072895,8072896,8072897,8072898,8072899,8072900,8072942,8072949,8072996,8073465,8073466,8073501,8073523,8073524,8073542,10622972,10623039,10623168,10623169,10623189,10623190,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623307,10623352,10623377,10623378,10623379,10623380,10623381,10623382,10623383,10623384,10623385,10623446,10623465,10623466,10623467,10623468,10623469,10623493,10623500,10623609,10623610,10623611,10623612,10623613,10623614,10623615,10623616,10623617,10623618,10623619,10623620,10623788,10623924,10623959,10624438,10624439,10624440,10624441,10624442,10624443,10624444,10624445,10624446,10624447,10624448,10624449,10624450,10624451,10624452,10624551,10624581,10624714,10624762,10624763,10624764,10624765,10624766,10624767,10624768,10624876,10624877,10624878,10624879,10624953,10621977,10621978,10621984,10621986,10621988,10621993,10621994,10621995,10622005,10622007,10622015,10622024,10622025,10622026,10622027,10622028,10622029,10622030,10622031,10622032,10622033,10622040,10622042,10622043,10622053,10622054,10622056,10622057,10622061,10622062,10622065,10622067,10622068,10622069,10622072,10622073,10622077,10622078,10622079,10622080,10622081,10622082,10622083,10622084,10622085,10622086,10622087,10622088,10622090,10622095,10622096,10622097,10622098,10622099,10622100,10622101,10622102,10622103,10622104,10622111,10622112,10622115,10622121,10622122,10622123,10622124,10622132,10622301,10622302,10622343,10622370,10622396,10622402,10622414,10622438,10622446,10622472,10622487,10622518,10622519,10622520,10622521,10622536,10622686,10622687,10622688,10622689,10622690,10622691,10622692,10622693,10622752,10622772,10622896,10622919,10620165,10620176,10620177,10620178,10620179,10620185,10620224,10620267,10620297,10620298,10620302,10620306,10620308,10620321,10620322,10620323,10620324,10620325,10620326,10620328,10620342,10620344,10620345,10620347,10620349,10620358,10620359,10620373,10620376,10620378,10620381,10620394,10620403,10620407,10620408,10620409,10620410,10620416,10620417,10620419,10620420,10620421,10620422,10620423,10620517,10620549,10620550,10620551,10620552,10620553,10620554,10620555,10620556,10620557,10620558,10620653,10620710,10620744,10620745,10620746,10620747,10620748,10620749,10620750,10620751,10620752,10620753,10620754,10620755,10620756,10620757,10620758,10620759,10620760,10620761,10620762,10620763,10620764,10620765,10620766,10620767,10620768,10620769,10620770,10620771,10620772,10620773,10620774,10620775,10620776,10620777,10620778,10620779,10620780,10620781,10620782,10620783,10620784,10620785,10620786,10620787,10620788,10620789,10620790,10620791,10620792,10620793,10620794,10620795,10620796,10620797,10621043,10621044,10621051,10621052,10621123,10621136,10621143,10621149,10621152,10621154,10621156,10621157,10621158,10621159,10621162,10621244,10621245,10621246,10621263,10621267,10621298,10621299,10621302,10621337,10621338,10621339,10621344,10621386,10621387,10621388,10621420,10621425,10621427,10621452,10621458,10621459,10621462,10621477,10621478,10621489,10621490,10621499,10621518,10621526,10621527,10621528,10621570,10621576,10621577,10621578,10621579,10621580,10621585,10621633,10621635,10621638,10621643,10621648,10621663,10621664,10621665,10621670,10621681,10621682,10621686,10621687,10621691,10621697,10621700,10621701,10621702,10621703,10621712,10621730,10621734,10621738,10621739,10621740,10621745,10621748,10621750,10621752,10621753,10621754,10621954,10621955,10621956,10565134,10565139,10565142,10565152,10565155,10565177,10565178,10565179,10565180,10565182,10565197,10565302,10565700,10566080,10566081,10566082,10563172,10563227,10563282,10563283,10563342,10563343,10563357,10563358,10563359,10563360,10563361,10563362,10563363,10563364,10563365,10563448,10563559,10563560,10563561,10563562,10563563,10563666,10563683,10563684,10563814,10563833,10563992,10564027,10564460,10564461,10564462,10564507,10564508,10564509,10564510,10564511,10564512,10564513,10564514,10564515,10564516,10564517,10564518,10564519,10564520,10564521,10564522,10564523,10564524,10564525,10564526,10564527,10564528,10564529,10564530,10564531,10564532,10564533,10564534,10564535,10564536,10564537,10564538,10564539,10564540,10564541,10564542,10564543,10564544,10564545,10564546,10564547,10564548,10564549,10564550,10564551,10564552,10564553,10564554,10564555,10564556,10564557,10564558,10564559,10564560,10564561,10564562,10564563,10564564,10564565,10564566,10564567,10564568,10564569,10564570,10564571,10564572,10564573,10564574,10564575,10564576,10564577,10564578,10564579,10564580,10564581,10564582,10564583,10564584,10564585,10564586,10564587,10564588,10564589,10564590,10564591,10564592,10564593,10564594,10564595,10564596,10564597,10564598,10564599,10564600,10564601,10564602,10564603,10564604,10564605,10564606,10564607,10564608,10564845,10564846,10564894,10564914,10564966,10565000,10517452,10517454,10517456,10517458,10517459,10517460,10517461,10517462,10517494,10517501,10517552,10517553,10517554,10517555,10517563,10517613,10517622,10517813,10517865,10517984,10518552,10518648,10518649,10518650,10518651,10518652,10518653,10518654,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,10518664,10518665,10518666,10518667,10518668,10518669,10518670,10518671,10518672,10518673,10518674,10518675,10518676,10518677,10518678,10518679,10518680,10518681,10518682,10518683,10518684,10518685,10518686,10518687,10518688,10518689,10518690,10518691,10518692,10518693,10518694,10518695,10518696,10518697,10518698,10518699,10518700,10518701,10518702,10518703,10518704,10518705,10518706,10518707,10518708,10518732,10518748,10519079,10519081,10419301,10419481,10419589,10419646,10419647,10419648,10419649,10419650,10419723,10419737,10419740,10419840,10419907,10419973,10420012,10420150,10420151,10420152,10420153,10420154,10420155,10420156,10420157,10420158,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10420167,10420168,10420169,10420170,10420171,10420172,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420200,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10470886,10470929,10470933,10470934,10470935,10470936,10470972,10471036,10471082,10471134,10471135,10471201,10471202,10471213,10471216,10471237,10471238,10471260,10471274,10471425,10471426,10471551,10469955,10470023,10470024,10470044,10470133,10470151,10470152,10470153,10470154,10470155,10470156,10470157,10470158,10470159,10470160,10470161,10470162,10470163,10470164,10470165,10470166,10470167,10470168,10470169,10470170,10470171,10470172,10470173,10470174,10470175,10470176,10470177,10470178,10470179,10470180,10470181,10470182,10470183,10470184,10470185,10470186,10470187,10470188,10470189,10470190,10470191,10470192,10470193,10470194,10470195,10470196,10470197,10470198,10470199,10470200,10470201,10470254,10470255,10470274,10470291,10470292,10470293,10470329,10470330,10470331,10470363,10470364,10470408) 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'