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(7073823,7073831,7073832,7073833,7073834,7073835,7073836,7073838,7073839,7073840,7073841,7073847,7073848,7073849,7073853,7073854,7073863,7073872,7073876,7073877,7073878,7073879,7073880,7073881,7073882,7073883,7073884,7073888,7073899,7073901,7073944,7073945,7073952,7073959,8067434,8067436,8067437,8067441,8067447,8067451,8067452,8067453,8067464,11011500,11011501,11011507,11011508,11011509,11011510,11011511,11011512,11011513,11011514,11011515,11011516,11011517,11011518,11011519,11011520,11011521,11011522,6000121,11011523,6000122,11011524,11011525,6000123,6000124,11011526,6000125,11011527,11011528,6000126,11011529,6000127,6000128,11011530,6000129,11011531,6000130,11011532,11011533,11011534,11011535,11011536,11011537,11011538,11011539,11011540,11011541,11011542,11011543,11011544,11011545,11011546,6000145,11011547,11011548,6000146,11011549,11011550,11011551,11011552,6000150,11011553,11011554,11011555,6000184,6000185,6000186,6000187,6000188,6000189,6000190,6000191,6000192,6000193,6000194,6000195,6000196,6000197,11011612,11011613,11011614,6000212,6000213,11011615,11011616,6000214,6000215,11011617,11011618,6000216,11011619,6000217,6000218,6000219,6000220,6000221,6000222,6000234,11011642,11011643,11011648,11011649,11011650,11011651,6000250,11011652,6000251,11011653,11011654,11011655,11011656,11011657,6000265,11011689,11011690,11011691,11011692,11011693,11011694,11011695,11011696,11011697,11011756,11011778,11011790,11011791,11011792,11011793,11011794,11011828,11011829,11011830,11011831,11011832,11011833,11011834,11011835,11011836,11011837,11011839,11011840,11011841,11011842,11011843,11011844,11011845,11011846,11011847,11011848,11011849,11011850,11011851,11011852,11011853,11011867,11011868,11011869,11011870,11011872,11011873,11011898,11011916,11011917,11011918,11011919,11011920,11011921,11011922,11012008,11012009,11012010,11012014,11012017,11012018,11012019,11012020,11012030,11012066,11012067,11012068,11012109,11012123,11012126,7073707,7073708,7073709,7073710,7073711,7073712,7073713,7073714,7073715,7073724,7073727,7073746,7073747,7073757,7073758,7073759,7073761,7073765,7073781,7073799,7073810,7073811,10942660,10942661,10942690,10942695,10942697,10942701,10942702,10942703,10942704,10942706,10942707,10942708,10942709,10942710,10942716,10942717,10942723,10942726,8861268,8861269,8861275,8861278,8861283,8861288,11011452,11011453,11011454,11011455,11011456,11011457,11011458,11011459,11011460,11011461,11011462,11011463,11011464,11011465,11011466,11011467,11011468,11011469,11011470,11011471,11011472,11011473,11011474,11011475,11011476,11011477,11011478,11011479,11011480,11011481,11011491,11011499,10944793,3655994,3655995,3655996,10944822,3656011,10944834,10944844,10944848,10944849,10944850,10944851,10944852,3656033,10944858,3656062,3656087,3656088,3656089,3656102,3656108,3656109,3656110,3656111,3656122,3656137,3656138,8073468,8073473,8073479,8073484,8073486,8570208,8570209,8570210,8570211,8570212,8570213,8570214,8570215,8570216,8570217,8570218,8570219,8570220,8570221,8570222,8570228,8570229,8570259,8570260,8570261,8570262,8570263,8570264,8570265,8570273,10930925,8864569,8864570,8864571,8864572,8864573,8864574,8864575,8864576,8864577,8864578,8864579,8864580,8864581,8864582,8864583,8864584,8864585,8864586,8864587,8864588,8864589,8864590,8864591,8864597,8864598,8864606,8864607,8864608,8864623,8864643,8864644,8864645,8864646,8864654,8864655,8864664,8864665,8864671,8864672,8864673,8864674,8864679,8864680,8864681,8864682,8864683,8864685,8864690,8864704,8864708,8864712,8864713,8864723,7058535,7058536,7058537,7058538,7058539,7058544,7058545,7058546,7058560,7058561,7058567,7058589,7058604,7058605,7058608,7058609,7058610,7058611,7058612,7058620,7058622,7058627,7058631,7058636,7058643,7058644,7058645,4974001,4974004,4974005,4974006,4974007,4974019,4974027,4974041,4974049,4974050,4974051,4974052,4974053,4974054,4974055,4974082,4974083,4974084,4974101,4974102,6667579,6667584,6667594,8917706,8917707,8917708,8917709,8917710,8917711,8917714,8917723,8917738,8917740,8917743,8917744,8917751,8917759,8917767,8917768,8917774,8917780,10628945,10628946,10628947,10628948,10628949,10628950,10628951,10628959,10628976,10628996,10629006,10629007,10629008,10629024,10629025,10629026,10629027,10629028,10629029,10629030,10629036,10629120,10629131,10629150,10629151,10629163,10629183,10629184,10629185,10629186,10629187,10629188,10629189,10629190,10629191,10629198,10629199,10629218,10629219,10629220,10629221,10629222,10629223,10629224,10629225,10629226,10629227,10629228,10629229,10629230,10629231,10629232,10629233,10629234,10629235,10629241,10629242,10629243,10629244,10629245,10629246,10629247,10629248,10629249,10629250,10629251,10629252,10629253,10629254,10629255,10629256,10629266,10629267,10629268,10629291,10629292,10629293,10629294,10629295,10629311,10629312,10629313,10629323,10629324,10629325,10629326,10629330,10629331,10629332,10629340,10629341,10629342,10629343,10629344,10629345,10629346,10629347,10629348,10629349,10629350,10629351,10629358,10629359,10629360,10629361,10629364,10629365,10629368,10629369,10629370,10629372,10629403,10629404,10629409,10629410,10629411,10629412,10629413,10629414,10629415,10629416,10629429,10629434,10629435,10629436,10176722,10176723,10176724,10176725,10176726,10176727,10176728,10176729,10176730,10176731,10176732,10176733,10176734,10176751,10176752,10176754,10176755,10176756,10176773,10176775,10176776,10176804,10176805,10176806,10176807,10176812,10176829,10176830,10176831,10176832,10176833,10176869,10568112,10568113,10568114,10568115,10568116,10568117,10568118,10568119,10568120,10568121,10568122,10568123,10568124,10568125,10568128,10568129,10568130,10568134,10568135,10568154,10568155,10568156,10568157,10568158,10568159,10568160,10568161,10568162,10568163,10568164,10568165,10568166,10568167,10568168,10568169,10568170,10568196,10568197,10568206,10568207,10568208,10568239,10568248,10568249,10568250,10568251,10568252,10568253,10568254,10568255,10568256,10568257,10568258,10568259,10568260,10568261,10568262,10568263,10568264,10568265,10568266,10568267,10568268,10568276,10568277,10568278,10568279,10568290,10568297,10568298,10568299,10568300,10568301,10568306,10568307,10568308,10568309,10568310,10568311,10568312,10568315,10568316,10568317,10568318,10568319,10568320,10568321,10568322,10568323,10568324,10568325,10568326,10568327,10568328,10568329,10568330,10568331,10568332,10568333,10568334,10568335,10568336,10568337,10568338,10568339,10568340,10568341,10568342,10568343,10568344,10568345,10568346,10568347,10568348,10568349,10568350,10568351,10568352,10568353,10568354,10568355,10568356,10568357,10568358,10568359,10568360,10568361,10568362,10568363,10568364,10568374,10568375,10568376,10568381,10568385,10568386,10568387,10568388,10568389,10568390,10568392,10568395,10568441,10568442,10568443,10568444,10568445,10568447,10568448,10568449,10568450,10568454,10568455,10568456,10568473,10568478,10568479,10568480,10568495,10568515,10568531,10567709,10567710,10567711,10567712,10567713,10567714,10567715,10567716,10567717,10567718,10567719,10567720,10567721,10567722,10567723,10567724,10567725,10567726,10567727,10567728,10567729,10567730,10567731,10567732,10567733,10567734,10567735,10567736,10567737,10567738,10567739,10567740,10567741,10567742,10567743,10567744,10567745,10567746,10567747,10567748,10567749,10567750,10567751,10567752,10567753,10567754,10567755,10567756,10567757,10567758,10567759,10567760,10567761,10567762,10567763,10567764,10567765,10567766,10567767,10567768,10567769,10567770,10567771,10567772,10567787,10567795,10567839,10567840,10567841,10567842,10567843,10567844,10567845,10567846,10567847,10567848,10567849,10567854,10567855,10567879,10567880,10567908,10567909,10567913,10567914,10567915,10567916,10567917,10567918,10567923,10567924,10567941,10567942,10567943,10567974,10567975,10567976,10567977,10567978,10567979,10567980,10567981,10567982,10567983,10567984,10568004,10568026,10568027,10568028,10568029,10568030,10568031,10568032,10568033,10568034,10568035,10568036,10568037,10568038,10568039,10568040,10568041,10568042,10568043,10568044,10568045,10568046,10568047,10568048,10568049,10568050,10568051,10568052,10568053,10568054,10568055,10568056,10568057,10568058,10568059,10568060,10568061,10568062,10568063,10568064,10568065,10568066,10568067,10568068,10568069,10568070,10568071,10568072,10568073,10568074,10568075,10568076,10568077,10568078,10568079,10568080,10568081,10568082,10568083,10568084,10568085,10568086,10568087,10568088,10568089,10568110,10568111,10423462,10423463,10423464,10423465,10423466,10423467,10423468,10423469,10423481,10423485,10423490,10423506,10423514,10423515,10423516,10423517,10423518,10423523,10423534,10423535,10423541,10423545,10423548,10423550,10423551,10423561,10423562) 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'