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(10940041,10940052,10940056,10940064,10940065,10940069,10940070,4970666,10940074,4970667,4970668,4970669,10940088,4970683,10940091,10940096,10940097,4970718,4970720,4970722,4970723,4970724,4970725,4970769,10940253,10940292,10940306,10938512,10938552,10938554,10938557,10938560,10938563,10938578,10938580,10938589,10938591,10938595,10938597,10938608,10938629,10938630,10938631,10938633,8067907,10938642,10938643,10938646,10938648,10938658,10938659,10938665,10938671,10938672,10938673,10938683,10938745,10938768,10938798,10938807,10938809,10938811,10938816,10938932,10938938,10938939,10938944,10938945,10938946,10938947,10938948,10938953,10938955,10938958,10938964,10938972,10938984,10938985,10939011,10939036,10939040,10939131,10939134,10939136,10939143,10939151,10939157,10939165,10939219,10939222,10939224,10939229,10939230,10939232,10939235,10939237,10939238,10939239,10939242,10939243,10939244,10939245,10939246,10939248,10939249,10939251,10939254,10939255,10939256,10939257,10939259,10939260,10939262,10939263,10939265,10939266,10939276,10939280,10939285,10939286,10939289,10939290,10939291,10939292,10939293,10939294,10939295,10939296,10939299,10939302,10939303,10939307,10939308,10939310,10939311,10939312,10939315,10939316,10939317,10939318,10939321,10939329,10939337,10939340,10939342,10939344,10939345,10939346,10939348,10939349,10939350,10939351,10939352,10939355,10939357,10939358,10939504,10939505,10939509,10939516,10939519,10939525,10939536,10939538,10939539,10939540,10931620,10931897,8065795,8065812,8065813,8065818,8065841,10933046,11049794,10942643,8970225,10931197,10940583,10940655,10940657,10940658,10940659,10940660,10940672,10940782,10940936,10941008,10941010,10941020,10941022,10941035,10941358,10941359,10941362,10941379,10941395,3656389,10941471,10941576,10941581,10941606,10941607,10941638,10941644,10941729,10941732,10941733,10942022,10623098,10623235,10623310,10623311,10623312,10623313,10623314,10623315,10623316,10623317,10623318,10623319,10623320,10623321,10623322,10623323,10623324,10623325,10623326,10623327,10623328,10623329,10623330,10623331,10623332,10623333,10623334,10623335,10623336,10623337,10623338,10623339,10623340,10623341,10623342,10623343,10623344,10623345,10623346,10623347,10623348,10623349,10623350,10623351,10623352,10623353,10623354,10623355,10623356,10623357,10623358,10623359,10623360,10623361,10623362,10623363,10623364,10623365,10623366,10623367,10623368,10623369,10623370,10623371,10623372,10623373,10623374,10623375,10623376,10623377,10623378,10623379,10623380,10623381,10623382,10623383,10623384,10623385,10623386,10623387,10623388,10623389,10623390,10623391,10623392,10623393,10623394,10623395,10623396,10623397,10623398,10623399,10623400,10623401,10623402,10623403,10623404,10623405,10623406,10623407,10623408,10623409,10623410,10623411,10623412,10623413,10623414,10623415,10623416,10623417,10623418,10623419,10623420,10623421,10623422,10623423,10623424,10623425,10623426,10623427,10623428,10623429,10623430,10623431,10623432,10623433,10623434,10623435,10623436,10623437,10623438,10623439,10623440,10623441,10623442,10623443,10623444,10623445,10623446,10623447,10623448,10623449,10623450,10623451,10623452,10623453,10623454,10623455,10623456,10623457,10623458,10623459,10623460,10623461,10623462,10623463,10623464,10623465,10623466,10623467,10623468,10623469,10623470,10623471,10623472,10623473,10623474,10623475,10623476,10623477,10623492,10623505,10623508,10623511,10623512,10623515,10623525,10623529,10623544,10623550,10623554,10623555,10623558,10623564,10623588,10623589,10623590,10623632,10623633,10623634,10624902,10624904,10624910,10624919,10621971,10621972,10621975,10622156,10622157,10622185,10622199,10622526,10620189,10620190,10620191,10620192,10620193,10620194,10620202,10620203,10620204,10620205,10620206,10620213,10620214,10620232,10620254,10620283,10620285,10620441,10620442,10620443,10620444,10620465,10620537,10620538,10620563,10620591,10620592,10620596,10620597,10620599,10620600,10620601,10620602,10620604,10620610,10620611,10620612,10620613,10620616,10620617,10620618,10620619,10620621,10620622,10620623,10620708,10620742,10620747,10620764,10620856,10620933,10621229,10621751,10613966,10613969,10613970,10613977,10613978,10610984,10610985,10613985,10613996,10613997,10611004,10611005,10611006,10614006,10614007,10614014,10614018,10614019,10611020,10614022,10614023,10614026,10614034,10614038,10614039,10614040,10614041,10614042,10614043,10614044,10614045,10614046,10611046,10611047,10614047,10614048,10611049,10614049,10614050,10614051,10614052,10611053,10614053,10611054,10614054,10614055,10614056,10614057,10611062,10611085,10611093,10611101,10611103,10611112,10611113,10611128,10611133,10611134,10614187,10614188,10614189,10614190,10614191,10614192,10614193,10614194,10614195,10614196,10614197,10614198,10611209,10611215,10614221,10611248,10614259,10611281,10611282,10611291,10614337,10614343,10614344,10614354,10614373,10614413,10611421,10614497,10614498,10614514,10614515,10611523,10614533,10614538,10614551,10614561,10614568,10611570,10614632,10614658,10611680,10611681,10611691,10614705,10614727,10611757,10614759,10614760,10614761,10614762,10614763,10614764,10611831,10611835,10611858,10611859,10611860,10614864,10614870,10611948,10612053,10609070,10609079,10609101,10609120,10609123,10609124,10609165,10612168,10612169,10609169,10612170,10609170,10609171,10609172,10612245,10609261,10612273,10609302,10612314,10609314,10612315,10612320,10612321,10612344,10609355,10609356,10609361,10609368,10609370,10609371,10609372,10609373,10609374,10609380,10609386,10612388,10609402,10609403,10609417,10609418,10609421,10609426,10609427,10612430,10609430,10609434,10609437,10609440,10609443,10609448,10609449,10609456,10609459,10609461,10609463,10609464,10609465,10609466,10609469,10609476,10612480,10609484,10609485,10609486,10609487,10609488,10609489,10609490,10609491,10609492,10609493,10609494,10609495,10612507,10612508,10612509,10612510,10609525,10609526,10609530,10609532,10609533,10609544,10609549,10609555,10609556,10609557,10609558,10609559,10609560,10609561,10609562,10609563,10609567,10609585,10612592,10609598,10609602,10609606,10609611,10609621,10609634,10609636,10609642,10609647,10609648,10609649,10609650,10609651,10609652,10609653,10609654,10609655,10609656,10609660,10609664,10609680,10609685,10609690,10609696,10609707,10609709,10609712,10609717,10612718,10609718,10609720,10612723,10609723,10609724,10609727,10609732,10609733,10609734,10609735,10609736,10609737,10609738,10609739,10609740,10609741,10609742,10609743,10609744,10609746,10609747,10609753,10609754,10609755,10609756,10609758,10609759,10609760,10609761,10609762,10609764,10609765,10612767,10612769,10612771,10612772,10612773,10612774,10612775,10612776,10612777,10612778,10612779,10612780,10609781,10609792,10612800,10612803,10609803,10612804,10612809,10612811,10609811,10612812,10612813,10609813,10609814,10612815,10612816,10612817,10609820,10612822,10612823,10609823,10609829,10609837,10609838,10612839,10609839,10609845,10612872,10609881,10609882,10612883,10609895,10609896,10609897,10609902,10609903,10609904,10609905,10609906,10609907,10609908,10609909,10609910,10609911,10609912,10609913,10609914,10609915,10609926,10609929,10609931,10609943,10609945,10609956,10609971,10609976,10612979,10612982,10612984,10612985,10609986,10609987,10609989,10612993,10613022,10610022,10610030,10610052,10613067,10613080,10610097,10610101,10610107,10613116,10610119,10613125,10613127,10610135,10610136,10610139,10610160,10610161,10610162,10610163,10613212,10613273,10610274,10613278,10613284,10613289,10610315,10610334,10610337,10610359,10610361,10564549,10564551,10610415,10610416,10613432,10613433,10610434,10610436,10613443,10610444,10610446,10610449,10610464,10610474,10613639,10613640,10613641,10610689,10564839,10610690,10610694,10610761,10613780,10613790,10613791,10610793,10613796,10613797,10613803,10613808,10613813,10613814,10613822,10613831,10613835,10613836,10613845,10613849,10613850,10613851,10613853,10613854,10613855,10613856,10613857,10613858,10613859,10613865,10613869,10613871,10613873,10613878,10613880,10610881,10613881,10613885,10613886,10613887,10613893,10613903,10613904,10613910,10613911,10613915,10613916,10613919,10613920,10613921,10613925,10613926,10613938,10613939,10419253,10415360,10415361,10419388,10419389,10419390,10419408,10415418,10415576,10415662,10415666,10415775,10415776,10415937,10415938,10415939,10420128,10420129,10420130,10420131,10416145,10416146,10416147,10416148,10416149,10470976,10470977,10470978,10470979,10470980,10470981,10470982,10470983,10470984,10470985,10470986,10470987,10470988,10470989,10470990,10470991,10470992,10470993,10470994,10470995,10470996,10470997,10470998,10471136,10463511,10463522,10463528,10463537,10469948,10469963,10470017,10470018,10470019,10470020,10470021,10470057,10470089,10470090,10470203,10470639,10470716,10470748,10470749,10470754,10470761,10470765,10470766,10470769,10470773,10470774,10470780,10470782,10470786,10470791,10470801,10470838,10470839) 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'