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(8068868,10943425,10943460,4970718,4970750,4970859,4970916,4970930,4970931,4970932,4970933,4970934,4970935,4970936,4970937,4970939,4970976,10944268,10944278,4971156,4971157,4971158,4968602,4968603,10437408,10437492,10437537,10437538,10437539,10437608,10437609,10437744,4969285,4969286,4969287,4969288,8067941,8067952,8067953,8067954,8067955,8067968,8067969,8067970,8067971,8067999,8068003,8068004,8068005,8068018,8068019,8068020,8068021,8068022,8068023,8068024,8068087,8068088,8068089,8068109,8068110,8068111,8068112,8068113,8068173,8068174,8068175,8068176,8068212,8068213,8068214,8068215,8068216,8068267,8068284,8068306,8068335,8068336,8068337,8068338,8068339,8068361,8068362,8068429,8068449,8068452,8068457,8068471,8068477,8068478,8068480,8068485,8068486,8068487,8068488,8068489,8068493,8068494,8068495,8068496,8068509,8068510,8068511,8068512,8068513,8068514,8068559,8068560,8068561,8068562,8068563,8068564,8068565,8068598,8068599,8068603,8068605,8068612,8068659,8068662,8068667,8068668,8068680,8068689,8068695,8068706,8068712,8068713,8068720,8068729,8068730,8068731,8068732,8068733,8068734,8068735,8068736,8068737,8068738,8068739,8068740,8068741,8068742,8068743,8068744,8068745,8068748,8068753,8068754,8068755,8068756,8068757,8068758,8068759,8068760,8068761,8068762,10931517,10931525,10931682,10931683,10932071,10932104,4967032,10932203,10932260,10932360,10932361,10932410,10932411,10932412,10932413,10932414,10932415,10932416,10932492,10932518,10932580,10932581,10932582,10932585,10932586,10932587,10932601,10932602,10932679,10932688,10932739,10932838,10932839,10932840,10933253,10942736,10942776,10942785,10942798,10942799,10942800,10942801,10942827,10942860,10942889,10942913,10942926,10942927,10942963,10942964,10942966,10942967,10942981,10942982,10942988,10942989,10942990,10943010,10943016,10943020,10943044,10943050,10943051,10943060,10943076,10943085,10943120,10943192,10943196,10943197,10943366,10943413,10943414,10943418,10943423,10940552,10940558,10940563,10940564,10940571,10940719,10940720,10940721,10940722,10940804,10940821,8072357,8072358,8072359,8072360,8072361,8072362,8072363,8072364,8072365,8072366,8072367,8072375,8072376,8072377,8072378,8072379,8072380,8072381,8072382,8072383,8072386,8072387,8072388,8072389,8072390,8072391,8072392,8072393,8072394,8072395,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,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,8072470,8072471,8072668,8072669,8072670,8072671,8072672,10941742,10941743,10941805,10941826,10941848,10941854,10941856,10941857,10941858,10941864,10941873,8073022,10941884,8073023,10941891,10941894,10941909,10941914,10941915,10941927,10941930,10941936,10941937,8073076,10941940,8073083,10941955,10941957,10941965,10941969,10941972,10941974,10941978,10941980,10941982,10941986,10941994,10942063,10942073,10942230,10942232,10942233,10942234,10942237,10942238,10942247,10942248,8073440,10942318,10942408,10942415,10942418,10942431,10942494,10942495,10942501,10942503,10942518,10942519,10942520,10942526,10923531,10923532,10923541,10923558,10923615,10923623,10923624,10923628,10923635,10923636,10923637,10923638,10923639,10923640,10923641,10923642,10923643,10923644,10923708,10923709,10923710,10923711,10923712,10923713,10923714,10923715,10923716,10923717,10923718,10923719,10923720,10923731,10923732,10923733,10923825,10923826,10923827,10923828,10623317,10923880,10923881,10623411,10923944,10923945,10923946,10923947,10923948,10923949,10923950,10923951,10923952,10923953,10923967,10923968,10923969,10923970,10923971,10923972,10923973,10924031,10924032,10924033,10924034,10924035,10924051,10924052,10924053,10924054,10924055,10924118,10924119,10924120,10924121,10924122,10924123,10924124,10924125,10924126,10924219,10924251,10924252,10924280,10924281,10924285,10924286,10924287,10924316,10924340,10924341,10924342,10924343,10924344,10924345,10924346,10924347,10924348,10924349,10924350,10924351,10924352,10924353,10924354,10924355,10924356,10924357,10924358,10924359,10924360,10924361,10924362,10924363,10924364,10924365,10924366,10924367,10924368,10924369,10924370,10924371,10924372,10924373,10924374,10924375,10924376,10924377,10924378,10924379,10924380,10924381,10924382,10924383,10924384,10924385,10924386,10924387,10924388,10924389,10624056,10624057,10924577,10924578,10924579,10924600,10924601,10924602,10924603,10924604,10924605,10924606,10924607,10924608,10924609,10924610,10924611,10924612,10924852,10924853,10924854,10924855,10924859,10924860,10924861,10924862,10924863,10924864,10924865,10924866,10924867,10924868,10924869,10924870,10924871,10924872,10924873,10924874,10924969,10924970,10924971,10924972,10924973,10924974,10924975,10924976,10924993,10924994,10924995,10924996,10924997,10924998,10924999,10925000,10925001,10925099,10925100,10925105,10925106,10925107,10925108,10925125,10925126,10925127,10925141,10925148,10925149,10925150,10925178,10925179,10925180,10925181,10925182,10925215,10925216,10925224,10925225,10925226,10925227,10925228,10925229,10925230,10925231,10925232,10925233,10925234,10925235,10925236,10925237,10925238,10624802,10925378,10925434,10621985,10621989,10622011,10622014,10622055,10622060,10622071,10622115,10922640,10922641,10922642,10922705,10922706,10922707,10922708,10922717,10922723,10922727,10922728,10922729,10922820,10922861,10622344,10922919,10922928,10922959,10923003,10923019,10923020,10923025,10923026,10923029,10622543,10923062,10923063,10923088,10923090,10923108,10923109,10923115,10923116,10923123,10923144,10923174,10923175,10923190,10923191,10923208,10923225,10923226,10923227,10923228,10923268,10923273,10923341,10923396,10620183,10620186,10620187,10620188,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620207,10620208,10920745,10620307,10620351,10620381,10620382,10620384,10620385,10620386,10620387,10920913,10920914,10920915,10920916,10920917,10920918,10920919,10920920,10920921,10920922,10920923,10920924,10920925,10920926,10920927,10920928,10920929,10920930,10920931,10620414,10920932,10920933,10920934,10920935,10920936,10920937,10920938,10920939,10920940,10920941,10920942,10920943,10920944,10920945,10920946,10920947,10920948,10920949,10920950,10920951,10920952,10920953,10920961,10920962,10920963,10620491,10620653,10620654,10620655,10620656,10620657,10620658,10620659,10620660,10620661,10620662,10620663,10620664,10620665,10620666,10620667,10620668,10620669,10620670,10921339,10921340,10921341,10921342,10921343,10921382,10921383,10921384,10921392,10921393,10921394,10921395,10921407,10921472,10921473,10921474,10921475,10921519,10921520,10921521,10921522,10921523,10921609,10621109,10921636,10921667,10621273,10621274,10621294,10921815,10921816,10921817,10921818,10921819,10921820,10921821,10921822,10621310,10621323,10621341,10621345,10621346,10621347,10621348,10621352,10621353,10621354,10621355,10621360,10621361,10921883,10921884,10921885,10921886,10921887,10921888,10621375,10621381,10621382,10621400,10621401,10621402,10621403,10621404,10621405,10621422,10621426,10621428,10621429,10621435,10621436,10621445,10621446,10621447,10621453,10621456,10621461,10621465,10621529,10621564,10621572,10621595,10621601,10621615,10621620,10621631,10621632,10621637,10621639,10621641,10621649,10621655,10621668,10621672,10621675,10621717,10621724,10621732,10621958,10565445,10565446,10565447,10565448,10565449,10563370,10563371,10563372,10563373,10563377,10563378,10563379,10563380,10563381,10564653,10564654,10564713,10564714,10564766,10564767,10564768,10564769,10564825,10517259,10517260,10517634,10517635,10517677,10517678,10517679,10518077,10518078,10518079,10518080,10518081,10518082,10519052,10519089,10419242,10419271,10419385,10419543,10419556,10419562,10419563,10419693,10419694,10419695,10419696,10419697,10419698,10419699,10419700,10419701,10419702,10419796,10419797,10419823,10419824,10419825,10419826,10419827,10419882,10419884,10420102,10420108,10420142,10420171,10420172,10471083,10471482,10471483,10469911,10469920,10470212,10470213,10470233,10470271,10470272,10470273,10470274,10470275,10470276,10470277,10470278,10470279,10470280,10470281,10470282,10470283,10470284,10470285,10470286,10470287,10470288,10470289,10470290,10470291,10470292,10470293,10470294,10470295,10470296,10470297,10470298,10470299,10470300,10470301,10470302,10470303,10470304,10470305,10470306,10470307,10470308,10470309,10470310,10470311,10470378,10470379,10470482,10470487,10470666) 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'