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(8631123,8631124,3229175,3229176,3229177,3229178,3229179,3229180,3229181,3229182,8631611,7065986,7066024,7066025,7066026,7066027,7066029,7066030,7066031,7066056,7066058,7066060,7066061,8583568,7066100,7066123,7066127,7066237,7066238,8632193,3229978,8067938,8067939,8573239,8573240,8630295,10845436,8630401,8630402,8630403,7201742,8628239,8595263,8595264,8595265,8595266,8628628,8628629,8628774,8628775,8628776,8628777,7202525,7202526,7065336,7202652,7202653,7202654,7202767,7200099,7200133,7200201,7200202,7200203,7200204,7200205,7200206,7200207,7200208,7200209,7200210,7200211,7200212,7200213,7200214,7200215,7200216,7200217,7200218,7200219,7200220,7200221,7200222,7200223,7200224,7200225,7200226,8626902,8626903,8626904,8626905,10958959,7200781,8624547,8624548,8624549,8614926,10101517,10101574,8860384,3923531,3923532,3923533,3923539,3923607,3923632,3923659,3923660,3923661,8906728,8906729,8906730,8906731,8906732,8906733,8906734,8906735,8906736,10838644,10838925,8614445,8614446,8614447,8614475,8614476,3925034,3925035,3232382,10836900,3232801,3232802,3922824,8632710,10615329,10615330,10615348,10615685,10616196,10616197,10616198,10616199,10616200,10616201,10616202,10616203,10616204,10616205,10616206,10616207,10616208,10616209,10616210,10616211,10616212,10616213,10616214,10616215,10616216,10616217,10426435,10426436,10616218,10426437,10616219,10616220,10426438,10616221,10616222,10616223,10616224,10616225,10616226,10616227,10616228,10616229,10616230,10616231,10616232,10616233,10616234,10616235,10616236,10616237,10616238,10616239,10616240,10616241,10616242,10616243,10616244,10616245,10616246,10616247,10616248,10616249,10616250,10616251,10616252,10616253,10616254,10616255,10616256,10616257,10616258,10616259,10616260,10616261,10616262,10616263,10616264,10616265,10616266,10616267,10616268,10616269,10616270,8540637,10616271,10616272,10616273,10616274,10616275,10616276,10616277,10616278,10616279,10616280,10616281,10616282,10616283,10616284,10616285,10616286,10616287,10616288,10616289,10616290,10616291,10616292,10616293,10616294,10616295,10616296,10616297,10616298,10616299,10616300,10616301,10616302,10616303,10616304,10616305,10616306,10616307,10616308,10616309,10616310,10616311,10616312,10616313,10616314,10616315,10616316,10616317,10616318,10616319,10616320,10616321,10616322,10616323,10616324,10616325,10616326,10616327,10616328,10616329,10616330,10616331,10616332,10616333,10616334,10616335,10616336,10616337,10616338,10616339,10616340,10616341,10616342,10616343,10616344,10616345,10616346,10616347,10616348,10616349,10616350,10616351,10616352,10616353,10616354,10616355,10616356,10616357,10616358,10616359,10616360,10616361,10616362,10616363,10616364,10616365,10616366,10616367,10616368,10616369,10616370,10616371,10616372,10616373,10616374,10616375,10616376,10616377,10616378,10616379,10616380,10616381,10616382,10616383,10616384,10616385,10616386,10616387,10616388,10616389,10616390,10616391,10616392,10616393,10616394,10616395,10616396,10616397,10616398,10616399,10616400,10616401,10616402,10616403,10616404,10616405,10616406,10616407,10616408,10616409,10616410,10616411,10616412,10616413,10616414,10616415,10616416,10616417,10616418,10616419,10616420,10616421,10616422,10616423,10616424,10616425,10616426,10616427,10616428,10616429,10616430,10616431,10616432,10616433,10616434,10616435,10616436,10616437,10616438,10616439,10616440,10616441,10616442,10616443,10616444,10616445,10616446,10616447,10616448,10616449,10616450,10616451,10616452,10616453,10616454,10616455,10616456,10616457,10616458,10616459,10616460,10616461,10616462,10616463,10616464,10616465,10616466,10616467,10616468,10616469,10616470,10616471,10616472,10616473,10616474,10616475,10616476,10616477,10616478,10616479,10616480,10616481,10616482,10616483,10616484,10616485,10616486,10616487,10616488,10616489,10616490,10616491,10616492,10616493,10616494,10616495,10616496,10616497,10616498,10616499,10616500,10616501,10616502,10616503,10616504,10616505,10616506,10616507,10616508,10616509,10616510,10616511,10616512,10616513,10616514,10616515,10616516,10616517,10616518,10616519,10616520,10616521,10616522,10616523,10616524,10616525,10616526,10616527,10616528,10616529,10616530,10616531,10616532,10616533,10616534,10616535,10616536,8611375,8611447,8611451,8634294,10614864,10612035,10612036,10612108,10609158,10120323,10120325,10120327,10120338,10610039,8852572,8852573,8852574,8852575,8852576,8852577,10610415,8852578,10610416,8852579,8852580,8852581,8852582,8852583,8852584,8852585,8852586,8852587,8852588,8852589,8852590,8852591,8852592,8852593,8852594,8852595,8852596,8852597,8852598,8852599,8852600,8852601,8852602,8852603,8852604,8852605,8852606,8852607,8852608,8852609,8852610,8852611,8852612,8852613,8852614,8852615,8852616,8852617,8852618,8852619,8852620,8852621,8852622,8852623,8852624,8852625,8852626,8852627,8852628,8852629,8852630,8852631,8852632,8852633,8852634,8852635,8852636,8852637,8852638,8852639,8852640,8852641,8852642,8852643,8852644,8852645,8852646,8852647,8852648,8852649,8852650,8852651,8852652,8852653,8852654,8852655,8852656,8852657,8852658,8852659,8852660,8852661,8852662,8852663,8852664,8852665,8852666,8852667,8852668,8852669,8852670,8852671,8852672,8852673,8852674,8852675,8852676,8852677,8852678,8852679,8852680,8852681,8852682,8852683,8852684,8852685,8852686,9169313,9169445,9169446,9169471,9169586,9169661,9169695,9169748,9169749,9169750,9169849,6674247,6674248,6674249,6674250,10118246,8849959,8849960,10118533,10118534,10118535,10118536,10118537,10118538,10118539,10118540,10118541,10118542,10118543,10118544,10118545,10118546,10415314,10418316,10418317,10418318,10418319,10418320,10418321,10418322,10418323,10418324,10418325,10418326,10418327,10418328,10418329,10418330,10418331,10418794,10418795,10418796,10418797,10418798,10418799,10418800,10418801,10418802,10418803,10418804,10418805,10418806,10418807,10418808,10418809,10418810,10418811,10418812,10418813,10418814,10418815,10418816,10418817,10418818,10418819,10418820,10418821,10418822,10418823,10418824,10418825,10418826,10418827,10418828,10418829,10418830,10418831,10418832,10418833,10418834,10418835,10418836,10418837,10418838,10418839,10418840,10418841,10418842,10418843,10418844,10418845,10418846,10418847,10418848,10418849,10418850,10418851,10418852,10418853,10418854,10418855,10418856,10418857,10418858,10418859,10418860,10418861,10418862,10418863,10418864,9169014,9169181,10416187,10416189,10416190,10470999,10471000,10471001,10471002,10471003,10471004,10471005,10471006,10471007,10471008,10471009,10471010,10471011,10471012,10471013,10471014,10471015,10471016,10471017,10471018,10471019,10471020,10471021,10471022,10471023,10471024,10471025,10471026,8550218,8550219,8550220,8550221,8550222,8916796,8916797,9167540,9167871,9183980,9168288,10889315,10889316,10889317,10889318,10889319,10889320,10889321,10889322,10889323,10889324,10889325,10889326,10889327,10889328,10889329,10889330,10889331,10889332,10889333,10889334,10889335,10889336,10889337,10889338,10889339,10889340,10889341,10889342,10889343,10889344,10889345,10889346,10889347,10889348,10889349,10889350,10889351,10889352,10889353,10889354,10889355,10889356,10889357,10889358,10889359,10889360,10889361,10889362,10889363,10889364,10889365,10889366,10889367,10889368,10889369,10889370,10889371,10889372,10889373,10889374,10889375,10889376,10889377,10889378,10889379,10889380,10889381,10889382,10889383,10889384,10889385,10889386,10889387,10889388,10889389,10889390,10889391,10889392,10889393,10889394,10889395,10889396,10889397,10889398,10889399,10889400,10889401,10889402,10889403,10889404,10889405,10889406,10889407,10889408,10889409,10889410,10889411,10889412,10889413,10889414,10889415,10889416,10889417,10889418,10889419,10889420,10889421,10889422,10889423,10889424,10889425,10889426,10889427,10889428,10889429,10889430,10889431,10889432,10889433,10889434,10889435,10889436,10889437,10889438,10889439,10889440,10889441,10889442,10889443,10889444,10889445,10889446,10889447,10889448,10889449,10889450,10884592,10885034,10885075,10890243,10875310,10887550,7000826,10882943,10887964,10885710,10875953,10161976,10162203,10162204,10162205,10162206,10162237,10881398,10876602,10626299,10626300,10626301,10897091,10647677,10647678,10647679,10601472,10545324,10547913,10547998,10544310,10548747,10548748,10548751,10548885,10508199,10508501,10508502,10508503,10508603,10507687,10507688,10507689,10507690,10507691,10507692,10507693,10507694,10507695,10507696,10507697,10507698,10507699,10507700,10507701,10507702,10507703,10507704,10507705,10507706,10507902,10508002,10508009,10508010,10508011,10508013,10508027,10411551,10486551,10486552,10486553,10486554,10486555,10486556,10486557,10411951,10411952,10411953,10411954,10411955,10410588,10410618,10410620,10410629,10410631,10410634) 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'