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(4970745,4970824,4970825,4970826,4970827,4970828,4970829,4970830,4970831,4970832,4970833,4970834,4970835,4970836,4970837,4970838,4970839,4970840,4970841,4970842,4970843,4970844,4970845,4970846,4970847,4970848,4970849,4970850,4970851,4971029,4971060,4971061,4971062,4971063,4971064,4971066,4968443,4969378,4969379,4969381,4969383,4969493,4969494,4969495,4969496,4969497,4969498,4969499,4969500,4969501,4969502,4969503,4969504,4969505,4969506,4969507,4969508,4969509,4969510,4969511,4969512,4969513,4969514,4969515,4969516,4969517,4969518,4969519,4969520,4969521,4969522,4969523,4969524,4969548,4969570,8075284,8075293,8075298,8075339,8075340,4967027,4967028,4967029,4967030,4967061,4967062,4968029,4968072,4968073,8073017,8073022,8073030,10622990,10623002,10623048,10623049,10623050,10623057,10623102,10623103,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623303,10623481,10623482,10623492,10623493,10623495,10623496,10623497,10623498,10623499,10623500,10623501,10623502,10623503,10623504,10623505,10623506,10623507,10623508,10623582,10623639,10623658,10624544,10624575,10624709,10624710,10624712,10624714,10624716,10624717,10624718,10624720,10624721,10624722,10624726,10624727,10624728,10624729,10624730,10624731,10624732,10624734,10624738,10624740,10624802,10624804,10624841,10624843,10624897,10624914,10621981,10621990,10621991,10621993,10621994,10621995,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622015,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622023,10622024,10622025,10622026,10622027,10622028,10622029,10622030,10622031,10622037,10622038,10622039,10622040,10622041,10622042,10622044,10622045,10622046,10622047,10622048,10622051,10622052,10622053,10622054,10622056,10622057,10622058,10622059,10622061,10622062,10622063,10622064,10622065,10622066,10622067,10622068,10622069,10622070,10622072,10622073,10622074,10622075,10622076,10622077,10622078,10622079,10622080,10622081,10622082,10622083,10622084,10622086,10622087,10622088,10622089,10622090,10622091,10622092,10622093,10622094,10622095,10622096,10622097,10622098,10622103,10622106,10622107,10622108,10622109,10622110,10622122,10622132,10622139,10622540,10622672,10622673,10622674,10622675,10622714,10622773,10622774,10622776,10622777,10622778,10622881,10622882,10622883,10622884,10622885,10622886,10622887,10622888,10622889,10622890,10622891,10622892,10622893,10622894,10622895,10622896,10622897,10622898,10622899,10622900,10622901,10619962,10619977,10619978,10619982,10620083,10620098,10620106,10620128,10620175,10620201,10620202,10620207,10620209,10620235,10620236,10620237,10620238,10620297,10620298,10620300,10620303,10620304,10620322,10620352,10620353,10620354,10620357,10620361,10620365,10620372,10620379,10620380,10620390,10620391,10620392,10620393,10620394,10620395,10620396,10620397,10620398,10620399,10620400,10620411,10620415,10620416,10620417,10620418,10620424,10620425,10620662,10620677,10620678,10620679,10621033,10621034,10621036,10621037,10621038,10621039,10621040,10621041,10621044,10621046,10621049,10621050,10621077,10621078,10621160,10621235,10621238,10621245,10621246,10621247,10621250,10621254,10621256,10621257,10621263,10621269,10621270,10621271,10621289,10621292,10621293,10621296,10621297,10621306,10621314,10621315,10621319,10621321,10621333,10621334,10621338,10621350,10621352,10621353,10621354,10621355,10621370,10621372,10621375,10621387,10621388,10621397,10621403,10621404,10621406,10621407,10621410,10621411,10621419,10621421,10621428,10621429,10621430,10621431,10621444,10621459,10621463,10621480,10621481,10621482,10621510,10621515,10621517,10621522,10621528,10621535,10621536,10621569,10621580,10621626,10621629,10621718,10621722,10621723,10621731,10621748,10565120,10565121,10565122,10565123,10565124,10565125,10565126,10565128,10565130,10565133,10565134,10565135,10565136,10565137,10565138,10565139,10565140,10565141,10565143,10565144,10565145,10565146,10565147,10565150,10565152,10565155,10565157,10565158,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565169,10565172,10565173,10565175,10565176,10565184,10565185,10565186,10565187,10565188,10565189,10565190,10565191,10565192,10565193,10565194,10565195,10565196,10565197,10565198,10565199,10565200,10565201,10565202,10565203,10565204,10565205,10565206,10565207,10565208,10565209,10565210,10565211,10565212,10565213,10565214,10565215,10565216,10565217,10565218,10565219,10565220,10565221,10565222,10565223,10565224,10565225,10565226,10565227,10565228,10565229,10565230,10565231,10565232,10565233,10565234,10565235,10565236,10565237,10565238,10565239,10565240,10565241,10565242,10565243,10565244,10565245,10565246,10565247,10565248,10565249,10565250,10565251,10565252,10565253,10565254,10565255,10565256,10565257,10565258,10565259,10565260,10565261,10565262,10565263,10565264,10565265,10565266,10565267,10565268,10565269,10565270,10565271,10565272,10565273,10565274,10565275,10565276,10565277,10565278,10565279,10565280,10565281,10565282,10565283,10565284,10565285,10565286,10565287,10565288,10565289,10565290,10565291,10565292,10565293,10565294,10565295,10565296,10565297,10565298,10565299,10565300,10565303,10565304,10565305,10565306,10565307,10565308,10565309,10565310,10565311,10565312,10565313,10565314,10565315,10565316,10565317,10565318,10565319,10565320,10565321,10565322,10565323,10565324,10565325,10565326,10565327,10565328,10565329,10565330,10565331,10565332,10565333,10565344,10565345,10565349,10565350,10565351,10565352,10565353,10565354,10565355,10565356,10565357,10565358,10565359,10565360,10565361,10565362,10565363,10565364,10565365,10565366,10565367,10565368,10565369,10565370,10565371,10565372,10565373,10565374,10565375,10565376,10565377,10565378,10565379,10565380,10565381,10565382,10565383,10565384,10565385,10565386,10565387,10565388,10565389,10565390,10565391,10565392,10565393,10565394,10565395,10565396,10565397,10565398,10565399,10565400,10565401,10565402,10565403,10565404,10565405,10565406,10565407,10565408,10565409,10565410,10565411,10565412,10565413,10565414,10565415,10565416,10565417,10565418,10565419,10565420,10565421,10565422,10565423,10565424,10565425,10565426,10565427,10565428,10565429,10565430,10565431,10565432,10565433,10565434,10565435,10565436,10565437,10565438,10565439,10565440,10565441,10565442,10565443,10565444,10565445,10565446,10565447,10565448,10565449,10565450,10565451,10565452,10565453,10565454,10565455,10565456,10565457,10565458,10565459,10565460,10565461,10565462,10565463,10565464,10565465,10565466,10565467,10565468,10565469,10565470,10565471,10565472,10565473,10565474,10565475,10565476,10565477,10565478,10565479,10565480,10565481,10565482,10565483,10565484,10565485,10565486,10565487,10565488,10565489,10565490,10565491,10565492,10565493,10565494,10565495,10565496,10565497,10565498,10565499,10565500,10565501,10565502,10565503,10565504,10565505,10565506,10565507,10565508,10565509,10565510,10565511,10565512,10565513,10565514,10565515,10565516,10565517,10565518,10565519,10565520,10565521,10565522,10565523,10565524,10565525,10565526,10565527,10565528,10565529,10565530,10565531,10565532,10565533,10565534,10565535,10565536,10565537,10565538,10565539,10565540,10565541,10565542,10565543,10565544,10565545,10565546,10565547,10565548,10565549,10565550,10565551,10565552,10565553,10565554,10565555,10565556,10565557,10565558,10565559,10565560,10565561,10565562,10565563,10565564,10565565,10565566,10565567,10565568,10565569,10565570,10565571,10565572,10565573,10565574,10565575,10565576,10565577,10565578,10565579,10565580,10565581,10565582,10565583,10565584,10565585,10565586,10565587,10565588,10565589,10565590,10565591,10565592,10565593,10565594,10565595,10565596,10565597,10565598,10565599,10565600,10565601,10565602,10565603,10565604,10565605,10565606,10565607,10565608,10565609,10565610,10565611,10565612,10565613,10565614,10565615,10565616,10565617,10565618,10565619,10565620,10565621,10565622,10565623,10565624,10565625,10565626,10565627,10565628,10565629,10565630,10565631,10565632,10565633,10565634,10565635,10565636,10565637,10565638,10565639,10565640,10565641,10565642,10565643,10565644,10565645,10565646,10565647,10565649,10565650,10565651,10565652,10565653,10565654,10565655,10565656,10565657,10565658,10565659,10565660,10565661,10565662,10565663,10565664,10565665,10565666,10565667,10565668,10565669,10565670,10565671,10565672,10565674,10565675,10565676,10565677,10565678,10565679,10565680,10565681,10565682,10565683,10565684,10565685,10565686,10565687,10565688,10565689,10565690,10565691,10565692,10565693,10565694,10565695,10565696,10565697,10565698,10565699,10565700,10565701,10565702,10565703,10565704,10565705,10565706,10565707,10565708,10565709,10565710,10565711,10565712,10565713,10565714,10565715,10565716,10565717,10565718,10565719,10565720,10565721,10565722,10565723,10565724,10565725,10565726,10565727,10565728,10565729,10565730,10565731) 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'