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(10939654,4970450,4970673,4970676,4970677,4970678,4970679,4970680,4970681,4970682,4970683,4970706,4970724,4970759,4970760,4970773,10939174,10939175,10939176,10939187,10939368,10939394,10939395,10939396,10939397,10939398,10939405,10939408,10939415,10939416,10939442,8065800,8065815,8065816,8065817,8065818,8065819,8065826,8065827,8065838,8065839,8065840,10623501,10623505,10623508,10622424,10622441,10622508,10622526,10620487,10620488,10620491,10620565,10621652,10621653,10621654,10621660,10621661,10621662,10621664,10621665,10621671,10621675,10621677,10621678,10621679,10621680,10621684,10621688,10621732,10610984,10610985,10611000,10611001,10611002,10611003,10611004,10611005,10611006,10611007,10611008,10611009,10611010,10611011,10611012,10611013,10611014,10611015,10611016,10611017,10611018,10611019,10611020,10611021,10611022,10611023,10611024,10611025,10611026,10611027,10611028,10611029,10611030,10611031,10611032,10611033,10611034,10611035,10611036,10611037,10611038,10611039,10611040,10611041,10611042,10611043,10611044,10611045,10611046,10611047,10611048,10611049,10611050,10611051,10611052,10611053,10611054,10611055,10611056,10611057,10611058,10611059,10611060,10611061,10611062,10611063,10611064,10611065,10611066,10611067,10611068,10611069,10611070,10611071,10611072,10611073,10611074,10611075,10611076,10611077,10611078,10611079,10611080,10611081,10611082,10611083,10611084,10611085,10611086,10611087,10611088,10611089,10611090,10611091,10611092,10611093,10611094,10611095,10611096,10611097,10611098,10611099,10611100,10611101,10611102,10611103,10611104,10611105,10611106,10611107,10611108,10611109,10611110,10611111,10611112,10611113,10611114,10611115,10611116,10611117,10611118,10611119,10611120,10611121,10611122,10611123,10611124,10611125,10611126,10611127,10611128,10611129,10611130,10611131,10611132,10611133,10611134,10611135,10611136,10611137,10611138,10611139,10611140,10611141,10611142,10611143,10611144,10611145,10611146,10611147,10611148,10611149,10611150,10611151,10611152,10611153,10611154,10611155,10611156,10611157,10611158,10611159,10611160,10611161,10611162,10611163,10611164,10611165,10611166,10611167,10611168,10611169,10611170,10611171,10611172,10611173,10611174,10611175,10611176,10611177,10611178,10611179,10611180,10611181,10611182,10611183,10611184,10611185,10611186,10611187,10611188,10611189,10611190,10611191,10611192,10611193,10611194,10611195,10611196,10611197,10611198,10611199,10611200,10611201,10611202,10611203,10611204,10611205,10611206,10611207,10611208,10611209,10611210,10611211,10611212,10611213,10611214,10611215,10611216,10611217,10611218,10611219,10611220,10611221,10611222,10611223,10611224,10611225,10611226,10611227,10611228,10611229,10611230,10611231,10611232,10611233,10611234,10611235,10611236,10611237,10611238,10611239,10611240,10611241,10611242,10611243,10611244,10611245,10611246,10611247,10611248,10611249,10611250,10611251,10611252,10611253,10611254,10611255,10611256,10611257,10611258,10611259,10611260,10611261,10611262,10611263,10611264,10611265,10611266,10611267,10611268,10611269,10611270,10611271,10611272,10611273,10611274,10611275,10611276,10611277,10611278,10611279,10611280,10611281,10611282,10611283,10611284,10611285,10611286,10611287,10611288,10611289,10611290,10611291,10611292,10611293,10611294,10611295,10611296,10611297,10611298,10611299,10611300,10611301,10611302,10611303,10611304,10611305,10611306,10611307,10611308,10611309,10611310,10611311,10611312,10611313,10611314,10611315,10611316,10611317,10611318,10611319,10611320,10611321,10611322,10611323,10611324,10611325,10611326,10611327,10611328,10611329,10611330,10611331,10611332,10611333,10611334,10611335,10611336,10611337,10611338,10611339,10611340,10611341,10611342,10611343,10611344,10611345,10611346,10611347,10611348,10611349,10611350,10611351,10611352,10611353,10611354,10611355,10611356,10611357,10611358,10611680,10611681,10611691,10611692,10611693,10611694,10611699,10611700,10611701,10611702,10611703,10611705,10611706,10611707,10611721,10611764,10611774,10611775,10611776,10611777,10611801,10611802,10611803,10611804,10611805,10611806,10611807,10611808,10611809,10611810,10611811,10611813,10566080,10566081,10566082,10566083,10609213,10609343,10609400,10609401,10609402,10609403,10609404,10609405,10609406,10609407,10609408,10609409,10609410,10609411,10609412,10609413,10609414,10609415,10609416,10609417,10609418,10609419,10609420,10609421,10609422,10609423,10609424,10609425,10609426,10609427,10609428,10609429,10609430,10609431,10609432,10609433,10609434,10609435,10609436,10609437,10609438,10609439,10609440,10609441,10609442,10609443,10609444,10609445,10609446,10609447,10609448,10609449,10609450,10609451,10609452,10609453,10609454,10609455,10609456,10609457,10609458,10609459,10609460,10609461,10609462,10609463,10609464,10609465,10609466,10609467,10609468,10609469,10609470,10609471,10609472,10609473,10609474,10609475,10609476,10609477,10609478,10609479,10609480,10609481,10609482,10609483,10609484,10609485,10609486,10609487,10609488,10609489,10609490,10609491,10609492,10609493,10609494,10609495,10609496,10609497,10609498,10609499,10609500,10609501,10609502,10609503,10609504,10609505,10609506,10609507,10609508,10609509,10609510,10609511,10609512,10609513,10609514,10609515,10609516,10609517,10609518,10609519,10609520,10609521,10609522,10609523,10609524,10609525,10609526,10609527,10609528,10609529,10609530,10609531,10609532,10609533,10609534,10609535,10609536,10609537,10609538,10609539,10609540,10609541,10609542,10609543,10609544,10609545,10609546,10609547,10609548,10609549,10609550,10609551,10609552,10609553,10609554,10609555,10609556,10609557,10609558,10609559,10609560,10609561,10609562,10609563,10609564,10609565,10609566,10609567,10609568,10609569,10609570,10609571,10609572,10609573,10609574,10609575,10609576,10609577,10609578,10609579,10609580,10609581,10609582,10609583,10609584,10609585,10609586,10609587,10609588,10609589,10609590,10609591,10609592,10609593,10609594,10609595,10609596,10609597,10609598,10609599,10609600,10609601,10609602,10609603,10609604,10609605,10609606,10609607,10609608,10609609,10609610,10609611,10609612,10609613,10609614,10609615,10609616,10609617,10609618,10609619,10609620,10609621,10609622,10609623,10609624,10609625,10609626,10609627,10609628,10609629,10609630,10609631,10609632,10609633,10609634,10609635,10609636,10609637,10609638,10609639,10609640,10609641,10609642,10609643,10609644,10609645,10609646,10609647,10609648,10609649,10609650,10609651,10609652,10609653,10609654,10609655,10609656,10609657,10609658,10609659,10609660,10609661,10609662,10609663,10609664,10609665,10609666,10609667,10609668,10609669,10609670,10517536,10419253,10419255,10419271,10419364,10419365,10419407,10419408,10419443,10419444,10419470,10419493,10419566,10419567,10419572,10419573,10419574,10419575,10419576,10419577,10419578,10419579,10419580,10419581,10419582,10419583,10419584,10419585,10419586,10419587,10419588,10419589,10419590,10419591,10419791,10419792,10419793,10420084,10420085,10420086,10420087,10420088,10420089,10420090,10420091,10420092,10420093,10420094,10420095,10420096,10420097,10420098,10420154,10420157,10420160,10420162,10420164,10420167,10420169,10420192,10420193,10420195,10470876,10470877,10470878,10470879,10470880,10470881,10470882,10470883,10470884,10470885,10470886,10470887,10470888,10470889,10470890,10470891,10470892,10470893,10470894,10470895,10470896,10470897,10470898,10470899,10470900,10470901,10470902,10470903,10470904,10470905,10470906,10470907,10470908,10470909,10470910,10470911,10470912,10470913,10470914,10470915,10470916,10470917,10470918,10470919,10470920,10470921,10470922,10470923,10470924,10470925,10470926,10470927,10470928,10470929,10470930,10470931,10470932,10470933,10470934,10470935,10470936,10470937,10470938,10470939,10470940,10470941,10470942,10470943,10470944,10470945,10470946,10470947,10470948,10470949,10470950,10470951,10470952,10470953,10470954,10470955,10470956,10470957,10470958,10470959,10470960,10470961,10470962,10470963,10470964,10470965,10470966,10470967,10470968,10470969,10470970,10470971,10470972,10470973,10470974,10470975,10470976,10470977,10470978,10470979,10470980,10470981,10470982,10470983,10470984,10470985,10470986,10470987,10470988,10470989,10470990,10470991,10470992,10470993,10470994,10470995,10470996,10470997,10470998,10469897,10470083,10470084,10470085,10470086,10470087,10470088,10470089,10470090,10470091,10470696,10470725,10470813,10470814,10470815,10470816,10470817,10470818,10470819,10470820,10470821,10470822,10470823,10470824,10470825,10470826,10470827,10470828,10470829,10470830,10470831,10470832,10470833,10470834,10470835,10470836,10470837,10470838,10470839,10470840,10470841,10470842,10470843,10470844,10470845,10470846,10470847,10470848,10470849,10470850,10470851,10470852,10470853,10470854,10470855,10470856,10470857,10470858,10470859,10470860,10470861,10470862,10470863,10470864,10470865,10470866,10470867,10470868,10470869,10470870,10470871,10470872,10470873,10470874,10470875) 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'