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(8066940,8066941,8066942,8066943,8066944,8066945,8066946,8066947,8066948,8066949,8066950,8066951,8066952,8066953,8066954,8066955,8066956,8066957,8066958,8066959,8066960,8066961,8066962,8066963,8066964,8066965,10982500,10982501,10982502,10982503,10982504,10982505,10982506,10982507,10982508,10982509,10982510,10982511,10982512,10982513,10982514,10982515,10982516,10982517,10982518,10982519,10982520,10982521,10982522,10982523,10982524,10982525,10982526,10982527,10982528,10982529,10982530,10982531,10982532,10982533,10982534,10982535,10982536,10982537,10982538,10982539,10982540,10982541,10982542,10982543,10982544,10982545,10982546,10982547,10982548,10982549,10982550,10982551,10982552,10982553,10982554,10982555,10982556,10982557,10982558,10982559,10982560,10982561,10982562,10982563,10982564,10982565,10982566,10982567,10982568,10982569,10982570,10982571,10982572,10982573,10982574,10982575,10982576,10982577,10982578,10982579,10982580,10982581,10982582,10982583,10982584,10982585,10982586,10982587,10982588,10982589,10982590,10982591,10982592,10982593,10982594,10982595,10982596,10982597,10982598,10982599,10982600,10982601,10982602,10982603,10982604,10982605,10982606,10982607,10982608,10982609,10982610,10982611,10982612,10982613,10982614,10982615,10982616,10982617,10982618,10982619,10982620,10982621,10982622,10982623,10982624,10982625,10982626,10982627,10982628,10982629,10982630,10982631,10982632,10982633,10982634,10982635,10982636,10982637,10982638,10982639,10982640,10982641,10982642,10982643,10982644,10982645,10982646,10982647,10982648,10982649,10982650,10982651,10982652,10982653,10982654,10982655,10982656,10982657,10982658,10982659,10982660,10982661,10982662,10982663,10982664,10982665,10982666,10982667,10982668,10982669,10982670,10982671,10982672,10982673,10982674,10982675,10982676,10982677,10982678,10982679,10982680,10982681,10944508,10982682,10982683,10982684,10982685,10982686,10982687,10982688,10982689,10982690,10982691,10982692,10940723,10982693,10940724,10940725,10982694,10982695,10940726,10940727,10982696,10982697,10982698,10982699,10982700,10982701,10982702,10982703,10982704,10982705,10982706,10982707,10982708,10982709,10982710,10982711,10982712,10982713,10982714,10982715,10982716,10982717,10982718,10982719,10982720,10982721,10982722,10982723,10982724,10982725,10982726,10982727,10982728,10982729,10982730,10982731,10982732,10982733,10982734,10982735,10982736,10982737,10982738,10982739,10982740,10982741,10982742,10982743,10982744,10982745,10982746,10982747,10982748,10982749,10982750,10982751,10982752,10982753,10982754,10982755,10982756,10982757,10982758,10982759,10982760,10982761,10982762,10982763,10982764,10982765,10982766,10982767,10982768,10982769,10982770,10982771,10982772,10982773,10982774,10982775,10982776,10982777,10982778,10982779,10982780,10982781,10982782,10982783,10982784,10982785,10982786,10982787,10982788,10982789,10982790,10982791,10982792,10982793,10982794,10982795,10982796,10982797,10982798,10982799,10982800,10982801,10982802,10982803,10982804,10982805,10982806,10982807,10982808,10982809,10982810,10982811,10982812,10982813,10982814,10982815,10982816,10982817,10982818,10982819,10982820,10982821,10982822,10982823,10982824,10982825,10982826,10982827,10982828,10982829,10982830,10982831,10982832,10982833,10982834,10982835,10982836,10982837,10982838,10982839,10982840,10982841,10982842,10982843,10982844,10982845,10982846,10982847,10982848,10982849,10982850,10982851,10982852,10982853,10982854,10982855,10982856,10982857,10982858,10982859,10982860,10982861,10982862,10982863,10982864,10982865,10982866,10982867,10982868,10982869,10982870,10982871,10982872,10982873,10982874,10982875,10982876,10982877,10982878,10982879,10982880,10982881,10982882,10982883,10982884,10982885,10982886,10982887,10982888,10982889,10982890,10982891,10982892,10982893,10982894,10982895,10982896,10982897,10982898,10982899,10982900,10982901,10982902,10982903,10982904,10982905,10982906,10982907,10982908,10982909,10982910,10982911,10982912,10982913,10982914,10982915,10982916,10982917,10982918,10982919,10982920,10982921,10982922,10982923,10982924,7069241,10982925,7069242,10982926,7069243,10982927,7069244,10982928,7069245,10982929,7069246,10982930,7069247,10982931,7069248,10982932,7069249,10982933,10982934,7069250,10982935,7069251,10982936,10982937,7069253,10982938,7069254,10982939,7069255,10982940,7069256,10982941,10982942,10982943,10982944,10982945,10982946,10982947,10982948,10982949,10982950,10982951,10982952,10982953,10982954,10982955,10982956,10982957,10982958,10982959,10982960,10982961,10982962,10982963,10982964,10982965,10982966,10982967,10982968,10982969,10982970,10982971,10982972,10982973,10982974,10982975,10982976,10982977,10982978,10982979,10982980,10982981,10982982,10982983,10982984,10982985,10982986,10982987,10982988,10982989,10982990,10982991,10982992,10982993,10982994,10982995,10982996,10982997,10982998,10982999,10983000,10983001,10983002,10983003,10983004,10983005,10983006,10983007,10983008,10983009,10983010,10983011,10983012,10983013,10983014,10983015,10983016,10983017,10983018,10983019,10983020,10983021,10983022,10983023,10983024,10983025,10983026,10983027,10983028,10983029,10983030,10983031,10983032,10983033,10983034,10983035,10983036,10983037,10983038,10983039,10983040,10983041,10983042,10983043,10983044,10983045,10983046,10983047,10983048,10983049,10983050,10983051,10983052,10983053,10983054,10983055,10983056,10983057,10983058,10983059,10983060,10983061,10983062,10983063,10983064,10983065,10983066,10983067,10983068,10983069,10983070,10983071,10983072,10983073,10983074,10983075,10983076,10983077,10983078,10983079,10983080,10983081,10983082,10983083,10983084,10983085,10983086,10983087,10983088,10983089,10983090,10983091,10983092,10983093,10983094,10983095,10983096,10983097,10983098,10983099,10983100,10983101,10983102,10983103,10983104,10983105,10983106,10983107,10983108,10983109,10983110,10983111,10983112,10983113,10983114,10983115,10983116,10983117,10983118,10983119,10983120,10983121,10983122,10983123,10983124,10983125,10983126,10983127,10983128,10983129,10983130,10983131,10983132,10983133,10983134,10983135,10983136,10983137,10983138,10983139,10983140,10983141,10983142,10983143,10983144,10983145,10983146,10983147,10983148,10983149,10983150,10983151,10983152,10983153,10983154,10983155,10983156,10983157,10983158,10983159,10983160,10983161,10983162,10983163,10983164,10983165,10983166,10983167,10983168,10983169,10983170,10983171,10983172,10983173,10983174,10983175,10983176,10983177,10983178,10983179,10983180,10983181,10983182,10983183,10983184,10983185,10983186,10983187,10983188,10983189,10983190,10983191,10983192,10983193,10983194,10983195,10983196,10983197,10983198,10983199,10983200,10983201,10983202,10983203,10983204,10983205,10983206,10983207,10983208,10983209,10983210,10983211,10983212,10983213,10983214,10983215,10983216,10983217,10983218,10983219,10983220,10983221,10983222,10983223,10983224,10983225,10983226,10983227,10983228,10983229,10983230,10983231,10983232,10983233,10983234,10983235,10983236,10983237,10983238,10983239,10983240,10983241,10983242,10983243,10983244,10983245,10983246,10983247,10983248,10983249,10983250,10983251,10983252,10983253,10983254,10983255,10983256,10983257,10983258,10983259,10983260,10983261,10983262,10983263,10983264,10983265,10983266,10983267,10983268,10983269,10983270,10983271,10983272,10983273,10983274,10983275,10983276,10983277,10983278,10983279,10983280,10983281,10983282,10983283,10983284,10983285,10983286,10983287,10983288,10983289,10983290,10983291,10983292,10983293,10983294,10983295,10983296,10983297,10983298,10983299,10983300,10983301,10983302,10983303,10983304,10983305,10983306,10983307,10983308,10983309,10983310,10983311,10983312,10983313,10983314,10983315,10983316,10983317,10983318,10983319,10983320,10983321,10983322,10983323,10983324,10983325,10983326,10983327,10983328,10983329,10983330,10983331,10983332,10983333,10983334,10983335,10983336,10983337,10983338,10983339,10983340,10983341,10983342,10983343,10983344,10983345,10983346,10983347,10983348,10983349,10983350,10983351,10983352,10983353,10983354,10983355,10983356,10983357,10983358,10983359,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,8569901,8569902,8569903,8569904,10930776,8863704,8863705,7057017,7057018,7057019,7057020,7057021,7057022,7057023,7057024,7057025,7057026,7057027,7057028,7057029,7057030,7057031,7057032,7057033,7057034,7057035,7057036,7057037,7057038,7057039,7057040,7057041,7057042,7057043,7057044,7057045,7057046,7057047,7057048,7057049,7057050,7057051,7057052,7057053,7057054,7057055,7057056,7057057,7057058,7057059,7057060,7057061,7057062,7057063,7057064,7057065,7057066,4972436,4972437,4972438,4972439,4972440,4972441,4972442,4972443,4972444,4972445,4972446,4972447,10421208,10421209) 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'