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(10962664,10962665,10962666,10963261,10963635,10963636,10963638,10963639,7066564,7066565,7066566,7066567,7066568,7066569,10962071,10962072,10962073,10962074,10962075,10962076,10962077,10962078,10962079,10962080,7067685,7067686,10962452,10960453,10960457,10960458,10960459,10960460,10960461,10960462,10960463,10960464,10932234,10960623,10960625,10960626,10960627,10960629,10960630,10960631,10960632,10960633,10960634,10960635,10960636,10960637,10960638,10960639,10960640,10960641,10960642,10960647,10960648,10960650,10960651,10960652,10960653,10960654,10960655,10960656,10960657,10960658,10960659,10960660,10960661,10960662,10960663,10960664,10960665,10960666,10960667,10960668,10960669,10960670,10960673,10960674,10960677,10960678,10960679,10960680,10960683,10960684,10960685,10960686,10960687,10960688,10960689,10960690,10960691,10960692,10960695,10961087,10961088,10961089,10961093,10961094,7073550,7073552,7073553,10942659,10943126,10943127,10943128,10943129,10943130,10943131,10943132,7071525,7071556,7071557,7071559,5999930,5999947,5999983,5999984,5999985,5999986,5999987,5999988,5999989,5999990,5999991,5999992,5999994,5999995,5999996,5999997,5999998,5999999,6000000,6000001,6000002,6000003,6000004,6000005,6000006,6000007,6000008,6000009,6000010,6000011,6000012,6000013,6000014,6000015,6000016,6000017,6000018,6000019,6000020,6000021,6000022,6000023,6000024,10942186,10942189,10942312,10942536,10967998,10967999,10968005,10968022,10968023,10968025,10968026,10968027,10968028,10968029,10968063,10968064,10968065,10968066,10968067,10968068,10968069,10968070,10968071,10968072,10968073,10968074,10968075,10968076,10968077,10968078,10968079,10968080,10968081,10968082,10968083,10968085,10968086,10968087,10968088,10968089,10968090,10968091,10968092,10968131,10968132,10968133,10968134,10968137,10968138,10968139,10968140,10968141,10968142,10968143,10968144,10968150,10968152,10968153,10968154,10968155,10968156,10968157,10968158,10968159,10968160,10968163,10968164,10966877,10927884,10927885,10927937,10927963,10928013,10928014,10928030,10928061,10928103,10928214,10928239,10928240,10926005,10926006,10965341,10930877,10927258,10927259,10927260,10927261,10927262,10927263,10927264,10927265,10927266,10927267,10927268,10565320,10565321,10565322,10565323,10562399,10562401,10562402,10562407,10562408,10562409,10562410,10562411,10562412,10562413,10562414,10562415,10562416,10562423,10562426,10562427,10562428,10562429,10562430,10562431,10562432,10562433,10562434,10562435,10562436,10562437,10562438,10562439,10562440,10562448,10562449,10562450,10562451,10562452,10562453,10562454,10562455,10562456,10562457,10562458,10562472,10562473,10562474,10562475,10562476,10562477,10562478,10562479,10562480,10562481,10562482,10562483,10562484,10562486,10562487,10562488,10562489,10562491,10562492,10562493,7059852,10562500,10562501,10562502,10562503,10562504,10562505,10562506,10562507,10562508,10562509,10562510,10562511,10562512,10562513,10562514,10562515,10562516,10562517,10562518,10562519,10562520,10562521,10562522,10562523,10562524,10562525,10562526,10562530,10562531,10562532,10562533,10562538,10562550,10562551,10562552,10562553,10562554,10562555,10562556,10562557,10562558,10562559,10562560,10562561,10562562,10562563,10562564,10562565,10562567,10562568,10562569,10562570,10562571,10562572,10562573,10562574,10562575,10562576,10562577,10562578,10562579,10562580,10562581,10562582,10562583,10562584,10562585,10562586,10562587,10562588,10562589,10562590,10562591,10562592,10562593,10562594,10562595,10562598,10562599,10562600,10562601,10562602,10562607,10562608,10562609,10562610,10562611,10562612,10562613,10562620,10562621,10562622,10562623,10562624,10562625,10562626,10562627,10562628,10562629,10562630,10562631,10562632,10562633,10562634,10562635,10562636,10562637,10562638,10562639,10562640,10562641,10562642,10562643,10562644,10562645,10562646,10562647,10559713,10566084,10566094,10566095,10566096,10566097,10566098,10566099,10566100,10566101,10566102,10566103,10566104,10566105,10566106,10566107,10566108,10566109,10566110,10566111,10563546,10563564,7057931,7057932,7057933,10563583,10563584,10563585,10563586,10563587,10563588,10563589,10563590,10563591,10563592,10563593,10563594,10563595,10563596,10563597,10563598,10563599,10563600,10563601,10563602,10563603,10563604,10563605,10563606,10563607,10563608,10563609,10563610,10563611,10563612,10563613,10563614,10563615,10563616,10563617,10557618,10563618,10563619,10563620,10563621,10563622,10563623,10563624,10563625,10563626,10563627,10563628,10563629,10563630,10563631,10563632,10563633,10563634,10563635,10563636,10563637,10563638,10563639,10563640,10563641,10563642,10563643,10563644,10563645,10563646,10563647,10563648,10563649,10563650,10563651,10563652,10563653,10563654,10563655,10563656,10563657,10563658,10563659,10563660,10563661,10563662,10563663,10563664,10563665,10563667,10563668,10563669,10563670,10563671,10563672,10563673,10563674,10563675,10563676,10563677,10563678,10563679,10563680,10563681,10563682,10563683,10563684,10563685,10563686,10563687,10563688,10563689,10563690,10563691,10563692,10557719,10557720,7058275,10564444,10564445,10564446,10564447,10564448,10564449,10564450,10564451,10564452,10564453,10561598,10561599,10561600,10561601,10561602,10561603,10561604,10561605,10561606,10561607,10561608,10561609,10561610,10561611,10561612,10561613,10561614,10561615,10561616,10561617,10561618,10561619,10561620,10561621,10561622,10561623,10561624,10561625,10561626,10561627,10561628,10561629,10561630,10561631,10561632,10561633,10561634,10561635,10561636,10561637,10561638,10561639,10561640,10561641,10561642,10561643,10561646,10561647,10561648,10561649,10561650,10561651,10561652,10561653,10561654,10561655,10561656,10561657,10561658,10561659,10561660,10561661,10561662,10561663,10561664,10561665,10561666,10561667,10561668,10561669,10561670,10561671,10561672,10561673,10561674,10561675,10561676,10561677,10561678,10561679,10561680,10561681,10561682,10561683,10561684,10561685,10561686,10561687,10561688,10561689,10561690,10561691,10561692,10561693,10561694,10561695,10561696,10561697,10561698,10561699,10561700,10561701,10561702,10561703,10561704,10561705,10561706,10561707,10561708,10561709,10561710,10561711,10561712,10561713,10561714,10561715,10561716,10561717,10561718,10561719,10561720,10561721,10561722,10561723,10561724,10561725,10561726,10561727,10561728,10561729,10561730,10561731,10561732,10561733,10561734,10561735,10561736,10561737,10561738,10561739,10561740,10561741,10561742,10561743,10561744,10561745,10561746,10515133,10513233,10513237,10513238,10513239,10513240,10513241,10513242,10513243,10513244,10515459,10515460,10515461,10515462,10515463,10515464,10515465,10515466,10515467,10515468,10515469,10515470,10515471,10515472,10515473,10515474,10515475,10515476,10515477,10515478,10515479,10515480,10515481,10515482,10515483,10515484,10515485,10515486,10515487,10515488,10515489,10515490,10517545,10513576,10513577,10513578,10513579,10513580,10513581,10513582,10513583,10513584,10513585,10513586,10513587,10513588,10513589,10513590,10513591,10513592,10513593,10513599,10513600,10513601,10513602,10513603,10513604,10513605,10513606,10513607,10513608,10513609,10513610,10513611,10513612,10513613,10513614,10513615,10513616,10513617,10513618,10516068,4975294,8918211,8918328,8918329,4973903,8916811,8916812,8916813,8916814,8917569,8917570,8917640,10628429,10628492,10628493,10628494,10628495,10628496,10628497,10628498,10628499,10628500,10628501,10628502,10628503,10628504,10628505,10628506,10628507,10628508,10628509,10628548,10628549,10628551,10628552,10628555,10628556,10628557,10628558,10628559,10628560,10628561,10628562,10628566,10628567,10628568,10628569,10628570,10628571,10628572,10628573,10628574,10628575,10628576,10628577,10628578,10628579,10628941,10627303,10631842,10631884,10568533,10568534,10568536,10568537,10568538,10568539,10568540,10568541,10568542,10568543,10568544,10568545,10568546,10568547,10566112,10566113,10566114,10566115,10566116,10566117,10566118,10566119,10566120,10566121,10566122,10566198,10566199,10566200,10566201,10566202,10566203,10566204,10566205,10566206,10566207,10566208,10566209,10566210,10566211,10566212,10566213,10566214,10566215,10566216,10566217,10566218,10566219,10566220,10566221,10566222,10566223,10566224,10566225,10566226,10566227,10566228,10566229,10566230,10566231,10566232,10566233,10566234,10566235,10566236,10566237,10566238,10566239,10566240,10566241,10566242,10566243,10566244,10566245,10566246,10566247,10566248,10566249,10566250,10566251,10566252,10566253,10566254,10566255,10566256,10566257,10566258,10566259,10566260,10566261,10566262,10566263,10566264,10566265,10566266,10566267,10566268,10566269,10566270,10566271,10567347,10567385,10567386,10567387,10567639,10567640,10567641,10567642,10567644,10567645,10567646,10567651,10567652,10567653,10567657,10567658,10567659,10522545,10522546,10522547,10522548,10522549,10522550,10522551,10522682,10522683,10522684,10522685) 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'