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(4970290,4970340,4970342,4970410,4970411,4970417,4970423,4970426,4970433,4970435,4970442,4970463,4970559,4970563,4970597,4970598,4970645,4970646,4970647,4970648,4970667,4970668,4970677,4970686,4970700,4970730,4970731,4970732,4970733,4970735,4970740,4970753,4970768,4970771,4970772,4970791,4970853,4970858,4970875,4970876,4970877,4970879,4970880,4970886,4970887,4970888,4970889,4970891,4970894,4970895,4970902,4970908,4970910,4970915,4970954,4970955,4970962,4970963,4970964,4970967,4970968,4970973,4970990,4970991,4971023,4971061,4971062,4971096,4971119,4971120,4968202,4968203,4968204,4968452,4968453,4968454,4968550,4968558,4968583,4968584,4968585,4968631,4968643,4968672,4968673,4968674,4968696,4968765,4968848,4969018,4969019,4969020,4969021,4969022,4969023,4969024,4969025,4969026,4969027,4969028,4969117,4969118,4969214,4969287,4969294,4969298,4969299,4969320,4969338,4969339,4969376,4969377,4969378,4969379,4969380,4969381,4969639,4969640,4969641,4969693,4969694,4969695,4969905,4969929,4969930,4969931,8075250,8075251,8075252,8075253,8075254,8075255,8075256,8075266,8075267,8075280,8075329,8075378,8075379,8075382,8075384,8075406,8075412,8075417,8075422,8075439,8075440,8075442,8075451,8075452,8075456,8075503,8075507,8075534,4967029,4967030,4967031,4967069,4967070,4967071,4967072,4967073,4967074,4967075,4967076,4967077,4967078,4967079,4967080,4967081,4967355,4967437,4967438,4967439,4967440,4967448,4967449,4967577,4967767,4967862,4967863,4967864,4967866,4967867,4967870,4967881,4967980,4967986,4967987,4967988,4967989,4967996,8072357,8072358,8072359,8072360,8072361,8072362,8072363,8072364,8072365,8072366,8072367,8072368,8072369,8072370,8072371,8072372,8072373,8072374,8072375,8072376,8072377,8072378,8072379,8072380,8072381,8072382,8072383,8072384,8072385,8072386,8072387,8072388,8072389,8072390,8072391,8072392,8072393,8072394,8072395,8072396,8072397,8072398,8072399,8072400,8072401,8072402,8072403,8072404,8072405,8072406,8072407,8072408,8072409,8072410,8072411,8072412,8072413,8072414,8072415,8072416,8072417,8072418,8072419,8072420,8072421,8072422,8072423,8072424,8072425,8072426,8072427,8072428,8072429,8072430,8072431,8072432,8072433,8072434,8072435,8072436,8072437,8072438,8072439,8072440,8072441,8072442,8072443,8072444,8072445,8072446,8072447,8072448,8072449,8072450,8072451,8072452,8072453,8072454,8072455,8072456,8072457,8072458,8072459,8072460,8072461,8072462,8072463,8072464,8072465,8072466,8072467,8072468,8072469,8072470,8072471,8072610,8072611,8072612,8072613,8072614,8072615,8072643,8072644,8072645,8072646,8072647,8072648,8072649,8072650,8072651,8072652,8072653,8072654,8072655,8072656,8072657,8072658,8072659,8072660,8072661,8072662,8072663,8072664,8072665,8072666,8072667,8072668,8072669,8072670,8072671,8072672,8072673,8072674,8072675,8072676,8072677,8072678,8072679,8072680,8072681,8072682,8072683,8072684,8072685,8072686,8072687,8072688,8072689,8072690,8072691,8072692,8072693,8072694,8072695,8072696,8072697,8072698,8072699,8072700,8072701,8072702,8072703,8072704,8072705,8072706,8072707,8072708,8072709,8072710,8072711,8072712,8072713,8072714,8072715,8072716,8072717,8072718,8072719,8072720,8072721,8072722,8072723,8072724,8072725,8072726,8072727,8072728,8072729,8072730,8072731,8072732,8072733,8072734,8072735,8072736,8072737,8072738,8072739,8072740,8072741,8072742,8072743,8072744,8072745,8072746,8072747,8072748,8072749,8072750,8072751,8072752,8072753,8072754,8072755,8072756,8072757,8072758,8072759,8072760,8072761,8072762,8072763,8072764,8072765,8072766,8072767,8072768,8072769,8072770,8072771,8072772,8072773,8072774,8072775,8072776,8072777,8072778,8072779,8072780,8072781,8072782,8072783,8072784,8072785,8072786,8072787,8072788,8072789,8072790,8072791,8072792,8072938,8072939,8072940,8072941,8072942,8072945,8072946,8072947,8072948,8072949,8073036,8073037,8073067,8073068,8073074,8073089,8073094,8073301,8073302,8073304,8073305,8073306,8073307,8073308,8073309,8073310,8073312,8073313,8073314,8073315,8073316,8073319,8073320,8073321,8073322,8073323,8073324,8073327,8073332,8073333,8073334,8073335,8073336,8073337,8073338,8073339,8073340,8073423,8073424,8073426,8073427,8073429,8073430,8073435,8073436,8073437,8073462,8073465,8073466,8073477,8073501,8073519,8073523,8073524,8073528,10622967,10622987,10622996,10623022,10623023,10623024,10623025,10623048,10623049,10623050,10623185,10623186,10623187,10623188,10623189,10623190,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623208,10623307,10623401,10623493,10623494,10623496,10623500,10623504,10623507,10623547,10623548,10623549,10623550,10623551,10623552,10623591,10623592,10623593,10623594,10623595,10623596,10623597,10623598,10623599,10623600,10623601,10623602,10623603,10623608,10623613,10623619,10623624,10623625,10623639,10623651,10623675,10623676,10623771,10623772,10623773,10623774,10623775,10623776,10623777,10623778,10623779,10623780,10623788,10623825,10623883,10623896,10623908,10623909,10623910,10623911,10623912,10623913,10623914,10623934,10623939,10623940,10623959,10623968,10623969,10623970,10623971,10623972,10623973,10623974,10623975,10623976,10623977,10623978,10623979,10623980,10623981,10623996,10624013,10624035,10624118,10624127,10624200,10624219,10624229,10624233,10624234,10624235,10624244,10624281,10624284,10624286,10624293,10624308,10624330,10624332,10624335,10624336,10624337,10624346,10624434,10624464,10624508,10624509,10624510,10624511,10624512,10624513,10624514,10624517,10624544,10624560,10624561,10624562,10624602,10624603,10624604,10624605,10624606,10624637,10624667,10624709,10624710,10624711,10624712,10624713,10624714,10624715,10624716,10624717,10624718,10624719,10624720,10624721,10624722,10624735,10624736,10624852,10624914,10624929,10624930,10621970,10621981,10621982,10621983,10621984,10621986,10621987,10621988,10621989,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10622012,10622013,10622014,10622015,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622023,10622024,10622025,10622026,10622027,10622028,10622029,10622030,10622031,10622032,10622033,10622034,10622035,10622036,10622037,10622038,10622039,10622040,10622041,10622042,10622043,10622044,10622045,10622046,10622047,10622048,10622049,10622050,10622051,10622052,10622053,10622054,10622055,10622056,10622057,10622058,10622059,10622060,10622061,10622062,10622063,10622064,10622065,10622066,10622067,10622068,10622069,10622070,10622071,10622072,10622073,10622074,10622075,10622076,10622077,10622078,10622079,10622080,10622081,10622082,10622083,10622084,10622085,10622086,10622087,10622088,10622089,10622090,10622091,10622092,10622093,10622094,10622095,10622096,10622097,10622098,10622099,10622100,10622101,10622102,10622103,10622104,10622105,10622106,10622107,10622108,10622109,10622110,10622112,10622113,10622114,10622115,10622116,10622117,10622118,10622119,10622120,10622121,10622122,10622123,10622124,10622125,10622126,10622127,10622128,10622129,10622130,10622131,10622132,10622155,10622156,10622157,10622187,10622197,10622258,10622264,10622265,10622267,10622268,10622273,10622283,10622288,10622301,10622347,10622394,10622409,10622414,10622447,10622480,10622514,10622518,10622521,10622522,10622525,10622542,10622628,10622629,10622658,10622666,10622667,10622669,10622670,10622671,10622672,10622673,10622686,10622689,10622690,10622692,10622701,10622703,10622711,10622712,10622753,10622754,10622755,10622756,10622810,10622817,10622830,10622887,10622894,10622896,10622919,10622924,10622937,10619969,10620032,10620057,10620058,10620059,10620063,10620071,10620085,10620148,10620149,10620165,10620183,10620215,10620220,10620241,10620242,10620253,10620254,10620290,10620297,10620298,10620304,10620305,10620308,10620321,10620322,10620326,10620337,10620342,10620346,10620347,10620348,10620349,10620350,10620351,10620352,10620353,10620354,10620355,10620356,10620357,10620358,10620359,10620360,10620361,10620362,10620363,10620364,10620365,10620366,10620367,10620368,10620369,10620370,10620371,10620372,10620373,10620374,10620375,10620376,10620377,10620378,10620379,10620380,10620381,10620382,10620383,10620384,10620385,10620386,10620387,10620388,10620389,10620390,10620391,10620392,10620393,10620394,10620395,10620396,10620397,10620398,10620399,10620400,10620401,10620402,10620403,10620404,10620405,10620406,10620407,10620408,10620409,10620410,10620411,10620412,10620413,10620414,10620415,10620416,10620417) 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'