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(11027707,10943623,7076337,7076338,7076339,7076340,7076341,7076342,7076344,7076345,7076349,7076350,7076351,7076352,11028811,7066287,7066288,7066290,8622727,8622731,8622732,8622733,10961958,10961959,8620120,11001153,7075498,11001373,11001374,7064339,10960076,10960485,7065274,10986979,10986980,10986981,10986982,10986983,10986984,10986989,10986990,10986991,10986992,4967890,4967891,4967892,4967893,4967895,4968029,11010745,8064569,8064570,8064571,8064572,8064574,11049536,10842424,10943380,10943381,10943384,10943385,10943389,10943394,8970194,8564077,8564078,8564079,10941136,10970565,8834218,10942430,11006620,11006621,11006622,11006623,11006624,11006625,11006626,11006627,11006629,11006631,11006633,11006635,11006636,11006637,11006639,11006640,11006684,11006685,11006688,11006689,11006690,11006691,11006693,11006699,11006700,11006701,11006702,11006703,11006704,11006705,11006706,11006707,11006708,11006709,11006710,11006711,11006713,11006714,11006716,11006717,11006718,10928610,10928613,10928614,10928616,10928617,10928618,10618296,10618316,10624178,10624179,10624180,10624183,10624184,10624185,11046881,11046882,11046883,11046884,11046885,11046886,11046887,11046888,11046889,11046890,11046891,11046892,11046893,11046894,11046895,11046896,11046897,11046898,11046899,11046900,11046901,11046902,11046903,11046904,11046905,11046906,11046907,11046908,11046909,11046910,11046911,11046912,11046913,11046914,11046915,11046916,11046917,11046918,11046919,11046920,11046921,11046922,11046923,11046924,11046925,11046926,11046927,11046928,11046929,11046930,11046931,11046932,11046933,11046934,11046935,11046936,11046937,11046938,11046939,11046940,11046941,11046942,11046943,11046944,11046945,11046946,11046947,11046948,11046949,11046950,11046951,11046952,11046953,11046954,11046955,11046956,11046957,11046958,11046959,11046960,11046961,11046962,11046963,11046964,11046965,11046966,11046967,11046968,11046969,11046973,11046974,11046976,11046978,11046980,11046981,11046982,11046983,11046984,11046985,11046989,11046990,11046993,10619346,10617039,11044926,11045267,11045268,11006611,11006612,11006613,11006614,11006615,11006617,11006618,11006619,10991102,10991113,10921415,10921423,10616048,10927066,10927067,10616722,10616723,10953514,10953515,10953516,10953517,10953518,10953519,10953522,8611752,7059854,9213762,9213764,9213765,9213766,9213767,9213768,9213769,9213770,9213771,9213772,9213773,9213774,9213775,9213776,9213777,9213778,9213779,9213780,9213781,9213782,9213783,9213784,9213785,9213786,9213787,9213789,9213790,9213791,9213793,9213794,9213795,9213796,9213797,9213798,9213799,9213800,9213801,9213802,9213803,9213804,9213805,9213806,9213807,9213808,9213809,9213810,9213811,9213812,9213813,9213814,9213815,9213816,9213817,9213818,9213819,9213820,9213821,9213822,9213823,9213824,9213825,9213826,9213827,9213828,9213829,9213830,9213831,9213833,9213834,9213835,9213836,9213837,9213840,9213841,9213842,9213843,9213844,9213845,9213846,9213855,9213856,9213857,9213858,9213859,9213863,9213868,9213882,9213884,6666276,9211961,9211962,9211963,9180095,9196161,9196162,9172164,10612856,9196346,9164772,9164773,10121244,10121245,9205196,9205198,9201324,7055683,7055684,10118294,10118295,9170124,9170125,9170127,9202595,10118978,10514964,10514965,9160514,10415560,8918317,8918318,10416640,10416641,7054964,10416814,10416815,10416862,10416863,10416864,10416865,10419884,9161230,9169284,8549902,10463405,10463407,10463409,10463410,10463411,10463414,9207571,8917242,10464356,9183808,9183810,4972810,4972811,4972812,9208029,9168070,10946338,10946344,10946345,10946350,10946763,10946764,10946765,10155444,10155450,10155456,8594475,10884604,10156252,10156253,7000692,10877544,10176750,10876641,10172761,10631276,10599421,10599422,10599423,10599424,10599425,10599426,10599427,10599428,10599429,10599430,10599431,10599432,10599433,10599434,10599435,10599436,10599437,10599438,10599439,10599440,10599441,10599442,10599443,10599444,10599445,10599446,10599447,10599448,10599449,10599450,10599451,10599452,10599453,10599454,10599455,10599456,10599457,10599458,10599459,10599460,10599461,10599462,10599463,10599464,10599465,10599466,10599467,10599468,10599469,10599470,10599471,10599472,10599473,10599474,10599475,10599476,10599477,10599478,10599479,10599480,10599481,10599482,10599483,10599484,10599485,10599486,10599487,10599488,10599489,10599490,10599491,10599492,10599493,10599494,10599495,10599496,10599497,10599498,10599499,10599500,10599501,10599502,10599503,10599504,10599505,10599506,10599507,10599508,10599509,10599510,10599511,10599512,10599513,10599514,10599515,10599516,10599517,10599518,10599519,10599520,10599521,10599522,10599523,10599524,10599525,10599526,10599527,10599528,10599529,10599530,10599531,10599532,10599533,10599534,10599535,10599536,10599537,10599538,10599539,10599540,10599541,10599542,10599543,10599544,10599545,10599546,10599547,10599548,10599549,10599550,10599551,10599552,10599553,10599554,10599555,10599556,10599557,10599558,10599559,10599560,10599561,10599562,10599563,10599564,10599565,10599566,10599567,10599568,10599569,10599570,10599571,10599572,10599573,10599574,10599575,10599576,10599577,10599578,10599579,10599580,10599581,10599582,10599583,10599584,10599585,10599586,10599587,10599588,10599589,10599590,10599591,10590592,10599592,10599593,10599594,10599595,10599596,10599597,10599598,10599599,10599600,10599601,10599602,10599603,10599604,10599605,10599606,10599607,10599608,10599609,10599610,10599611,10599612,10599613,10599614,10599615,10599616,10599617,10599618,10599619,10599620,10599621,10599622,10599623,10599624,10599625,10599626,10599627,10599628,10599629,10599630,10599631,10599632,10599633,10599634,10599635,10599636,10599637,10599638,10599639,10599640,10599641,10599642,10599643,10599644,10599645,10599646,10599647,10599648,10599649,10599650,10599651,10599652,10599653,10599654,10599655,10599656,10599657,10599658,10599659,10599660,10599661,10599662,10599663,10599664,10599665,10599666,10599667,10599668,10599669,10599670,10599671,10599672,10599673,10599674,10599675,10599676,10599677,10599678,10599679,10599680,10599681,10599682,10599683,10599684,10599685,10599686,10599687,10599688,10599689,10599690,10599691,10599692,10599693,10599694,10599695,10599696,10599697,10599698,10599699,10599700,10599701,10599702,10599703,10599704,10599705,10599706,10599707,10599708,10599709,10599710,10599711,10599712,10599713,10599714,10599715,10599716,10599717,10599718,10599719,10599720,10599721,10599722,10599723,10599724,10599725,10599726,10599727,10599728,10599729,10599730,10599731,10599732,10599733,10599734,10599735,10599736,10599737,10599738,10599739,10599740,10599741,10599742,10599743,10599744,10599745,10599746,10599747,10599748,10599749,10599750,10599751,10599752,10599753,10599754,10599755,10599756,10599757,10599758,10599759,10599760,10599761,10599762,10599763,10599764,10599765,10599766,10599767,10599768,10599769,10599770,10599771,10599772,10599773,10599774,10599775,10599776,10599777,10599778,10599779,10599780,10599781,10599782,10599783,10599784,10599785,10599786,10599787,10599788,10599789,10599790,10599791,10599792,10599793,10599794,10599795,10599796,10599797,10599798,10599799,10599800,10599801,10599802,10599803,10599804,10599805,10599806,10599807,10599808,10599809,10599810,10599811,10599812,10599813,10599814,10599815,10599816,10599817,10599818,10599819,10599820,10599821,10599822,10599823,10599824,10599825,10599826,10599827,10599828,10599829,10599830,10599831,10599832,10599833,10599834,10599835,10599836,10599837,10599838,10599839,10599840,10599841,10599842,10599843,10599844,10599845,10599846,10599847,10599848,10599849,10599850,10599851,10599852,10599853,10599854,10599855,10599856,10599857,10599858,10599859,10599860,10599861,10599862,10599863,10599864,10599865,10599866,10599867,10599868,10599869,10599870,10599871,10599872,10599873,10599874,10599875,10599876,10599877,10599878,10599879,10599880,10599881,10599882,10599883,10599884,10599885,10599886,10599887,10599888,10599889,10599890,10599891,10599892,10599893,10599894,10599895,10599896,10599897,10599898,10599899,10599900,10599901,10599902,10599903,10599904,10599905,10599906,10599907,10599908,10599909,10599910,10599911,10599912,10599913,10599914,10599915,10599916,10599917,10599918,10599919,10599920,10599921,10599922,10599923,10599924,10599925,10599926,10599927,10599928,10599929,10599930,10599931,10599932,10599933,10599934,10599935,10599936,10599937,10599938,10599939,10599940,10599941,10599942,10599943,10599944,10599945,10599946,10599947,10599948,10599949,10599950,10599951,10599952,10599953,10599954,10599955,10599956,10599957,10599958,10599959,10599960,10599961,10599962,10599963,10599964,10599965,10599966,10599967,10599968,10599969,10599970,10599971,10590996,10567829,10567830,10567831,10567832,10567833,10567834,10567835,10567836,10425271,10421662,10424917,10424918,10484001,10484002,10484003,10484004,10484005,10484007,10486660) 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'