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(8835846,8835854,10250104,10250105,8835900,10198157,10198158,10198159,10198166,8836027,8836029,7076030,7076031,7076032,7076033,7076034,8618409,7068176,10103835,10103836,10198505,10198514,4970738,10250741,10250742,10250743,10250744,10250745,10250746,10250747,8618924,8618932,8618933,7068615,7068616,10250859,10250860,10250861,7068628,7068629,7068630,7068641,7068642,7068678,7068683,4971029,7068696,7068699,10251070,10251071,10251072,10251073,10251074,10251075,10251076,10251077,10251078,10251079,10251080,10251081,10251082,10251083,10251084,10251085,10251086,10251087,10251088,10251089,10251090,10251091,10251092,7065866,10277716,10199766,7066649,7066710,10102517,10102518,10102756,10103021,8617796,8617797,8617800,8617803,8617810,8617812,8617813,8617952,10250041,10250042,10250043,8835809,10250044,10250045,10250046,8615195,10247070,10247071,6000126,10195092,10273329,10273330,10273331,10273332,10273333,10273334,10273335,7072248,10221489,10221490,7072255,10208567,10208568,10208604,10208605,10208606,10208607,10208608,10208609,10101302,10208911,8616119,8616121,10101539,10209154,10209155,10209164,10209165,10209166,10209231,10209257,10209261,10209366,7073137,7073138,7073139,7073140,7073141,7073142,10209381,10209397,10209398,10209399,10222403,10222434,7073196,7073197,10222435,7073198,10222436,10222459,10222460,10222461,10222462,10196487,10222491,10209607,10209608,10222619,10222620,10222621,10222622,10222623,10209640,7073425,10222710,10222711,10222712,10222713,10222714,10222715,10222716,10222717,10222718,10222719,10222720,10222721,10222722,10222723,10222724,10222725,10222726,10222727,10222728,10222729,10222730,10102190,10102203,10102209,10102215,7073628,10102307,7073688,7073716,7065800,8614182,8614197,10207081,10207082,10207083,10207084,10207085,10207086,8614226,10207122,10207123,10207124,10220161,10942642,10942662,10246221,10246222,8907592,7071016,7071017,7071018,7071049,10207337,10207338,10207339,10207340,10207367,10207368,10207392,10207415,10207416,10207417,10207453,10207489,10207490,10207538,10207539,10207540,10246619,10246620,10246621,10246622,10246623,7071392,10246635,10246636,10246637,10246638,10246639,10207715,10207716,8908064,10207717,8908078,8908079,8908080,8908081,8908082,7071546,10207821,10207822,10207849,10207850,5999975,10283062,10283063,10283064,10205113,10205133,10205158,10205204,10205205,10205206,10205207,10205208,10205209,10205210,10205211,10205212,10205213,10205214,10205215,10205216,10205217,10283219,10218311,10218312,10218313,10218314,10218315,10218316,10218317,10218318,10218319,10218320,10218321,10218322,8905742,10205408,10205409,10205410,10205411,10205412,10205413,10205414,10205415,10205416,10205417,7069226,7069233,7069239,7069241,7069319,8612858,8612859,8613093,8613097,8613099,8613109,8613110,8613121,8613144,10206205,10206206,8613336,8613341,8613348,10206229,10206230,8613363,10206245,10206246,10206247,10206248,10206249,10206250,10206251,10206252,8613379,8613393,8613394,10206285,10206286,10206287,10206288,10206289,10206290,10206291,10206292,10206293,10206294,10206295,10206296,10206297,10206298,10206299,10206300,10206301,10206302,7070070,7070102,10206416,10206417,10206418,10206419,10206420,10206421,10206456,10206564,10206565,10206566,10206586,10206587,10206588,10206589,10206590,10206620,10206621,10206675,10206695,10206696,10206750,10206751,10206752,8613938,8613939,8613940,8613942,8613943,8613953,10206832,10206833,10206834,10206835,8613963,8073464,8613984,8613988,8614009,10245889,10245890,10245891,10245892,8614036,8614044,8614054,10206972,8614119,10207011,10207012,10207013,10207014,10207015,10207016,10281784,8904210,8904211,8904266,8904330,8904331,10204298,10204574,10204575,10622039,10432078,10928227,10228930,8569898,8573697,8573698,10213260,10213261,10213262,10213263,10213264,10615202,8570164,10620352,8573924,10620372,8573935,10620390,10620391,10620392,8570223,8570224,8573971,10620411,8573972,10620415,10620424,8573994,8574031,8574032,8574088,8574107,10615553,10615554,8574127,8574150,8574151,8574152,8574153,8574157,8574169,10200798,10930731,10930918,8574974,8574975,8575012,8575147,8583696,9189551,9165554,9197671,9197672,9197673,9197674,9197675,9189710,9189711,9197756,9197773,9181881,9181904,8864497,10614643,10614644,9166007,8864592,9214088,9166112,10566098,10566099,9187493,7057681,10612269,9212103,9196219,9196220,9188255,9212312,7058538,7058539,8863111,8863121,8863125,8863168,8863174,8863175,8863239,9180866,9204930,10561747,10561748,10561749,10561750,10561751,10561752,10561753,10561754,9161353,9161363,9161365,10513435,10513436,10513437,10513438,10513439,10513440,10513441,9185660,9161749,9177769,10515732,10515733,10515734,7056228,7056235,9162421,9162422,2809331,10512846,10512847,9160362,10419306,10419350,9176430,9176431,9176432,9176481,9176482,9176483,10419539,10419540,10419541,10419542,10419543,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419551,10419552,10419553,10419554,9176668,4973679,4973680,4973681,9176954,9176972,9176977,4973894,4973993,9177172,9177173,9177174,9177175,9177176,9177177,9209254,4971347,4971348,4971349,4971351,4971353,4971357,4971358,4971359,4971477,4971478,4971503,4971529,4971530,9190694,4971573,4971574,4971575,4971581,4971582,4971583,4971584,4971600,4971601,4971602,4971633,4971634,10469487,10471524,10471525,9199068,8550414,8550415,9199276,9183333,9183334,8550500,9167407,8917167,8917168,10468113,4972429,4972436,4972442,4972443,4972454,10468179,9167625,4972478,9167626,9167788,8917694,8917695,4973150,8593571,10628215,10164809,10164810,10628295,10628311,10164891,10164892,10164893,10164894,10164895,10164896,10164897,10164898,10164899,10174952,10174953,10174954,10174955,10174956,10174957,10165013,10165017,10165018,10165019,10628510,10628511,10628512,10628513,8594119,8594120,10165138,10165139,10165140,10165141,10175142,10170273,10170328,10170329,10165343,10165353,10170354,10170355,10170356,10170387,10170388,10165402,10165403,10165404,10628890,10628891,10628926,10628927,10628928,10170451,10170452,10170453,10170454,10628944,10628952,10628953,10628954,10628955,10628956,10628957,10628958,10628959,10165489,10165490,10165491,10165492,10165493,10165494,10165495,10165496,10165497,10165498,10170550,10170573,10170574,10170616,10165655,10165656,10170680,10170703,10170704,10165844,10165845,10165846,10165847,10165848,10165899,10165923,10165924,10165925,10165926,10165927,10165928,10879932,10165972,10165973,10165974,10165975,10165976,10165977,10165978,10165979,10165980,10165981,10165982,10165983,10165984,10165985,10165986,10171004,10171021,10171056,10171079,10880214,10880218,10166236,10166237,10166393,10153848,10164114,10164115,10164116,10164117,10164118,10164119,10164120,10164121,10164122,10164123,10164124,10184193,10164361,10164362,10164363,10164364,10164365,10164366,10164367,10164368,10164369,10164370,10164371,10164372,10164373,10164374,10164375,10166535,10166536,10166537,10166555,10166556,10166557,10176578,10166593,10166594,10166629,10166630,10166631,10166649,10166650,10166651,10176679,10176680,10176681,10176682,10176683,10176684,10176685,10176686,10176687,10176688,10176689,10176690,10176691,10176692,10176693,10630189,10176736,10166784,10166795,10161865,10166875,10166876,10166884,10166885,10166907,10166910,10172022,10167031,10167056,10167057,10167058,10167122,10167133,10167153,10167158,10167159,10167160,10167203,10167216,10167217,10167218,10162254,10167270,10949096,10949102,10167305,10167355,10167470,10949986,10583441,10586600,10566114,10590265,10579012,10579013,10579450,10579451,10579452,10579453,10523116,10525130,10525133,10523481,10523482,10523527,10523528,10523529,10523530,10523531,10523532,10523533,10523534,10523535,10523536,10537564,10523594,10523595,10523596,10523597,10523598,10523599,10523600,10523601,10523602,10523603,10533955,10533956,10533957,10533958,10533959,10533960,10533961,10533962,10533963,10527968,10527969,10527970,10533973,10533974,10533975,10534166,10534167,10534168,10534169,10534170,10534171,10534172,10534173,10538276,10524290,10524399,10524721,10524722,10524723,10524724,10524725,10524733,10524734,10524735,10524736,10524737,10524738,10524739,10524740,10524741,10524742,10524753,10524754,10528795,10523031,10523053,10525106,10525107,10525108,10525109,10525110,10525111,10424313,10424314,10424315,10424316,10424317,10424318,10424319,10424320,10424321,10423403,10423404,10423470,10498372,10498378,10423205,10423206,10423207,10423208,10481012,10481025,10484039,10481047,10481048,10481049,10486050,10481050,10486051,10486052,10486053,10486054,10479108,10479109,10477214,10481268,10481269,10481270,10481271,10481272,10481273,10481274,10481494,10481495,10481549,10481641,10481756,10481757,10481758,10481759,10481891,10477893,10481947,10478003,10478162,10478202,10478259,10478260,10478267,10478560,10478561,10478562,10478710,10478711,10482804) 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'