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(10415221,10415222,10415223,10415224,10415225,10415226,10415227,10415228,10415229,10415230,10415231,10415232,10415233,10415234,10415235,10415236,10415237,10415238,10415239,10415240,10415241,10415242,10415243,10415244,10415245,10415246,10415247,10415248,10415249,10415250,10415251,10415252,10415253,10415254,10415255,10415256,10415257,10415258,10415259,10415260,10415261,10415262,10415263,10415264,10415265,10415266,10415267,10415268,10415269,10415270,10415271,10415272,10415273,10415274,10415275,10415276,10415277,10508169,10415278,10415279,10415280,10415281,10415282,10415283,10415284,10415285,10415286,10415287,10415288,10415289,10415290,10415291,10415292,10415293,10415294,10415295,10415296,10415297,10415298,10415299,10415300,10415301,10415302,10415303,10415304,10415305,10415306,10415307,10415308,10415309,10415310,10508201,10508202,10508203,10508204,10508205,10508210,10508211,10508212,10508213,10508214,10508215,10508216,10508232,10508233,10508234,10508235,10508236,10508237,10508238,10508239,10508240,10508248,10508249,10508250,10508251,10508252,10508253,10508254,10508255,10424409,10424419,10424430,10424435,10508336,10508337,10508338,10508339,10508346,10508373,10508374,10508375,10508414,10415545,10415550,10415551,10415554,10415555,10415556,10415558,10415560,10415562,10415565,10415568,10415571,10415572,10415577,10508480,10508481,10508482,10415610,10508504,10508505,10508506,10508507,10508508,10508509,10508510,10508511,10508512,10508513,10508514,10508515,10508516,10508517,10508518,10508519,10508520,10505529,10415675,10415676,10415677,10415678,10415680,10506596,10506597,10506598,10506599,10506600,10506601,10506602,10508603,10508612,10508613,10508614,10508615,10507619,10507620,10507621,10507687,10507688,10507689,10507690,10507691,10507692,10507693,10507694,10507695,10507696,10507697,10507698,10507699,10507700,10507701,10507702,10507703,10507704,10507705,10507706,10507757,10507758,10506786,10507805,10507816,10423926,10507817,10507818,10423927,10423928,10507819,10423929,10507820,10423930,10507821,10423931,10507822,10507823,10507824,10507877,10507878,10507879,10507880,10507881,10507882,10507883,10507884,10507885,10507886,10507890,10507891,10507892,10507893,10507894,10507895,10507896,10507897,10507898,10507899,10507900,10507901,10507902,10507903,10507920,10507921,10507927,10507938,10416065,10416066,10416067,10416068,10416069,10416070,10416071,10416072,10416073,10416074,10416075,10416076,10416077,10416078,10416079,10416080,10416081,10416082,10416083,10416084,10416085,10416086,10416087,10416088,10416089,10416090,10416091,10416092,10416093,10416094,10507986,10416095,10416096,10416097,10416098,10507990,10416099,10416100,10507991,10416101,10416102,10416103,10416104,10416105,10416106,10416107,10416108,10416109,10416110,10416111,10416112,10416113,10416114,10416115,10416116,10416117,10508009,10416118,10508010,10416119,10508011,10416120,10416121,10508013,10416122,10416123,10416124,10416125,10416126,10416127,10416128,10416129,10416130,10416131,10416132,10416133,10416134,10416135,10508027,10416136,10416137,10416138,10416139,10416140,10416141,10416142,10416143,10416144,10416145,10416146,10416147,10416148,10416149,10416150,10508041,10416151,10416152,10416153,10416154,10416155,10416156,10416157,10416158,10416159,10416160,10416161,10416162,10416163,10416164,10416165,10416166,10416167,10416168,10416169,10416170,10416171,10416172,10416173,10416174,10416175,10416176,10416177,10416178,10416179,10416180,10416181,10411245,10411246,10411247,10411315,10411318,10411321,10411322,10411325,10409349,10407370,10411407,10411408,10411409,10411410,10411411,10411412,10411413,10411414,10411415,10411416,10411417,10411418,10411419,10411420,10411421,10411422,10411423,10411424,10411425,10411426,10411427,10411428,10411429,10411430,10411431,10411432,10411433,10411434,10411435,10411436,10411437,10411438,10411439,10411440,10411441,10411442,10411443,10411444,10411445,10411446,10411447,10411448,10411449,10411450,10411451,10411452,10411453,10411454,10411455,10411456,10411457,10411458,10411459,10411460,10411461,10409462,10411462,10411463,10411464,10409465,10411465,10409466,10411466,10409467,10411467,10409468,10411468,10411469,10411470,10411471,10411472,10411473,10411474,10411475,10411476,10411477,10411478,10411479,10411480,10411481,10411482,10411483,10411484,10411485,10411486,10411487,10411488,10411489,10411490,10411491,10411492,10411493,10411494,10411495,10411496,10411497,10411498,10411499,10411500,10411501,10411502,10411503,10411504,10411505,10411506,10411507,10411508,10411509,10411510,10411511,10411512,10411513,10411514,10411515,10411516,10411517,10411518,10411519,10411520,10411521,10411522,10411523,10411524,10411525,10411561,10411562,10411564,10407601,10407602,10488267,10488268,10488269,10488270,10488271,10488272,10488273,10488274,10488275,10409644,10409654,10409655,10411698,10409757,10411761,10411769,10411773,10411779,10411786,10411787,10411793,10411794,10411811,10411813,10407917,10407918,10407919,10411951,10411956,10410021,10410024,10410025,10410026,10412046,10408059,10408063,10408066,10412236,10412237,10412238,10412239,10412240,10412241,10412242,10412243,10412244,10412245,10412246,10412247,10412248,10412249,10412250,10412251,10410263,10412263,10410264,10412264,10412267,10412268,10412269,10410270,10412270,10412271,10410273,10410277,10412500,10412501,10412502,10412503,10412504,10412505,10412506,10412507,10412508,10412509,10412510,10412511,10412512,10412513,10412514,10412515,10412516,10412517,10412518,10412519,10412520,10412521,10412522,10412523,10412524,10412525,10412526,10412527,10412528,10412529,10412530,10412531,10412532,10412533,10412534,10412535,10412536,10412537,10412538,10412539,10412540,10412541,10412542,10412543,10412544,10412545,10412546,10412547,10412548,10412549,10412550,10412551,10412552,10412553,10412554,10412555,10412556,10412557,10412558,10412559,10412560,10412561,10412562,10412563,10412564,10412565,10412566,10412567,10412568,10412569,10412570,10412571,10412572,10412573,10412574,10412575,10412576,10412577,10412578,10412579,10412580,10412581,10412582,10412583,10412584,10412585,10412586,10412587,10412588,10412589,10412590,10412591,10412592,10412593,10412594,10412595,10412596,10412597,10412598,10412599,10412600,10412601,10412602,10412603,10412604,10412605,10412606,10412607,10412608,10412609,10412610,10412611,10412612,10412613,10412614,10412615,10412616,10412617,10412618,10412619,10412620,10412621,10412622,10412623,10412624,10412625,10412626,10412627,10412628,10412629,10412630,10412631,10412632,10412633,10412634,10412635,10412636,10412637,10412638,10412639,10412640,10408640,10412641,10412642,10412643,10412644,10412645,10412646,10412647,10408647,10412648,10408648,10412649,10408649,10412650,10408650,10412651,10412652,10412653,10412654,10408654,10412655,10408655,10412656,10412657,10412658,10412659,10412660,10412661,10412662,10412663,10412664,10412665,10412666,10412667,10412668,10412669,10412670,10412671,10412672,10408672,10412673,10408673,10412674,10408674,10412675,10412676,10412677,10412678,10412679,10412680,10412681,10412682,10412683,10412684,10412685,10412686,10412687,10412688,10412689,10412690,10412691,10412692,10412693,10412694,10412695,10412696,10412697,10412698,10412699,10412700,10412701,10412702,10412703,10412704,10412705,10412706,10412707,10412708,10412709,10412710,10412711,10412712,10412713,10412714,10412715,10412716,10412717,10412718,10412719,10412720,10412721,10412722,10412723,10412724,10412725,10412726,10412727,10412728,10412729,10412730,10412731,10412732,10412733,10412734,10410734,10412735,10412736,10412737,10412738,10412739,10412740,10412741,10412742,10412743,10412744,10412745,10412746,10412747,10412748,10412749,10412750,10412751,10412752,10412753,10412754,10412755,10412756,10410756,10412757,10410757,10412758,10410758,10412759,10410759,10412760,10410760,10412761,10412762,10412763,10412764,10410764,10412765,10410765,10412766,10410766,10412767,10410767,10412768,10412769,10412770,10412771,10410771,10412772,10412773,10412774,10412775,10412776,10412777,10412778,10412779,10412780,10412781,10412782,10412783,10412784,10412785,10412786,10412787,10412788,10412789,10412790,10412791,10412792,10412793,10412794,10412795,10412796,10412797,10412798,10412799,10412800,10412801,10412802,10412803,10412804,10412805,10412806,10412807,10412808,10412809,10412810,10412811,10412812,10412813,10412814,10412815,10412816,10412817,10412818,10412819,10412820,10412821,10412822,10412823,10412824,10412825,10412826,10412827,10412828,10408828,10412829,10412830,10412831,10412832,10412833,10412834,10412835,10412836,10412837,10412838,10412839,10412840,10412841,10412842,10412843,10412844,10412845,10412846,10412847,10412848,10412849,10412850,10412851,10412852,10412853,10412854,10412855,10412856,10412857,10412858,10412859,10412860,10412861,10412862,10412863,10412864,10412865,10412866,10412867,10406959,10406964,10408966,10408967,10408968,10408969,10408970,10408973,10411029,10411030,10411031,10411032,10411033,10411034,10407050,10409068,10407080,10407081,10409085,10409089,10409093,10407097,10407124,10407133) 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'