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(4970203,4970403,4970404,4970410,4970411,4970412,4970413,4970414,4970415,4970416,4970417,4970418,4970419,4970420,4970421,4970422,4970423,4970424,4970425,4970426,4970427,4970428,4970431,4970432,4970437,4970440,4970441,4970442,4970443,4970444,4970445,4970446,4970447,4970448,4970449,4970522,4970523,4970524,4970525,4970526,4970527,4970634,4970635,4970636,4970646,4970649,4970650,4970652,4970654,4970657,4970658,4970667,4970676,4970683,4970685,4970700,4970705,4970712,4970715,4970716,4970717,4970718,4970739,4970760,4970762,4970763,4970764,4970765,4970766,4970771,4970787,4970842,4970843,4970844,4970854,4970855,4970856,4970880,4970895,4970915,4970962,4971023,4971024,4971113,4971114,4971140,4968168,4968219,4968237,4968409,4968452,4968453,4968454,4968475,4968476,4968630,4968631,4968632,4968644,4968648,4968649,4968650,4968664,4968665,4968666,4968667,4968816,4968817,4968818,4968819,4968820,4968821,4968822,4968848,4969003,4969009,4969018,4969019,4969020,4969021,4969022,4969023,4969024,4969025,4969026,4969027,4969028,4969061,4969062,4969063,4969064,4969065,4969066,4969067,4969126,4969160,4969161,4969200,4969204,4969299,4969348,4969349,4969350,4969351,4969352,4969353,4969354,4969355,4969356,4969362,4969363,4969500,4969504,4969517,4969518,4969549,4969996,4969997,4969998,4969999,4970000,4970001,8075040,8075041,8075042,8075043,8075044,8075045,8075058,8075059,8075060,8075061,8075062,8075063,8075086,8075087,8075088,8075089,8075090,8075091,8075105,8075106,8075107,8075108,8075109,8075110,8075128,8075129,8075130,8075131,8075132,8075133,8075134,8075135,8075136,8075137,8075138,8075139,8075140,8075141,8075142,8075143,8075144,8075145,8075146,8075147,8075148,8075149,8075150,8075151,8075152,8075153,8075154,8075155,8075156,8075157,8075158,8075159,8075160,8075161,8075162,8075163,8075164,8075165,8075166,8075167,8075168,8075169,8075170,8075171,8075172,8075173,8075174,8075175,8075176,8075177,8075178,8075179,8075180,8075181,8075182,8075183,8075184,8075185,8075186,8075187,8075188,8075189,8075190,8075191,8075192,8075193,8075194,8075195,8075196,8075197,8075198,8075199,8075200,8075201,8075202,8075203,8075204,8075205,8075206,8075207,8075208,8075209,8075210,8075211,8075212,8075213,8075245,8075246,8075250,8075251,8075252,8075253,8075254,8075255,8075256,8075269,8075288,4967030,4967031,4967062,4967073,4967074,4967075,4967076,4967389,4967418,4967514,4967858,4967863,4967864,4967867,4967870,4967871,4967878,4967879,4967880,4967881,4967882,4967884,4967898,4967899,8073947,8073948,8073949,8073950,8073951,8073952,8073953,8073954,8073955,8073956,8073957,8073958,8073959,8073960,8073961,8073962,8073963,8073964,8073965,8073966,8073967,8073968,8073969,8073970,8073971,8073972,8073973,8073974,8073975,8073976,8073977,8073978,8073979,8073980,8073981,8073982,8073983,8073984,8073985,8073986,8073987,8073988,8073989,8073990,8073991,8073992,8073993,8073994,8073995,8073996,8073997,8073998,8073999,8074000,8074001,8074002,8074003,8074004,8074005,8074006,8074007,8074008,8074009,8074010,8074011,8074012,8074013,8074014,8074015,8074016,8074017,8074018,8074019,8074020,8074021,8074022,8074023,8074024,8074025,8074026,8074027,8074028,8074029,8074030,8074031,8074032,8074033,8074034,8074035,8074036,8074123,8074124,8074125,8074126,8074127,8074128,8074129,8074130,8074131,8074132,8074133,8074134,8074135,8074136,8074137,8074138,8074139,8074140,8074141,8074142,8074143,8074144,8074145,8074146,8074147,8074148,8074149,8074150,8074151,8074152,8074153,8074154,8074155,8074156,8074157,8074158,8074159,8074160,8074161,8074162,8074163,8074164,8074165,8074166,8074167,8074168,8074169,8074170,8074171,8074172,8074173,8074174,8074175,8074176,8074177,8074178,8074179,8074180,8074181,8074182,8074183,8074184,8074185,8074186,8074187,8074188,8074189,8074190,8074191,8074192,8074193,8074194,8074195,8074196,8074197,8074198,8074199,8074200,8074201,8074202,8074203,8074204,8074205,8074206,8074207,8074208,8074209,8074210,8074211,8074307,8074308,8074309,8074310,8074311,8074312,8074313,8074314,8074315,8074316,8074317,8074318,8074319,8074320,8074321,8074322,8074323,8074324,8074325,8074326,8074327,8074328,8074329,8074330,8074331,8074332,8074333,8074334,8074335,8074336,8074337,8074338,8074339,8074340,8074341,8074342,8074343,8074344,8074345,8074346,8074347,8074348,8074349,8074350,8074351,8074352,8074353,8074354,8074355,8074356,8074357,8074358,8074359,8074360,8074361,8074362,8074363,8074364,8074365,8074366,8074367,8074368,8074369,8074370,8074371,8074372,8074373,8074374,8074375,8074376,8074377,8074378,8074379,8074380,8074381,8074382,8074383,8074384,8074385,8074386,8074387,8074388,8074389,8074390,8074391,8074392,8074393,8074394,8074395,8074396,8074397,8074398,8074399,8074400,8074401,8074402,8074403,8074404,8074405,8074406,8074407,8074408,8074409,8074410,8072309,8072310,8072385,8072494,8072495,8072496,8072497,8072498,8072499,8072500,8072501,8072502,8072503,8072504,8072505,8072577,8072578,8072733,8072734,8072735,8072736,8072737,8072780,8072845,8072846,8072847,8072848,8072849,8072850,8072851,8072852,8072853,8072854,8072855,8072856,8072857,8072858,8072859,8072860,8072861,8072862,8072863,8072864,8072940,8072947,8072984,8072985,8072986,8072987,8072988,8072989,8073009,8073010,8073012,8073014,8073462,8073519,8073528,8073533,8073534,8073535,8073536,8073537,8073538,8073539,8073540,8073541,8073542,8073543,8073544,8073545,10622987,10623038,10623051,10623101,10623185,10623186,10623187,10623188,10623189,10623190,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623330,10623377,10623378,10623379,10623380,10623381,10623382,10623383,10623384,10623385,10623424,10623486,10623487,10623490,10623494,10623504,10623557,10623605,10623606,10623676,10623823,10623824,10623825,10623924,10623928,10623929,10623931,10623970,10623971,10623972,10623973,10623974,10623975,10623976,10623977,10623978,10623994,10624272,10624276,10624277,10624278,10624283,10624285,10624288,10624335,10624388,10624434,10624435,10624436,10624437,10624529,10624530,10624531,10624532,10624548,10624698,10624838,10624839,10624840,10624898,10624899,10624900,10624905,10624908,10624909,10624953,10624954,10624955,10624956,10624957,10624958,10624959,10624960,10621977,10621981,10621982,10621983,10621985,10621987,10621992,10621994,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622009,10622013,10622014,10622015,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622023,10622024,10622025,10622027,10622028,10622029,10622030,10622031,10622033,10622034,10622035,10622036,10622038,10622040,10622041,10622042,10622044,10622046,10622047,10622048,10622049,10622050,10622051,10622053,10622054,10622055,10622057,10622059,10622061,10622062,10622063,10622064,10622065,10622066,10622067,10622072,10622073,10622074,10622075,10622076,10622077,10622082,10622083,10622084,10622085,10622086,10622087,10622088,10622089,10622090,10622093,10622095,10622096,10622099,10622100,10622102,10622103,10622104,10622105,10622116,10622117,10622118,10622119,10622120,10622121,10622123,10622125,10622126,10622127,10622128,10622129,10622130,10622131,10622132,10622137,10622138,10622139,10622187,10622210,10622235,10622256,10622267,10622284,10622302,10622311,10622312,10622313,10622353,10622402,10622409,10622411,10622412,10622414,10622427,10622428,10622429,10622430,10622503,10622504,10622518,10622519,10622521,10622522,10622530,10622531,10622665,10622666,10622667,10622668,10622669,10622670,10622671,10622672,10622673,10622674,10622675,10622677,10622678,10622679,10622680,10622681,10622711,10622712,10622713,10622714,10622715,10622716,10622717,10622718,10622719,10622720,10622729,10622730,10622818,10622819,10622820,10622907,10622908,10620070,10620126,10620127,10620255,10620256,10620257,10620258,10620259,10620302,10620305,10620323,10620324,10620325,10620346,10620347,10620348,10620352,10620353,10620354,10620355,10620356,10620357,10620358,10620359,10620360,10620361,10620365,10620366,10620367,10620370,10620371,10620372,10620375,10620378,10620379,10620380,10620381,10620382,10620383,10620384,10620385,10620386,10620387,10620388,10620389,10620393,10620394,10620397,10620398,10620399,10620400,10620401,10620402,10620403,10620404,10620405,10620409,10620410,10620414,10620416,10620417,10620418,10620419,10620420,10620423,10620424,10620425,10620549,10620550,10620551,10620552,10620553,10620554,10620555,10620556,10620557,10620558,10620583,10620664,10620714,10620715) 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'