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(10943528,10939732,10939794,10943600,10943619,10939985,10939989,10940034,4970701,10940238,4970901,4970918,4970943,4970956,10940364,4970967,4970968,10940383,4970979,4970981,4971026,4971027,4971028,10940520,10940521,10940522,10940523,8066953,4968306,4968307,4968308,4968309,8067076,8067175,8067240,8067264,10437311,10437312,10437313,10437314,10437315,10437316,10437317,10437318,10437319,10437320,10437321,10437322,10437323,10437324,10437325,10437326,10437327,10437328,10437333,8067480,10437405,8067551,8067556,8067594,4968855,4968856,4968857,4968858,8067669,8067671,10437599,8067837,8067839,8067840,8067841,8067842,8067843,8067851,8067853,8067856,8067870,10938679,10938730,4969384,10938934,10938935,8068300,8068399,8068402,8068404,8068409,8068447,8068541,8068603,8068604,8068624,8068625,8068626,8068627,8068628,8068629,8068630,8068631,8068632,10939364,8068633,8068634,10939433,8068776,8068779,8068784,8068799,10931376,10931417,10931465,8065100,10931485,10931487,10931492,10931528,10931634,8075034,8075035,8075036,8075037,8075038,8075039,8075040,8075041,8075042,8075043,8075044,8075045,8075046,8075047,8075048,8075049,8075050,8075051,8075052,8075053,8075054,8075055,8075056,8075057,8075080,8075081,8075082,8075083,8075084,8075085,8075086,8075087,8075088,8075089,8075090,8075091,8075092,8075093,8075094,8075095,8075096,8075097,8075098,8075099,8075100,8075101,8075102,8075103,8075104,8065360,8065415,8065426,8065438,8065440,8075214,8075215,8075216,8075223,8075224,8065538,10931992,10931999,10932000,10932001,10932145,10932188,10932288,10932291,10932292,10932293,10932294,10932295,10932296,10932297,10932298,10932299,10932300,10932301,10932302,10932304,10932323,8065975,8065986,8065996,8066072,8066191,10932628,8066273,8066286,8066287,8066288,8066289,8066290,8066291,8066292,8066293,8066361,10932733,10932741,4967649,4967650,8066427,10932803,8066435,10932821,10932835,10932856,10932858,10932859,10932864,8066494,8066505,10932884,10932885,10932886,8066523,10932904,10932912,8066555,8066565,8066566,8066567,8066568,8066569,8066570,8066571,8066572,8066573,8066574,8066626,8066627,8066628,8066629,8066630,8066631,8066632,8066633,8066634,10933004,10933005,8066635,8066636,10933007,8066637,8066638,10933008,8066639,8066640,10933011,8066641,8066642,8066643,10933013,8066644,8066645,8066646,8066647,10933018,8066648,10933019,8066649,8066650,8066651,10933022,8066652,8066653,8066654,8066655,8066656,8066657,8066658,8066669,8066670,10933062,10933068,8066701,10933077,10933078,10933079,10933080,8066734,10933145,10933146,10933153,10933154,4968048,4968049,10933181,4968050,4968051,10933183,4968052,8066813,4968053,4968054,4968055,4968057,4968058,4968059,8066834,8066835,8066853,8066864,8066868,8066873,8066875,8066878,11049795,10942638,8064031,8064066,8064079,8064095,8064146,8064168,8064176,8064194,8064207,8064237,8064238,8064254,8064256,8064341,8064371,8064372,8064373,8064374,8064400,8064406,8064410,8064419,8064432,8064440,8064446,8064461,8064463,8064472,10943148,8064584,10943244,8064620,8064626,8064657,8064658,8064735,8064751,10943418,8064828,10940688,10940689,3655646,3655647,3655648,10940717,3655796,10941142,10941143,10941144,10941145,10941146,10941147,10941148,10941149,10941150,10941151,10941152,8072361,10941254,8072367,8072389,8072395,8072410,8072411,8072412,8072420,8072421,8072422,8072442,8072453,8072454,3656306,10941359,3656307,3656308,3656315,3656316,3656317,3656332,3656337,3656401,3656402,3656418,3656419,3656420,3656421,3656422,3656423,10941522,10941525,3656657,10941717,3656670,10941742,10941746,8072997,8072998,8072999,3656989,3656995,10942151,8073439,11049557,11049580,11049594,11049595,11049612,11049618,11049630,8073538,8073539,8073540,8073541,8073550,8073551,11049657,8073553,8073554,8073555,8073556,8073557,8073558,8073559,8073560,8073561,8073562,8073563,8073564,8073565,8073566,8073567,8073568,8073569,8073570,8073571,8073572,8073573,8073574,8073575,8073576,8073577,8073578,8073579,8073580,8073581,8073582,8073583,8073584,8073585,8073586,8073587,8073588,8073589,8073590,8073591,8073592,8073593,8073594,8073595,8073596,11049703,8073597,8073598,8073599,8073600,8073601,8073602,8073603,8073604,8073605,8073606,8073607,8073608,8073609,8073610,8073611,8073612,8073613,8073614,8073615,11049721,8073616,8073617,8073618,8073619,8073620,8073621,8073622,8073623,8073624,11049730,8073625,8073626,8073627,8073628,8073629,8073630,8073631,8073632,8073633,8073634,8073635,8073636,8073637,8073638,8073639,8073640,8073641,8073642,8073643,8073644,8073645,8073646,8073647,10918488,10918489,10918509,10918510,10918511,10918512,10918513,10918514,10623042,10923556,10623096,10623097,10623098,10918709,10623217,10623491,10623492,10623493,10623785,10623786,10623787,10623834,10623941,10623942,10623943,10623944,10623945,10623946,10623947,10623948,10623949,10623950,10623951,10623952,10623953,10623954,10623955,10623956,10623957,10623958,10623959,10623960,10623998,10624049,10624050,10624188,10624189,10624190,10624191,10624192,10624193,10624194,10624195,10624218,10624334,10919845,10919846,10919847,10919963,10919964,10920015,10920016,10920017,10920021,10920022,10624563,10624564,10624565,10624659,10624816,10624817,10624910,10624911,10624912,10624913,10624914,10922529,10922530,10922531,10922532,10922533,10922534,10922535,10922536,10922537,10622031,10922556,10922557,10922558,10622048,10922559,10922560,10922561,10922562,10922563,10922565,10922596,10922597,10922598,10922599,10922615,10922617,10922624,10622127,10622132,10917710,10917711,10917712,10917734,10917735,10917736,10622269,10622305,10622375,10922887,10622399,10622526,10622539,10622917,10920520,10920521,10920559,10920653,10920654,10920655,10620150,10620208,10920756,10920757,10920758,10920759,10920833,10920856,10920857,10920858,10920859,10920876,10920877,10920883,10920885,10920905,10920917,10920966,10920967,10920981,10920982,10620488,10620522,10620523,10620524,10620525,10620526,10620527,10620528,10620529,10620530,10620531,10620532,10620533,10620534,10620535,10620536,10620549,10620552,10620556,10620585,10620646,10620673,10620674,10620675,10620676,10620677,10620678,10620679,10921345,10620872,10921521,10921615,10921616,10921621,10921731,10921736,10921737,10921738,10921755,10921756,10921757,10621251,10621284,10621286,10621439,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621548,10922063,10621743,10922259,10917425,10611012,10611123,10565331,10565332,10565333,10565335,10565336,10565337,10565342,10611297,10611298,10611299,10611362,10611372,10611376,10611377,10611383,10611384,10611431,10611432,10611441,10611446,10611447,10565608,10565609,10611459,10565610,10565611,10565612,10565613,10565614,10565615,10565616,10565617,10565618,10565619,10565620,10565621,10565622,10565623,10565624,10611486,10611500,10611564,10611615,10611660,10611763,10611863,10611906,10611909,10611910,10611911,10611912,10611913,10611918,10611919,10611922,10611926,10611927,10611928,10611929,10611930,10611931,10611937,10611938,10611941,10609132,10609162,10609163,10609168,10609200,10563370,10563371,10563372,10563373,10609402,10609621,10609622,10609691,10609692,10609693,10609694,10609719,10609723,10609757,10609816,10609838,10609843,10610051,10610178,10610263,10610264,10610265,10564428,10564429,10564430,10564431,10564432,10564433,10564434,10564435,10564436,10564437,10564438,10564439,10564440,10564441,10564442,10564443,10610344,10610346,10610359,10610548,10610549,10610550,10610731,10610806,10564992,10564993,10517402,10556295,10556296,10556297,10556298,10556299,10556300,10556301,10556302,10556446,10556447,10556448,10556449,10518868,10518869,10518870,10518871,10518872,10518873,10518874,10518875,10518876,10518877,10518878,10518879,10518880,10518881,10518882,10518883,10518996,10518997,10518998,10518999,10415221,10415276,10415293,10415294,10415295,10415297,10415299,10415415,10415434,10419466,10419467,10415629,10415657,10419671,10419672,10419686,10419688,10419689,10419703,10419716,10419728,10419762,10419767,10419783,10419785,10419786,10419790,10419819,10419820,10419828,10419830,10415935,10415936,10415939,10415940,10420064,10416123,10416127,10416128,10416130,10416131,10416132,10416133,10416134,10416135,10416136,10416137,10416158,10416160,10416162,10416163,10416164,10416165,10463005,10463011,10463043,10463046,10471070,10463222,10471264,10463434,10463440,10463441,10471468,10471469,10471490,10471493,10471494,10463545,10463546,10463718,10463719,10463720,10463721,10463723,10463725,10463727,10463753,10463770,10463833,10471836,10471856,10471863,10471875,8563218,10469937,10469984,10469985,10469986,10469987,10469988,10469989,10470234,10462412,10462413,10462414,10462517,10462525,10462526,10462530,10462531,10462616,10462728,10462758) 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'