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(8068806,8068849,8068851,4970270,10943628,10944178,10944179,10933530,10437208,10437209,4968635,4968668,4968669,10437291,10437292,10437293,10437294,10437295,10437306,10437311,10437312,10437313,10437314,10437315,10437316,10437317,10437318,10437319,10437320,10437321,10437488,10437489,10437499,10437500,8067910,8067924,8067925,8067991,8067992,8067993,8067994,8067995,8067996,8067997,8067998,8068042,8068043,8068044,8068045,8068046,8068047,8068048,8068049,8068109,8068110,8068111,8068112,8068113,8068114,8068115,8068211,8068212,8068213,8068214,8068215,8068216,8068217,8068218,8068219,8068220,8068221,8068282,8068283,8068284,8068285,8068286,8068287,8068288,8068289,8068290,8068291,8068292,8068361,8068362,8068363,8068364,8068365,8068366,8068367,8068368,8068369,8068370,8068371,8068372,8068373,8068429,8068430,8068431,8068432,8068433,8068434,8068435,8068436,8068437,8068438,8068439,8068457,8068461,8068469,8068480,8068488,8068489,8068559,8068560,8068561,8068562,8068563,8068564,8068565,8068566,8068567,8068568,8068569,8068570,8068802,8068803,8068804,8075321,4967030,4967031,10932177,10932187,10932222,10932268,10932328,10932329,10932430,10932431,10932432,10932433,10932434,10932488,10932491,10932540,10932541,10932542,10932543,10932544,10932545,10932661,10932662,10932663,10932664,10932665,10932666,10932667,10932668,10932669,10932670,10932683,10932684,10932685,10932686,10932687,10932688,10932689,10932690,10932691,10932692,10932693,10932694,10932695,10932853,10932916,10933007,10933008,10933009,10933013,10933014,10933024,10933028,10933029,10933030,10933031,10933068,10933069,4967985,4968121,10943131,10943161,10943162,10943164,10943165,10943166,10943169,10943170,10943224,10943225,10943234,10943237,10943238,10943239,10943240,10943241,10943242,10943243,10943252,10943317,10943320,10943323,10943371,10943377,10943381,10943385,10943387,10943392,10943393,10943394,10943396,10943400,10943401,10943412,10943413,10943414,10943415,10940812,10940813,10940975,10941064,10941176,10941187,10941386,10941793,10941794,10941803,10941805,10941806,10941812,10941831,10941835,10941836,10941837,10941865,10941866,10941879,10941892,10941893,10941900,10941925,10941926,10941927,10941936,10941937,10941938,10941946,10941953,10941964,10941965,10941966,10941974,10941981,10941998,10942002,10942003,10942008,10942011,10942020,10942034,10942118,10942119,10942120,8073512,8073513,8073521,8073522,8073523,8073524,8073525,8073526,8073545,10942529,10942530,10942531,10942532,10623064,10623209,10623210,10623211,10623212,10623213,10623214,10623236,10623237,10623238,10623239,10623240,10623241,10623242,10623243,10623356,10623450,10623491,10623492,10623493,10925124,10925371,10922535,10922536,10622034,10622035,10622036,10922556,10922557,10922558,10922559,10922560,10922561,10922562,10922563,10922564,10922565,10922566,10922567,10922568,10922569,10922570,10922571,10922572,10922573,10922574,10922575,10622101,10622102,10622113,10622114,10622115,10622363,10922939,10922941,10622427,10922949,10622460,10622461,10622537,10622538,10622728,10622747,10622748,10622749,10622897,10622901,10619977,10619978,10619988,10619989,10620017,10620034,10620035,10620083,10620108,10620129,10920657,10920658,10920659,10920660,10920661,10920662,10920663,10920664,10920665,10920666,10920667,10920668,10920669,10920670,10920671,10620302,10620325,10620326,10620328,10620329,10620390,10620391,10620392,10620393,10620394,10620395,10620396,10620397,10620398,10620399,10620400,10620401,10620402,10620403,10620404,10620405,10620406,10620407,10620415,10620416,10620417,10620418,10921233,10921234,10921235,10921236,10921237,10921238,10921239,10921240,10921241,10921242,10921243,10921244,10921245,10921246,10921247,10921248,10921249,10921250,10921251,10921252,10921253,10921254,10921255,10921256,10921257,10921258,10921259,10921260,10921261,10921262,10921263,10921264,10921265,10921266,10921267,10921268,10921269,10921270,10921271,10921272,10921273,10921274,10921275,10921276,10921277,10921278,10921279,10921280,10921281,10921282,10921283,10921284,10921285,10921286,10921287,10921288,10921289,10921290,10921291,10921292,10921293,10921294,10921295,10921296,10921297,10921298,10921299,10921300,10921301,10921302,10921303,10921304,10921305,10921306,10921307,10921308,10921309,10921310,10921311,10921312,10921313,10921314,10921315,10921316,10921317,10921318,10921319,10921320,10921321,10921322,10921323,10921324,10921325,10921326,10921327,10921328,10921329,10921534,10921535,10921586,10921590,10921591,10921592,10921593,10921594,10621109,10621110,10621111,10621112,10621113,10621114,10621115,10621116,10621117,10621118,10621119,10621120,10621121,10621122,10621123,10621124,10621125,10621126,10621127,10621128,10621129,10621130,10621131,10621132,10621133,10621134,10621135,10621136,10621137,10621138,10621139,10621140,10621141,10621142,10621143,10621144,10621145,10621146,10621147,10621148,10621149,10621150,10621151,10621152,10621153,10621154,10621155,10621156,10621157,10621158,10621159,10621160,10621161,10621162,10621163,10621164,10621165,10621166,10621252,10621253,10621254,10621255,10621256,10621257,10621270,10621271,10621272,10621277,10621280,10621281,10621282,10621285,10621287,10621322,10621345,10621346,10621347,10621348,10621349,10621350,10621351,10621360,10621361,10621362,10621368,10621369,10621370,10621400,10621401,10621402,10621403,10621404,10621405,10621406,10621407,10621408,10621409,10621410,10921966,10921967,10921968,10621629,10621630,10621643,10621675,10621676,10621677,10621678,10621679,10621680,10621681,10621682,10621731,10621732,10621733,10621734,10565112,10565113,10565114,10565115,10565116,10565117,10565118,10565119,10565120,10565121,10565122,10565123,10565124,10565125,10565126,10565127,10565160,10565161,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565169,10565192,10565193,10565194,10565195,10565196,10614064,10565223,10565271,10565272,10565273,10565274,10565275,10565276,10565277,10565297,10565298,10565299,10565300,10614162,10565343,10565344,10565345,10614282,10614289,10614297,10614380,10614472,10614555,10614573,10614591,10565939,10614820,10614821,10614822,10566051,10566071,10566072,10566073,10566074,10566075,10566076,10566077,10566078,10566079,10566080,10566081,10566082,10611987,10563187,10563188,10563189,10563190,10563191,10563192,10563193,10563194,10612087,10612178,10612186,10612319,10612348,10563541,10563542,10563543,10563553,10563554,10563555,10612411,10563564,10563565,10563566,10563570,10612638,10612716,10612745,10612786,10612870,10612882,10612945,10612961,10613027,10613079,10613083,10613119,10613173,10613293,10613294,10613295,10613296,10613297,10613298,10613299,10613300,10613301,10613302,10613303,10613304,10613305,10613315,10613356,10613357,10613364,10613365,10613366,10613367,10613368,10613380,10613382,10613389,10613392,10613416,10613422,10613440,10613442,10613445,10613475,10613479,10564645,10564646,10564647,10564648,10564649,10564650,10564651,10564652,10564653,10564654,10564655,10564656,10564657,10564658,10564659,10564660,10564661,10564662,10564663,10564664,10564665,10564666,10564667,10564668,10564669,10564670,10564671,10564672,10564673,10564674,10564675,10564676,10564677,10564678,10564679,10613539,10613560,10564735,10564736,10564737,10564738,10564739,10564740,10564741,10564742,10564743,10564744,10564745,10564746,10564747,10564748,10564749,10564750,10564751,10564752,10564753,10564754,10564755,10564756,10564757,10564758,10564759,10564760,10564761,10564762,10564763,10564764,10564765,10564766,10564767,10564768,10564769,10564770,10564771,10564772,10564773,10564774,10564775,10564776,10564777,10564778,10564779,10564780,10564781,10564782,10564783,10564784,10564785,10564786,10564787,10564788,10564789,10564790,10564791,10564792,10564793,10564794,10564795,10564796,10564797,10564798,10564799,10564800,10564801,10564802,10564803,10564804,10564805,10564806,10564807,10564808,10564809,10564810,10564811,10564812,10564813,10564814,10564815,10564816,10564817,10564818,10564819,10564820,10564821,10564822,10564823,10564824,10564825,10564826,10564827,10564828,10564829,10564830,10564831,10564991,10564992,10564993,10565061,10565062,10565063,10565064,10565065,10565066,10565067,10565068,10565069,10565070,10565071,10565072,10565073,10565074,10565075,10565076,10565077,10565078,10565079,10565080,10565081,10565082,10565083,10565084,10565085,10565086,10565087,10565088,10565089,10565090,10565109,10565110,10565111,10511187,10511188,10511189,10511190,10511191,10511192,10511193,10511194,10517238,10517239,10517240,10511278,10511356,10511357,10511421,10517564,10517565,10517566,10517567,10517568,10517755,10517756,10518645,10518646,10518647,10419449,10419681,10419682,10419834,10419835,10419836,10419888,10419889,10419893,10419897,10419898,10419900,10419903,10419906,10419942,10419943,10419994,10419998,10420000,10420002,10420003,10420004,10420006,10420007,10420008,10420011,10420013,10420146,10420166,10420184,10420191,10420198,10420209,10420215,10471538,10471539,10469908,10470536) 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'