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(11040720,7076177,11041037,11041038,11041039,11041040,11041041,11041042,11041043,11041044,11041045,11041046,11041047,11041048,11041049,11041050,11041051,11041052,11041053,11041054,11041055,11041056,11041057,11041058,11041059,11041060,11041061,11041062,11041063,11041064,11041065,11041066,11041067,11041068,11041069,11041070,11041071,11041072,11041073,11041074,10943854,10943886,7068565,10944012,10933318,10933319,10933320,10976703,7074031,8067043,8067044,8067045,8067046,8067047,8067048,10963857,10964014,10964015,10964016,10964017,8067421,8067424,8067430,8067431,8067432,10437543,10437717,7066906,7067027,7067036,7075052,7067067,7067089,7075097,7075111,11040581,11040582,11040583,11040584,11040585,11040586,11011645,6000264,6000265,6000266,6000267,6000268,6000269,6000270,6000271,10931361,6000298,8065104,10931677,10931678,10931679,7064381,8065476,10931924,10931925,10931945,10931946,10931947,10931948,10931949,10931950,10931951,10931952,10931953,10931954,10931955,10931956,10931957,10931958,10931959,10931960,10931961,10931962,7064761,7064786,7064917,7064961,7064962,10932330,10932331,10932332,10932333,10932334,10932340,7065015,10932385,7065040,10932512,7073197,10932735,10932744,10987083,10987084,10987085,10987086,10932750,10987087,10987088,10987089,10987090,10987091,10987092,10987093,7073491,7073564,7073642,7073649,7073693,7073743,7073852,10933210,10933245,10942593,11010876,11010877,11010878,11010879,11010880,11010881,11010882,11010883,11010884,11010966,10959006,11049259,11011356,11011357,11011358,11011359,11011360,11011361,11011362,11011363,11011364,11011365,11011400,11011401,11011402,6000115,6000116,6000121,6000122,6000123,6000124,6000125,6000141,11011554,3655635,3655636,10956817,10956818,10956823,10956824,10956831,10956832,10956833,10956834,10956835,10956836,10956837,10956838,10956839,10995911,10995912,10944654,10944655,10944656,3655845,10944755,3655927,10944787,3655947,3655981,10941167,10941168,10941169,10941170,10941171,10941172,10944982,3656589,11009929,11048227,11048228,11048229,11010174,11010175,11010176,11010177,11010178,11010296,11048576,11048577,8073443,10958408,11010426,11010427,11010428,11010501,11010558,11010559,11010560,11010561,11010567,11019800,11019801,11019802,11019803,11019804,11019805,11019806,11019807,11019808,11019809,11019810,11019811,11019812,11019813,11019814,11019815,11019816,11019817,11019818,11019819,11019820,11019821,11019822,11019823,11019824,11019825,11019826,11019827,11019828,11019829,11019830,11019831,11019832,11019833,11019834,11019835,11019836,11019837,11019838,11019839,11019840,11019841,11006996,11006997,11006998,11006999,11007000,11007119,11007343,10994488,10623959,11007718,11007823,10624231,10624232,10624233,10624234,10624235,10624236,10624237,10624238,10624239,10624240,10624241,10624242,10624243,10624244,10624245,11007904,10624246,8070955,11007905,10624247,10624248,8070956,10624249,8070957,10624250,8070958,10624251,11007909,8070959,10624252,11007910,10624253,10624254,10624255,10624256,10624257,10624258,10624259,10624260,10624261,10624262,10624263,10624264,10624265,10624266,10624267,10624268,10624269,10624270,10624271,10624272,10624273,10624274,10624275,10624276,10624277,10624278,10624279,10624280,10624281,10624282,10624283,10624284,10624285,10624286,10624287,10624288,10624289,10624290,10624291,10624292,10624293,10624294,10624295,10624296,10624297,10624298,10624299,10624300,10624301,10624302,10624303,10624304,10624305,10624306,10624307,10624308,10624309,10624310,10624311,10624312,10624313,10624314,10624315,10624316,10624317,10624318,10624319,10624320,10624321,10624322,10624323,10624324,10624325,10624326,10624327,10624328,10624329,10624330,10624331,10624332,10624333,10624334,11008022,11008036,11008037,11008038,11008039,11008040,11008041,10619447,10624540,10624541,11005783,11005784,11005796,11005797,11005839,11005840,11005841,10927823,10927824,10927832,11006003,11006025,10967333,10967334,10967335,10967336,10967337,10967338,10967339,10967340,10967341,10967342,10967343,10967344,11006446,11006447,11006448,11006449,11006450,11006451,11006452,10967554,10967555,10967556,10925670,10925671,10925672,10925673,10925796,10925797,10925798,10925799,10925800,10925801,10925802,10925803,10925804,10925805,10620296,10925806,10925807,10925808,10925809,10925810,10615329,10615330,8570373,8570374,8570375,8570376,11004125,11004156,11004157,10930662,10991447,10930851,10930887,10930889,11004632,10930914,10991701,10991702,10991703,11005305,10565136,7059508,7059509,7059510,9197348,10565170,10565171,10565172,10565173,9173364,9173365,9197365,9173366,9173367,9173368,9173369,9173370,9173371,9173372,9173373,9173374,8863897,9173375,9173376,9173377,8863900,9173378,9173390,9197396,8863923,9197537,9197558,10559384,10559385,10559386,9189600,9165622,9197631,10559458,10559459,6665772,6665773,6665774,6665775,6665776,8864562,9198134,8864694,9198204,9190238,9190239,9190240,9190241,10563221,9163411,10563301,10563302,10563303,8862105,9163656,9171747,9163856,7058320,9164220,9172291,10564124,10564125,10564126,10564127,10564128,7058499,7058500,9196432,9196433,9164439,9196518,9196560,10558374,10558375,10558376,10558377,10558378,10558379,10558380,10558381,10558382,10558383,10558384,10558385,10558386,10558387,10558388,9164575,10558389,10558390,10558391,10558392,10558393,10558394,10558395,10558396,10558397,10558398,10558399,9196628,10613306,10610311,9188685,9196690,9196819,9172877,9196940,10558974,10558975,10558976,10558977,10558978,10558979,10558980,9161347,7055534,9193523,4975042,4975043,4975044,4975045,4975046,4975047,4975048,10518026,10518027,10518028,10518029,10518030,10518031,10518032,10518033,10518034,10518035,10518036,10518037,10518038,10518039,10518040,10518041,10518042,10518043,10518044,10518045,2809537,2809538,2809539,2809540,2809541,2809542,2809543,2809544,2809545,2809546,2809547,2809548,2809549,2809550,2809551,2809552,2809553,2809554,2809555,2809556,2809557,2809558,2809559,7057372,7057373,7057375,8917962,8917963,8917964,8918015,8918016,8918017,8918018,7055083,7055180,7055181,7055182,7055183,7055184,7055185,7055186,7055188,4973947,9190359,9182485,9182486,6666724,6666725,9166841,6666950,6666951,6667240,6667241,6667242,6667243,8563424,8563430,8563445,8563452,8563453,6667555,6667556,6667557,6667558,6667571,6667572,9183671,9183704,9183743,9183786,9183823,9183829,6667828,6667852,8917511,8917518,9183872,9183873,9183874,9183875,8917578,8917601,4972833,8917637,9184056,10466642,10159562,10628239,10628284,10628302,10628303,10628304,10628305,10628306,10628307,10628325,10628326,10628341,10174946,10174984,10174985,10174986,10175045,10175046,10175047,10175048,10175049,10175050,10175051,10175052,10175053,10175054,10628712,10628713,10628714,10628715,10628716,10628717,10628871,10175411,10628903,10628916,10160643,10160644,10160645,10160646,10629208,10171437,10171438,10171439,10171440,10171441,10171442,10171443,10171444,10158490,10158491,10158492,10158503,10158504,10158509,10158510,10176528,10176529,10176530,10176547,10176548,10176549,10176550,10176612,10176660,10176661,10176662,10176663,10176664,10176665,10176666,10176667,10176695,10176803,10631118,10631119,10631191,10172886,10172887,10172888,10172889,10172890,10172891,10172900,10163372,10163373,10163374,10163375,10163376,10163377,10158430,10158431,10158432,10158433,10158434,10158435,10158449,10158450,10158451,10158459,10158460,10158461,10158469,10568491,10568492,10568493,10568494,10568495,10568496,10568497,10568498,10568499,10568500,10568501,10568502,10568503,10568504,10568505,10568506,10568507,10568508,10568509,10568510,10568511,10568512,10568513,10568514,10568515,10568516,10568517,10568518,10568519,10568520,10568521,10566425,10566426,10566427,10566428,10566429,10566430,10566431,10566432,10566433,10566563,10566564,10566565,10566566,10566567,10566568,10566569,10566570,10566571,10566572,10566573,10566574,10566575,10566576,10566577,10566578,10566579,10566580,10566618,10566619,10566620,10566621,10566622,10566623,10566624,10566625,10566626,10566627,10566628,10566629,10566630,10566631,10566632,10566633,10566634,10566635,10566636,10566637,10582161,10582162,10582163,10582164,10582165,10582166,10582167,10582168,10582429,10582430,10582431,10582432,10582433,10582434,10582435,10582436,10582437,10582438,10582439,10582440,10567498,10567499,10567500,10582574,10567598,10567599,10567709,10567710,10567711,10567712,10567713,10567714,10567715,10567716,10567717,10567718,10567773,10567774,10528545,10528578,10528579,10528580,10528581,10528582,10528583,10528584,10423327,10423328,10423329,10423330,10423335,10423423,10423428,10421679,10421680,10421681,10421682,10421683,10421684,10421685,10423850,10423898,10423899,10472984,10484103,10484104,10484105,10484106,10484107,10484108,10484109,10484110,10484111,10484112,10484113,10484114,10484115,10484116,10473275,10473276,10473277,10473633,10477822,10483824,10483825) 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'