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(10447933,10939915,8574560,8574561,4970881,4970882,4970883,4970884,4970885,4970886,4970887,4970888,4970889,4970890,4970891,4970892,10846457,4970974,4970975,10846554,10940465,10976539,4971128,7074341,7074393,7074398,7074402,7074454,7074457,7074485,10437347,7074572,7074631,10437497,10951273,8575846,8575847,8575865,8575866,8068018,8068019,8068020,8068021,8068022,8068023,8068024,8068025,8068026,8068027,8068028,8068029,8068030,8068031,8068032,8068033,8068034,8068035,8068036,8068037,8068038,8068039,8068040,8068041,8068042,8068043,8068044,8068045,8068046,8068047,8068048,8068049,8068050,8068051,8068052,8068053,8068054,8068055,8068056,8068057,8068058,8068059,8068060,8068061,8068062,8068063,8068064,11001190,10845288,10845289,10845299,10845300,10845304,10845305,10845311,10845312,10845315,10845316,10845317,10845318,10845330,10845333,10845334,10962283,10962284,10962285,10962286,10962287,10962288,10962289,10962290,7067615,11001376,8620615,8620616,10962535,8068807,7071965,10103115,8835475,8835476,8835477,8835478,8835479,8618068,8618069,8618071,8618072,10103669,10932013,10932068,10932069,10999497,8618689,8618694,8618696,8618697,8618700,8618708,8618718,8618719,8618720,8618723,8618724,8618725,8618726,8618727,8618728,8836459,10843759,10843879,10843880,10843881,10843882,10843883,10843884,10843937,10843938,10843939,10843940,10932617,10932625,10932634,8066268,8066269,8066270,8066271,8066272,8066273,8066274,8066275,8066276,8066277,10932648,8066278,8066279,8066280,8066281,8066282,8066283,8066284,10932654,8066285,10932661,10932674,10932676,10932684,7073342,10932692,7202604,8836932,8836933,8836934,10932984,10987338,10961368,10961369,10961370,10961371,10497617,10497618,10497619,10497620,10497621,10497622,10497623,10497624,10497625,10497626,10497627,10497628,10497629,10497630,10497631,10497632,10497633,10497634,10497635,10497636,10497637,10497638,10497639,10497640,10497641,10497642,10497643,10497644,10497645,10497646,10497647,10497648,10497649,10497650,10497651,10497652,10497653,10497654,10497655,10497656,10497657,10497658,10497659,10497660,10497661,10497662,10497663,10497664,10497665,10497666,10497667,10497668,10497669,10942600,8616947,8616948,10997884,10997885,10997886,10997887,10997888,10997889,10997890,10997891,11036994,11049221,11049316,10998208,10998209,10998210,10998211,11037235,11037242,7071570,7071571,7071577,7071580,7071581,10842485,10931198,7071883,7071884,10103049,10103050,10103051,10100117,10100118,10944759,8072304,8072648,8072649,8072650,10101046,8072651,8072652,8615839,8615840,8615841,8564782,8564783,8072825,8072826,8072827,8615929,8072828,8615930,8072829,8072830,8615931,8072831,8072832,8565007,8565008,8565025,8073096,8565255,11010231,11010232,11010240,11010241,11010242,11010281,11010286,4936817,4936889,4936890,4937059,4937071,4937083,10955050,10955051,4937095,10618879,8613763,8071020,4938043,8071100,8071101,8071102,10839271,11008240,11008241,11008242,8071308,8071309,11008265,11008266,11008267,11008268,11008269,11008270,11008271,11008272,8071326,8071342,8071354,4938352,4938353,4938354,4938355,4938356,4938521,4938522,4938523,4938524,4938525,4938526,10624841,10925450,10427320,10922605,10922640,10922641,10922642,10922643,10922644,10922645,10922646,10922647,8611947,10922648,10922649,10922650,10922651,10922652,10922653,10922654,10922655,10922656,10922657,10922658,10922659,10922660,10922661,10836878,10922662,10922663,10922664,10922665,10922666,10922667,10966978,10837046,8576339,10952137,10952138,10952139,10930752,10978842,10978843,10978844,10978845,10978846,10978847,10978848,10978849,10978850,10978851,10978852,10978853,10952900,10952901,10952913,10621265,10621266,10621267,10621268,10621269,10621270,10621271,10621272,10426804,10922270,10922271,8578019,8578020,8611740,9205407,9205408,9205412,9165710,10714297,8864358,8864359,8864375,8864376,8864451,10559875,10559876,10559877,10559878,10559879,10559880,10559881,10559882,10559883,10559884,10559885,10559886,10559887,10559888,10614742,9171882,9171883,9171884,9212220,10561424,10561425,10561426,10561427,10561428,7058816,7058817,9172761,10564614,10564615,10564616,10564617,8863334,8863335,10564627,8863336,10564628,8863337,8863338,10564629,10564630,8863339,8863340,8863341,8863342,8863343,8863344,8863345,8863346,8863347,8863348,8863349,8863350,8863351,8863352,8863353,8863354,8863355,10564647,8863356,10564648,8863357,8863358,8863359,8863360,8863361,8863362,8863363,8863364,8863365,8863366,8863367,8863368,8863369,8863370,8863371,8863372,8863373,10564684,10564685,10564699,10564700,10564701,10564702,10564740,10564741,10564742,10564743,10564744,10564745,10564746,10564747,10564748,10564810,10564811,10564812,10564813,10564814,10564815,10564816,10564817,10564818,10564819,10613745,9197151,9197152,9197153,9197154,9197155,9205202,9205203,7055779,7055780,7055781,7055868,7056312,7056313,7056314,7056315,7056316,7056317,7056318,7056319,7056320,4975082,4975083,4975084,9178898,9178899,9178900,9178901,9178902,9178903,9178904,9178905,9178906,9178907,9178908,9210912,10119328,9171172,9171173,9171174,9171175,9171176,9171177,9171178,9171179,9171180,9171181,9171182,9171183,9171184,9171185,9171186,10415288,10415289,9160448,9160449,9160450,9160451,9160458,9160459,9160460,4973495,4973496,4973497,4973498,4973499,4973502,7054884,7054885,7054886,7054887,7054888,7054889,10415852,10415853,10415854,10416126,9190420,9198429,9198491,9198505,9198508,9198509,9198518,9198519,9198520,9198521,9198522,9198523,9198524,9198543,9198546,9198548,9206587,9206588,10471493,10471494,10471495,10471499,10471500,10471501,10471502,10471503,10471505,6666960,9190962,9190963,9190964,9190965,9190966,9190967,8916898,4972125,4972126,4972127,4972128,4972129,10115669,8550812,8917366,8917372,9167785,8551000,8551147,9168165,8593490,10627977,10174561,8593598,8593599,8593600,8593601,8593602,8593603,8593604,8593605,8593606,8593607,8593608,8593609,8593610,8593611,8593612,8593613,8593614,8593615,8593616,8593617,8593618,8593619,8593620,8593621,8593622,8593623,8593624,8593625,8593626,8593627,8593628,8593629,8593630,8593631,8593632,8593633,8593634,8593635,8593636,8593637,8593638,8593639,8593640,8593641,8593642,8593643,8593644,10628454,10628455,10175655,10175656,10175657,10175658,10175659,8068995,10175718,10175719,10175720,10175721,10175722,10175777,10175778,10175779,10175792,10175793,10175794,10175795,10175796,10175806,10175807,10175808,10175809,10175815,8069140,8069141,8069142,8069143,8069144,8069236,8069237,8069238,10156210,10875260,10173540,10627150,10627151,10627152,10627153,10627154,10627216,10627217,10627218,10154004,10174215,10174216,10174252,10174291,10174333,10174334,10174335,10174336,10949169,10949170,10949171,10949172,10949173,10949174,10949175,10949176,10949177,10949178,10163093,10173157,10173158,10173159,10173160,10173161,10173162,10173163,10173164,10173165,10173166,10173167,10173168,10173169,10173170,10168228,10168229,10168230,10168231,10168232,10168233,10168234,10168235,10168236,10168237,10168238,10168239,10168240,10950040,10168241,10168242,10168243,10168244,10168245,10168246,10168247,10168248,10168249,10168250,10168251,10168252,10168253,10168254,10168255,10168256,10168257,10168258,10168259,10168260,10168261,10168262,10168263,10168264,10168265,10168266,10168267,10168268,10168269,10168270,10168271,10168272,10168273,10168274,10168275,10168276,10168277,10168278,10168279,10168280,10168281,10168282,10168283,10168284,10168285,10173296,10173297,10173298,10173299,10173300,10173301,10173302,10173303,10173304,10173305,10173306,10173307,10173308,10173309,10173310,10173311,10173312,10173313,10173314,10950194,10580159,10580160,10580161,10580162,10580163,10580477,10580478,10568938,10568939,10568940,10568941,10568987,10568988,10568989,10568990,10568991,10541691,10533828,10533829,10423376,10423377,10423379,10421096,10421097,10421098,10473014,10490046,10490067,10490068,10490069,10490070,10490095,10490118,10490119,10473278,10473283,10473284,10473285,10473286,10473297,10473298,10473299,10473300,10473301,10473302,10473318,10473319,10473320,10473321,10473322,10473323,10473324,10473325,10473369,10473370,10473371,10473372,10473373,10473388,10473389,10473390,10473391,10473392,10473393,10473394,10473395,10473396,10473425,10473428,10473429,10473430,10473431,10473458,10473471,10473472,10473473,10473474,10473487,10473501,10473508,10490721,10490725,10479742,10479743,10479744,10479745,10479746,10479747,10479748,10479749,10479750,10479751,10479752,10479753,10479754,10479755,10479756,10479757,10479758,10479759,10479760,10479761,10479762,10479763,10479764,10479765,10479766,10479767,10479768,10479769,10473898,10494978,10494979,10494980,10494981,10494982,10487153,10487154,10476356,10489733) 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'