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(8838396,8838397,8620910,8838565,10939794,8838625,8621555,8621556,8621557,8621558,8621609,8622092,10437265,8067642,7074738,11013725,11013726,11013727,11013735,11013736,11013737,11013738,11013753,11013754,11013755,11013756,11013757,11013758,11013759,11013760,11013761,11013762,11013763,11013764,11013765,11013766,11013776,8837673,7075210,7075211,7075212,7075213,11040080,11040095,11040102,11040103,10962109,10962110,7075810,11037596,11037597,11037598,11037599,8617774,11037629,11037990,8911383,8911557,8911558,8911559,11012197,11012198,11012199,11012200,11038201,11012201,11012202,11038202,11012203,11012204,11012260,11012261,11038271,11012278,11012279,11012280,11038379,11038380,11038381,11038382,11012578,11012579,11012580,11012581,11012582,11012583,11012584,11012585,11012586,11012587,11012588,11012589,11012590,11012591,11012592,11012593,11012594,11012595,11012596,11012597,11012598,11012599,11012600,11012601,11012602,11012603,11012604,11012605,11012606,11012607,11012608,11012609,11012610,11012611,11012612,11012613,11012614,11012615,11012616,11012617,11012618,11012619,11012620,11012621,11012622,11012623,11012624,11012625,11012626,11012627,11012628,11012629,11012630,11012631,10960632,11012632,11012633,11012634,11012635,11012636,11012637,11012638,11012639,11012640,11012641,11012642,11012643,11012644,11012645,11012646,11012647,11012648,11012649,11012650,11038768,8836721,8836722,8836723,8836724,8836725,8836726,8836727,11013042,11013043,11013044,11013045,11013046,11013047,11013048,11013049,11013050,11013051,11013052,11013053,11013054,11013055,11013056,11013057,11013058,11013059,11013060,11013061,11013062,11013063,11013064,11013065,11013066,11013067,11013068,11013069,11013070,11013071,11013072,11013073,11013074,11013075,11013076,11013077,11013078,11013079,11013080,11013081,11013082,11013083,11013084,11013085,11013086,11013087,11013088,11013089,11013090,11013091,11013092,11013093,11013094,11013095,11013096,11013097,11013098,11039233,11039234,11039235,11039236,11039237,11039238,11039239,11039240,11039241,11039242,11039321,11039322,11039380,11039381,11039382,11039383,11039401,11039402,11039403,11039404,11039405,11039419,10943157,10943179,10943184,10959224,8910693,8563630,3656455,8615700,3656705,11006509,11006510,11006511,11006512,10923571,10923572,11006607,11006608,11006609,11006626,11006627,11006628,11006629,11006630,11006631,11006665,11006666,11006667,11006668,11006669,11006670,11006671,10923666,10923667,10923668,10923669,10923670,10923671,10923672,10923673,10923674,10923675,10923676,11006705,10923677,11006706,10923678,10923679,11006707,11032743,11006749,11006750,11006751,11006752,11006753,11006793,11006794,11006795,8612970,11045820,11045821,11045822,11006829,11006830,11006831,11006832,11006833,11006834,11006857,11006858,11006859,10923904,10923905,10923906,10923907,10923908,10923909,10923910,10923911,10923912,10923913,10923914,10923915,10923916,10923917,10923918,10923919,10923920,10923921,10923922,10967994,10924107,10924173,10924174,10924175,10924176,10924177,10924178,10924179,10924180,10924181,10924182,10924183,10924184,10924185,10924186,10924187,10924235,10924236,10924237,10924238,10924239,10924240,8904881,8578057,8578058,8578064,10922720,10922724,11005773,11005830,11005831,8578366,8578367,8578368,8578369,11005906,11005907,11005908,11005909,11005910,11005911,11005912,11005913,11005914,10922886,11005915,8578409,11005916,10922888,8578410,11005917,11005918,8578411,8578412,11005919,11005920,11005921,11005922,11005923,11005924,11005925,11005926,11005927,11005928,11005929,11005930,11005931,11005932,11005933,11005934,11005935,11005936,11005937,11005938,8578441,8578442,8578443,8578444,8578467,8578468,8578469,11005983,11006037,11006038,11006039,11006274,11006275,11006276,11006277,11006278,11006279,11006280,11006281,11006282,11006283,11006284,11006285,11006286,11006287,11006288,11006289,11006290,11006291,11006292,11006293,11006294,11006295,11006296,11006297,11006298,11006299,11006300,11006301,8612552,8612553,11006413,11006414,11006415,11006480,8905858,8576096,8576097,8576098,8576099,8576100,8570286,8570287,11004150,11004199,11004200,11004201,11004202,11004203,11004204,11004205,11004206,11004207,11004208,11004209,11004210,11004211,11004212,11004213,11004214,11004215,11004216,10930512,10930513,10926277,10926278,10926279,10926280,10926281,10926282,10926283,10926284,11004355,11004356,11004357,11004358,11004359,11004360,11004361,11004362,11004363,11004364,11004365,11004366,11004367,11004368,11004369,11004370,11004371,11004372,11004373,11004374,11004375,11004376,11004377,11004378,11004379,11004380,11004381,11004382,8610794,10926703,10926704,11004883,11004884,11004885,11004886,11004887,11004888,11004889,11004890,11004891,11004892,11004893,11004894,11004895,11004896,11004897,11004898,11004899,11004900,11004901,11004902,11004903,11004904,11004905,11004906,11004907,11004908,11004909,11004910,11004911,11004912,11004913,11004914,11004915,11004916,11004917,11004918,11004919,11004920,11004921,11004922,11004923,11004924,11004925,11004926,11004927,11004928,11004929,11004930,11004931,11004932,11004933,11004934,11004935,11004936,11004937,11004938,11004939,11004940,11004941,11004942,11004943,11004944,10616663,11005311,11005312,11005313,11005314,11005315,11005316,11005317,11005318,11005319,11005320,11005321,11005322,11005323,11005324,11005325,11005326,11005327,11005328,11005329,11005330,11005331,11005332,11005333,11005334,11005335,11005336,11005337,11005338,11005339,11005340,11005341,11005342,11005343,11005344,11005345,11005346,11005347,11005348,11005349,11005350,11005351,11005352,11005353,11005354,11005355,11005356,11005357,7027096,10565334,7019246,10611421,10611422,6665760,6665762,6665763,6665764,6665783,10611455,6665797,8864335,9213843,9205871,9205872,9205873,9205874,9205875,9205876,9205889,9205890,9205897,8864456,9174010,7019702,7019703,7019704,7019705,7019706,7019707,7019708,7019709,7019710,7019711,7019712,7019713,7019714,7019715,7019716,7019717,7019718,7019719,7019720,7019721,7019722,7019723,7019724,7019725,7019726,7019727,7019728,7019729,7019730,7019731,7019732,7019733,7019734,7019735,7019736,7019737,9206264,8861980,8861981,8862127,7025587,7025588,7025589,7025590,7025591,7025592,7025593,7025594,7025595,7025596,8862552,9196046,9196047,9196048,9196049,9196050,9196099,9196105,9196125,9196126,9196133,9196162,8862824,9212335,7025998,7025999,7026000,7026001,7026002,7026003,7026004,7026005,7026006,7026007,9212353,7026008,7026009,8862884,8862885,8863078,7026371,9164817,7026477,7018571,9196918,7026708,7026900,9169352,9177360,9185684,4974770,4974776,7023610,4974842,4974871,4974872,4974873,7023709,7023757,9186110,7023835,9186416,9170419,9210482,9186660,7024374,9203108,9203109,7024769,7024770,7024771,7024772,7024773,7024774,7024775,7024776,7024777,7024778,7024779,7024780,7024781,7024782,7024783,7024784,7024785,7024786,7024787,7024788,7024789,7024790,7024791,7024792,7024793,7024794,9200300,9200301,9200302,9200333,9200334,9200335,9200348,9200349,9200350,9200351,9200352,9200353,9200354,9200355,9200356,9168544,9208785,9208834,9209089,10420171,10420172,9206361,9206362,9206363,9206364,9206365,9206366,9206411,9206412,9206425,9206426,9206443,8864970,8864971,8864972,8864973,8864974,8864975,8864976,8864977,8865003,8865030,8865031,9174513,9174514,9174515,8916632,6667150,6667151,6667152,9207288,9167343,9207610,9207611,9207701,9207752,6667797,9207909,9207910,9207911,9207912,9207913,9207914,9207915,9207916,9207917,9207918,9207919,9207920,9207921,9207922,9207923,9207924,9207925,9207926,9207927,9207928,9207929,9207930,9200072,9200073,9200074,9200075,9200076,9200077,9200078,9200079,9200080,9200081,9200082,9200083,9200084,9200085,9200086,9200087,9200088,9200089,9200090,9200091,9200092,9200093,9176135,9176136,9176137,10462744,6668179,6668181,9200193,9200269,9200270,9200271,9200272,9200273,10628091,10628092,10628101,10174769,10174770,10174771,10174772,10174773,10174774,10174775,10174776,10174777,10174778,10174779,10174780,10174781,10174782,10174783,10174784,10174785,10174833,10174868,10174873,10174883,10174884,10629508,10629509,10629510,10186153,10186155,10186358,10186359,10186414,10186415,10186416,10186417,10186418,10186436,10186437,10186438,10186439,10186440,10186470,10186471,10186472,10168494,10168495,10168496,10168497,10168514,10168515,10168516,10168517,10168518,10168519,10168520,10168566,10168567,10168568,10168620,10168621,10168630,10168631,7001176,10948409,10181706,10181707,10181711,10631263,10168250,10168251,10168286,10168287,10168288,10168327,10168392,10168438,10168439,10168440,10168441,10168442,10583937,10583941,10584351,10591400,10591402,10521149,10521150,10521151,10532719,10522726,10522727,10423997,10423998,10423999,10424000,10424001,10424041,10424042,10476516) 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'