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(10939642,10939643,10939723,10939724,10939747,10939810,10939917,7068613,7068614,7068617,7068618,7068619,7068620,7068621,7068622,7068623,7068626,7068627,7068628,7068629,7068630,7068631,7068632,7068633,7068634,7068636,7068637,7068638,7068639,7068645,7068647,7068648,7068656,7068657,7068660,7068671,7068673,7068675,10940331,10940340,7068796,7068799,7068924,8066948,8066949,8066962,8066968,7066275,8067260,8067261,7066343,7066666,7066667,7066671,7066722,7066726,7066727,7066728,7066733,7066744,8067786,8067793,8067794,8067795,8067796,8067797,8067798,8067799,8067800,7066866,7066867,7066888,7066939,7067195,7067268,7067541,7067542,7067544,7067545,7067552,7067553,7067554,7067555,8068478,8068487,10939412,7067843,10931817,10932195,10932196,10932197,10932198,10932199,10932226,10932229,8065988,8066205,8066442,8066443,8066444,8066445,8066446,8066483,10943130,10943139,10943156,10943167,10943168,11049476,11049477,10943233,10943235,10943236,10943244,10943245,10943246,10943247,8064652,10943374,10943377,10943380,10943391,10943393,10940708,10940717,10940718,10940723,10940726,10940748,10941401,3656623,3656640,3656641,3656642,3656643,3656703,3656704,10941835,10941836,10941849,3656882,10941948,10942032,10942194,11048718,10928583,10928586,10928587,10621984,10621986,10927534,10622024,10927535,10622025,10622026,10927536,10927537,10622027,10622028,10927538,10927539,10622029,10927540,10622030,10927541,10622031,10927542,10622032,10927543,10622033,10927544,10927545,10622067,10622068,10622069,10927579,10927580,10927581,10927582,10927583,10927584,10927585,10927586,10622077,10927587,10927588,10622078,10927589,10622079,10927590,10622080,10927591,10927592,10622083,10927593,10927594,10927595,10927596,10927597,10927598,10927599,10622090,10927600,10927601,10927602,10927603,10927604,10927605,10927607,10927612,10927613,10927614,10927615,10927618,10927619,10927620,10927621,10927622,10927624,10927625,10927626,10927627,10927628,10927629,10927630,10622121,10927632,10927633,10927637,10927638,10927639,10927641,10927642,10927643,10927644,10927645,10927646,10927648,10927649,10927650,10927651,10927652,10927653,10927656,10927658,10927659,10927663,10927664,10927665,10927666,10927667,10927668,10927672,10927673,10927674,10927675,10927676,10927677,10927678,10927679,10927680,10927681,10927682,10927683,10927684,10927685,10927686,10927687,10927688,10927689,10927690,10927691,10927692,10927693,10927696,10927697,10927698,10927699,10927700,10927701,10927702,10927721,10927729,10927730,10927731,10927732,10927733,10927736,10927737,10927742,10927743,10927744,10927745,10927746,10927747,10927748,10927749,10927750,10927751,10927752,10927753,10927754,10927755,10927756,10927757,10927758,10927759,10927760,10927761,10927762,10927763,10927764,10927765,10927766,10927767,10927768,10927769,10927770,10927771,10927772,10927773,10927774,10927775,10927776,10927777,10927778,10927779,10927780,10927781,10927782,10927783,10927784,10927785,10927786,10927787,10927788,10927789,10927790,10927791,10927792,10927793,10927794,10927795,10927796,10927797,10927798,10927799,10927800,10927801,10927802,10927807,10927808,10927809,10927810,10927811,10927812,10927817,10927818,10927819,10927820,10927821,10927822,10927823,10927824,10927825,10927827,10927828,10927829,10927830,10927831,10927832,10927833,10927834,10927838,10927839,10927841,10927842,10927843,10927844,10927845,10927846,10927847,10927848,10927849,10927850,10927851,10927852,10927853,10927854,10927855,10927856,10622361,10622362,10622378,10622665,10622666,10622719,10622731,10622732,10622733,10622815,10622816,10622817,10622895,10926111,10926112,10926113,10926114,10926115,10926116,10926117,10926118,10926119,10926146,10926359,10926360,10926361,10926362,10926363,10926364,10926365,10926366,10926367,10926368,10926369,10926370,10926371,10926372,10926373,10926374,10926375,10926376,10926377,10926378,10926379,10926380,10926381,10926382,10926383,10926384,10926385,10926386,10926387,10926388,10926389,10926390,10926391,10926392,10926393,10926394,10926395,10926396,10926397,10926398,10926399,10926400,10926401,10926402,10926403,10926404,10926405,10926406,10926407,10926408,10926409,10926411,10926412,10926413,10926414,10926415,10926416,10926417,10926428,10926429,10926430,10926431,10926432,10926433,10926434,10926435,10926436,10926437,10926438,10926439,10926440,10926441,10926442,10926443,10926444,10926445,10926447,10926448,10926449,10926450,10926451,10926452,10926453,10926454,10926455,10926456,10926458,10926459,10926460,10926461,10926462,10926463,10926464,10926465,10926466,10926467,10926468,10926469,10926470,10926471,10926472,10926473,10926474,10926475,10926476,10926477,10926478,10926479,10926480,10926481,10926482,10926483,10926485,10926486,10926487,10926488,10926489,10926490,10926491,10926492,10926494,10926495,10926496,10926497,10926498,10926499,10926500,10926501,10926502,10926503,10926504,10926505,10926506,10926507,10926508,10926509,10926510,10926511,10926512,10926513,10926514,10926515,10926516,10926517,10926518,10926519,10926520,10926521,10926522,10926523,10926524,10926528,10926529,10926531,10926532,10926533,10926534,10926535,10926536,10926537,10926538,10926539,10926542,10926543,10926544,10926545,10926546,10926547,10926548,10926549,10926550,10926551,10621041,10926552,10926553,10926554,10926556,10926557,10926558,10926559,10926560,10621050,10621051,10926562,10621052,10926563,10926564,10926565,10926566,10926567,10926568,10926569,10926570,10926571,10926572,10926573,10926574,10926575,10926576,10926577,10926578,10926579,10926580,10926581,10926582,10926583,10926584,10926585,10926586,10926587,10926588,10926589,10926590,10926591,10926592,10926593,10926594,10926595,10926596,10926597,10926598,10926599,10926600,10926601,10926602,10926603,10926604,10926605,10926606,10926607,10926608,10926609,10926610,10926611,10926612,10926613,10926614,10926615,10926616,10926617,10926618,10926619,10926620,10926621,10926622,10926623,10926624,10926625,10926626,10926634,10926635,10926636,10926637,10926638,10926639,10926640,10926641,10926642,10926643,10926644,10926645,10926646,10926647,10926648,10926649,10926650,10926655,10926656,10926657,10926658,10926659,10926660,10926661,10926662,10926663,10926664,10926665,10926666,10926667,10926668,10926669,10926670,10926671,10926672,10926673,10926674,10926675,10926676,10926677,10926678,10926679,10926680,10926681,10926682,10926683,10926684,10926685,10926686,10926687,10926688,10926689,10926690,10926691,10926696,10927292,10927293,10927294,10927295,10927296,10927297,10927298,10927299,10927300,10927301,10927302,10927303,10927304,10927305,10927306,10927307,10927308,10927309,10927310,10927311,10927312,10927313,10927314,10927315,10927316,10927317,10927318,10927321,10927322,10927323,10927324,10927325,10927327,10927328,10927329,10927333,10927334,10927335,10927336,10927337,10927338,10927339,10927340,10927341,10927342,10927343,10927344,10927345,10927346,10927347,10927348,10927349,10927350,10927351,10927352,10927353,10927354,10927355,10927356,10927357,10927358,10927359,10927360,10927361,10927363,10927364,10927365,10927369,10927370,10927371,10927373,10927374,10927375,10927376,10927377,10927378,10927379,10927380,10927381,10927382,10927383,10927384,10927385,10927386,10927387,10927392,10927393,10927394,10927395,10927399,10927400,10927401,10927402,10927403,10927404,10927405,10927406,10927407,10927408,10927409,10927410,10927411,10927412,10927413,10927414,10565347,10611305,10614330,10559756,10611714,10611813,10611897,10611899,10612035,10612036,10612089,10612107,10563570,10557640,10557654,10557655,10557656,10557657,10612529,10612643,10612661,10612663,10612677,10557970,10557971,10612931,10609984,10613001,10610070,10558292,10613199,10613362,10610395,10610404,10610405,10610437,10610461,10610469,10610474,10613512,10558819,10558820,10558821,10613768,10610916,10511157,10511158,10511159,10511160,10511161,10511162,10511163,10511164,10511165,10511166,10511167,10513237,10513238,10513239,10513240,10511460,10511461,10511462,10511566,10511567,10511568,10511569,10511605,10511606,10511614,10511615,10511616,10511617,10511618,10511633,10511665,10511666,10511667,10511668,10511705,10511706,10511707,10511708,10511743,10511765,10517787,10514246,10514247,10514248,10514249,10514250,10514418,10514662,10514785,10514786,10514787,10514788,10514828,10512962,10512966,10512967,10512968,10417458,10415465,10415467,10417823,10420006,10463032,10463046,10463047,10463048,10463049,10463050,10463051,10463052,10463053,10463054,10463055,10463056,10471215,10471216,10463434,10463435,10463436,10463437,10463438,10463660,10465694,10465695,10463760,10463761,10463762,10465788,10463807,10463808,10463809,10463810,10463811,10463812,10463813,10463814,10463815,10463816,10463817,10463818,10465832,10465833,10465834,10465835,10465836,10463914,10463915,10463916,10463917,8563606,10462316,10462449,10462450,10462451,10462452,10462525,10462526,10462527,10462528,10462529,10464583,10462612,10470666,10470667,10470668,10470669,10470670,10470671,10470672,10470673,10470674,10470675) 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'