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(10940437,10940438,10940508,10940509,10940510,10940511,10940512,10940513,10940514,10940515,10940516,10940517,10940518,10940519,10940520,10940521,10940522,10940523,10940524,10940525,10940526,10940527,10940528,10940529,10940530,10940531,10940532,10940533,10940534,10940535,10940536,10940537,10940538,10940549,10940550,10940551,10940552,10940553,10940554,10940555,10940556,10940557,10940558,8066913,8066914,8066915,8066916,8066917,8066918,8066919,8066920,8067858,10938652,8068597,8068598,8068599,8068600,8068601,8068602,8068603,8068604,8068605,8068606,8068607,8068608,8068609,8068610,8068611,8068612,8068613,8068614,8068615,8068616,8068617,8068618,8068619,8068620,8068621,8068622,8068623,8068624,8068625,8068626,8068627,8068628,8068629,8068630,8068631,8068632,8068633,8068634,8068635,8068636,8068637,8068638,8068639,8068640,8068641,8068642,8068643,8068644,8068645,8068646,8068647,8068648,8068649,8068650,8068651,8068652,8068653,8068654,8068655,8068656,8068657,8068658,8068659,8068660,8068661,8068662,8068663,8068664,8068665,8068666,8068667,8068668,8068669,8068670,8068671,8068672,8068673,8068674,8068675,8068676,8068677,8068678,8068679,8068680,8068681,8068682,8068683,8068684,8068685,8068686,8068687,8068688,8068689,8068690,8068691,8068692,8068693,8068694,8068695,8068696,8068697,8068698,8068699,8068700,8068701,8068702,8068703,8068704,8068705,8068706,8068707,8068708,8068709,8068710,8068711,8068712,8068713,8068714,8068715,8068716,8068717,8068718,8068719,8068720,8068721,8068722,8068723,8068724,8068725,8068726,8068727,8068728,8068729,8068730,8068731,8068732,8068733,8068734,8068735,8068736,8068737,8068738,8068739,8068740,8068741,8068742,8068743,8068744,8068745,8068746,8068747,8068748,8068749,8068750,8068751,8068752,8068753,8068754,8068755,8068756,8068757,8068758,8068759,4967739,4967740,4967741,4967742,4967743,4967744,4967745,4967746,4967747,4967748,4967749,4967750,4967751,4967752,4967753,4967754,4967755,8066557,8066558,8066559,8066560,8066561,8066562,8066563,8066564,8066565,8066566,8066567,8066568,8066569,8066570,8066571,8066572,8066573,8066574,8066575,8066576,8066577,8066578,8066579,8066580,8066581,8066582,8066583,8066584,8066585,8066586,8066587,8066588,8066589,8066590,8066591,8066592,8066593,8066594,8066595,8066596,8066597,8066598,8066599,8066600,8066601,8066602,8066603,8066604,8066605,8066606,8066607,8066608,8066609,8066610,8066611,8066612,8066613,8066614,8066615,8066616,8066617,8066618,8066619,8066620,8066621,8066622,8066623,8066624,8066625,8066626,8066627,8066628,8066629,8066630,8066631,8066632,8066633,8066634,8066635,8066636,8066637,8066638,8066639,8066640,8066641,8066642,8066643,8066644,8066645,8066646,8066647,8066648,8066649,8066650,8066651,8066652,8066653,8066654,8066655,8066656,8066657,8066658,8066659,8066660,8066661,8066662,8066663,8066664,8066665,8066666,8066667,8066668,8066669,8066670,8066671,8066672,8066673,8066674,8066675,8066676,8066677,8066678,8066679,8066680,8066681,8066682,8066683,8066684,8066685,8066686,8066687,8066688,8066689,8066690,8066691,8066692,8066693,8066694,8066695,8066696,8066697,8066698,8066699,8066700,8066701,8066702,8066703,8066704,8066705,8066706,8066707,8066708,8066709,8066710,8066711,8066712,8066713,8066714,8066715,8066716,8066717,8066718,8066719,8066720,8066721,8066722,8066723,8066724,8066725,8066726,8066727,8066728,8066729,8066730,8066731,8066732,8066733,8066734,8066735,8066736,8066737,8066738,8066739,8066740,8066741,8066742,8066743,8066744,8066745,8066746,8066747,8066748,8066749,8066750,8066751,8066752,8066753,8066754,8066755,8066756,8066757,8066758,8066759,8066760,8066761,8066762,8066763,8066764,8066765,8066766,8066767,8066768,8066769,8066770,8066771,8066772,8066773,8066774,8066775,8066776,8066777,8066778,8066779,8066780,8066781,8066782,8066783,8066784,8066785,8066786,8066787,8066788,8066789,8066790,8066791,8066792,8066793,8066794,8066795,8066796,8066797,8066798,8066799,8066800,8066801,8066802,8066803,8066804,8066805,8066806,8066807,8066808,8066809,8066810,8066811,8066812,8066813,8066814,8066815,8066816,8066817,8066818,8066819,8066820,8066821,8066822,8066823,8066824,8066825,8066826,8066827,8066828,8066829,8066830,8066831,8066832,8066833,8066834,8066835,8066836,8066837,8066838,8066839,8066840,8066841,8066842,8066843,8066844,8066845,8066846,8066847,8066848,8066849,8066850,8066851,8066852,8066853,8066854,8066855,8066856,8066857,8066858,8066859,8066860,8066861,8066862,8066863,8066864,8066865,8066866,8066867,8066868,8066869,8066870,8066871,8066872,8066873,8066874,8066875,8066876,8066877,8066878,8066879,8066880,8066881,8066882,8066883,8066884,8066885,8066886,8066887,8066888,8066889,8066890,8066891,8066892,8066893,8066894,8066895,8066896,8066897,8066898,8066899,8066900,8066901,8066902,8066903,8066904,8066905,8066906,8066907,8066908,8066909,8066910,8066911,8066912,8064477,8064478,8064479,8064480,8064481,8064482,8072909,8072910,8072911,8072912,8072913,8072914,8072915,8072916,10623359,10919396,10920314,10920351,10920352,10920353,10622466,10622467,10622468,10622469,10917980,10622470,10622471,10622472,10622473,10622474,10622475,10622476,10622477,10622478,10622479,10622480,10622481,10622482,10622483,10622484,10622485,10622486,10622487,10622488,10622489,10622490,10622491,10622492,10622493,10622494,10622495,10622496,10622497,10622498,10622499,10622500,10620661,10620662,10620663,10620664,10620665,10620666,10620667,10620668,10620670,10916445,10916446,10916447,10916448,10916449,10916450,10916451,10916452,10916532,10916533,10916534,10916535,10621421,10621422,10621423,10621424,10621425,10621426,10621427,10621428,10621429,10621430,10621431,10621432,10621433,10621434,10621435,10621436,10621437,10621438,10621439,10621440,10621441,10621442,10621443,10621444,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621453,10621454,10621455,10621456,10621457,10621458,10621459,10621460,10621461,10621462,10621463,10621464,10621465,10621466,10621467,10621468,10621469,10621470,10621471,10621472,10621473,10621474,10621475,10621476,10621477,10621478,10621479,10621480,10621481,10621482,10621483,10621484,10621485,10621486,10621487,10621488,10621489,10621490,10621491,10621492,10621493,10621494,10621495,10621496,10621497,10621498,10621499,10621500,10621501,10621502,10621503,10621504,10621505,10621506,10621507,10621508,10621509,10621510,10621511,10621512,10621513,10621514,10621515,10621516,10621517,10621518,10621519,10621520,10621521,10621522,10621523,10621524,10621525,10621526,10621527,10621528,10621529,10621530,10621531,10621532,10621533,10621534,10621535,10621536,10621537,10621538,10621539,10621540,10621541,10621542,10621543,10621544,10621545,10621564,10621567,10621568,10621569,10621570,10621571,10621572,10621573,10621574,10621575,10621576,10621577,10621578,10621579,10621580,10621581,10621582,10621583,10621584,10621585,10621586,10621587,10621588,10621589,10621590,10621591,10621592,10621593,10621594,10621595,10621596,10621597,10621598,10621599,10621600,10621601,10621602,10621603,10621604,10621605,10621606,10621607,10621608,10621609,10621610,10621611,10621612,10621613,10621614,10621615,10621616,10621617,10621618,10621619,10621620,10621621,10621622,10621623,10621624,10621625,10621626,10621627,10621628,10621629,10621630,10621631,10621632,10621633,10621634,10621635,10621636,10621637,10621638,10621639,10621640,10621641,10621642,10621643,10621644,10621645,10621646,10621647,10621648,10621649,10621650,10621651,10621652,10621653,10621654,10621655,10621656,10621657,10621658,10621659,10621660,10621661,10621662,10621663,10621664,10621665,10621666,10621667,10621668,10621669,10621670,10621671,10621672,10621673,10621674,10621675,10621676,10621677,10621678,10621679,10621680,10621681,10621682,10621683,10621684,10621685,10621686,10621687,10621688,10621689,10621690,10621691,10621692,10621693,10621694,10621695,10621696,10621697,10621698,10621699,10621700,10621701,10621702,10621703,10621704,10621705,10621706,10621707,10621708,10621709,10621710,10621711,10621712,10621713,10621714,10621715,10621716,10621717,10621718,10621719,10621720,10621721,10621722,10621723,10621724,10621725,10621726,10621727,10621728,10621729,10621730,10621731,10621732,10621733,10621734,10621735,10621736,10621737,10621738,10621739,10621740,10621741,10621742,10621743,10621744,10621745,10621746,10621747,10621748,10621749,10621750,10917324,10917325,10611037,10609306,10563544,10609975,10463184,10463185,10463186,10463187,10463188,10463189,10463190,10463191,10463192,10463193,10463194,10463195,10463196,10463197,10463198,10463199,10463200,10471562) 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'