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(4970670,4970671,4970672,4970773,4970774,10944265,7065947,7066070,7066071,7066072,7066073,7066074,7066075,7066076,7066161,7066162,7066267,7066268,7066269,10437392,8573243,8910465,8067941,8067942,8067943,10842809,10842810,7067586,10247566,10247567,10247568,8909101,10101583,8910076,8834745,8834764,8834765,10839695,8905424,8905572,8905573,8905574,8905852,8612636,8905880,8906799,8906800,8906801,8906806,8906897,8906898,8906899,8906900,8906901,8860325,8860326,10838782,10838783,8860413,10838793,8860415,8860450,8860451,8860452,8860453,10838914,10838996,10838997,10838998,10838999,8907408,10426474,8611352,8611441,8611442,8611443,8611444,8611445,8611450,8611469,8611470,8611471,8611472,8611473,8611474,8611475,8611476,8611484,8611494,8905014,8905015,8905167,8905168,8905169,8611948,8905170,8905171,8905172,8905173,8905174,8905175,8905176,8905177,8905178,8905179,8905180,8905181,8905182,8905183,8905184,8905185,8905186,8905187,8905188,8905189,8905190,8905191,8905192,8905193,8905194,8905195,8905196,8905197,8905198,8905199,10619875,10622454,10622456,10622462,10617466,10617467,10617468,10617469,10617470,10617471,10617472,10617473,10617474,10617475,10617476,10617477,10617478,10617479,10617480,10617481,10617482,10617483,10617484,10617485,10617486,10617487,10617488,10617489,10617490,10617491,10617492,10617493,10617494,10617495,10617496,10617497,10617498,10617499,10617500,10617501,10617502,10617503,10617504,10617505,10617506,10617507,10617508,10617509,10617510,10617511,10617512,10617513,10617514,10617515,10617516,10617517,8576160,10615173,10615174,10615175,10615176,10615177,8574002,8574003,10188454,8583441,10431642,10201788,10616844,10616849,10616853,10431850,10616907,10616908,10616909,10616910,10614374,10614465,10614466,10614467,10614468,10614469,10614470,10614512,10614513,10614514,10614515,10122064,10614830,10614833,10614836,10612011,10612012,10612226,10612227,7017916,7017917,7017918,7017919,7017920,7017921,7017922,7017923,7017924,7017925,7017926,7017927,7017928,7017929,7017930,7017931,7017932,7017933,7017934,7017935,7017936,7017937,7017938,7017939,7017940,7017941,7017942,7017943,7017944,7017945,7017946,7017947,7017948,7017949,7017950,7017951,7017952,7017953,7017954,7017955,7017956,7017957,7017958,7017959,9172305,7017960,9172306,7017961,9172307,7017962,9172308,7017963,9172309,7017964,9172310,7017965,9172311,7017966,7017967,7017968,7017969,7017970,7017971,7017972,7017973,7017974,7017975,7017976,7017977,7017978,7017979,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,10613722,10117584,10117585,10117586,10117587,10117588,10117589,10117590,10117591,10117592,10117593,10117594,10117595,10117596,10117597,10117598,10117599,10117600,10117601,10117602,10117603,10515290,10515291,10117682,10117683,10515292,10515293,10515294,10515295,10515296,10515297,10515298,10515299,10515300,10515301,10515302,10515303,10515304,10117864,10117865,10117866,10117867,10117868,10117892,10117943,9169844,10118059,9169892,9169934,10118140,9169987,9169988,9169989,9169990,9169991,9169992,9169993,9169994,9169995,9169996,9169997,9169998,9169999,10118614,10118635,10118636,10118637,10118681,10118682,10118683,10118684,10118685,10118686,10118952,10118953,10118954,9168329,10416333,10416334,10416335,7014220,7014221,7014222,7014223,7014224,7014225,10416549,10418552,10418553,10418554,10418555,10418556,10418557,10418558,10418559,10418560,10418561,10418562,10418563,10418564,10418565,10418566,10418567,10418568,10418569,10418570,10418571,10418572,10418573,10418574,10418575,10418576,10418577,10418578,10418579,10418580,10418581,10418582,10418583,10418584,10418585,10418586,10418587,10418588,10418589,10418590,10418591,10418592,10418593,10418594,10418595,10418596,10418597,10418598,10418599,10418600,10418601,10419602,10418602,10418603,10419603,10419604,10418604,10419605,10418605,10419606,10418606,10419607,10418607,10419608,10418608,10418609,10419609,10418610,10419610,10419611,10418611,10418612,10419612,10419613,10418613,10419614,10418614,10418615,10419615,10419616,10418616,10419617,10418617,10419618,10418618,10419619,10418619,10418620,10419620,10419621,10418621,10419622,10418622,10419623,10418623,10418624,10419624,10418625,10419625,10419626,10418626,10419627,10418627,10419628,10418628,10418629,10419629,10418630,10419630,10419631,10418631,10419632,10418632,10419633,10418633,10419634,10418634,10419635,10418635,10419636,10418636,10419637,10418637,10419638,10418638,10418639,10419639,10419640,10418640,10419641,10418641,10419642,10418642,10419643,10418643,10419644,10418644,10419645,10418645,10419646,10418646,10419647,10418647,10419648,10418648,10419649,10418649,10419650,10418650,10419651,10418651,10419652,10418652,10419653,10418653,10419654,10418654,10419655,10418655,10418656,10419656,10418657,10419657,10418658,10419658,10418659,10419659,10418660,10419660,10418661,10419661,10418662,10419662,10416663,10418663,10419663,10418664,10416664,10419664,10416665,10418665,10419665,10416666,10419666,10418666,10419667,10418667,10418668,10419668,10416669,10418669,10419669,10416670,10418670,10419670,10419671,10418671,10419672,10418672,10419673,10418673,10419674,10418674,10419675,10418675,10419676,10419677,10419678,10419679,10419680,10419681,10419682,10419683,10419684,10419685,10419686,10419687,10419688,10419689,10419690,10419691,10419692,10419693,10419694,10419695,10419696,10419697,10419698,10419699,10419700,10419701,10419702,10419703,10419704,10419705,10419706,10419707,10419708,10419709,10419710,10419711,10419712,10419713,10419714,10419715,10419716,10419717,10419718,10419719,10419720,10419721,10419722,10419723,10419724,10419725,10419726,10419727,10419728,10419729,10419730,10419731,10419732,10419733,10419734,10419735,10419736,10419737,10419738,10419739,10419740,10419741,10419742,10419743,10419744,10419745,10419746,10419747,10419748,10419749,10419750,10419751,10419752,10419753,10419754,10419755,10419756,10419757,10419758,10419759,10419760,10419761,10419762,10419763,10416764,10419764,10419765,10419766,10416767,10419767,10416768,10419768,10416769,10419769,10419770,10416771,10419771,10419772,10419773,10419774,10419775,10419776,10419777,10419778,10419779,10419780,10419781,10419782,10419783,10419784,10419785,10419786,10419787,10419788,10419789,10419790,10419791,10419792,10419793,10419794,10419795,10419796,10419797,10419798,10419799,10419800,10419801,10419802,10419803,10419804,10419805,10419806,10419807,10419808,10419809,10419810,10419811,10419812,10419813,10419814,10419815,10419816,10419817,10419818,10419819,10419820,10419821,10419822,10419823,10419824,10419825,10419826,10419827,10419828,10419829,10419830,10419831,10419832,10419833,10419834,10419835,10419836,10419837,10419838,10419839,10419840,10419841,10419842,10419843,10419844,10419845,10419846,10419847,10419848,10419849,10419850,10419851,10419852,10419853,10419854,10419855,10419856,10419857,10419858,10419859,10419860,10419861,10419862,10419863,10419864,10419865,10419866,10419867,10419868,10419869,10419870,10419871,10419872,10419873,10419874,10419875,10419876,10419877,10419878,10419879,10419880,10419881,9169077,10420038,10420042,10417161,10117463,10419187,10471128,10471129,10471167,10471220,10471221,10471222,10471223,10471224,10471225,10471226,10471227,10471228,10471229,10471230,10471231,10471232,10471233,10471234,10471235,10471236,10471237,10471238,10471239,10471240,10471241,10471242,10471243,10471244,10471245,10471246,10471247,10471248,10471249,10471250,10471251,10471252,10471253,10471254,10471255,10471256,10471257,10471258,10471259,10471260,10471261,10471262,10471263,10471264,10471265,10471266,10471267,10471268,10471269,10471270,10471271,10471272,10471273,10471274,10471275,10471276,8549880,8549881,8549900,8549902,8549972,8550015,8550027,8550106,3963318,3963319,10467632,8916799,8916800,8916899,10467896,10467897,10467898,10467899,10467900,10467901,10467902,10467903,10467904,10467905,10467906,10467907,10467908,10467909,10467910,10467911,10467912,10467913,10467914,10467915,10466249,10466250,10466251,10468348,9167780,9167862,9167863,10468499,10468500,9167994,9167995,9167996,9167997,9167998,9167999,9168000,9168001,9168002,9168003,9168004,10470666,10470667,10470668,10470669,10470670,10470671,10470672,10470673,10470674,10470675,9168106,10470705,9168233,10883497,10883498,10883499,10883500,10883501,10883502,10883503,10883504,10883505,10883506,10883507,10883508,10883509,10883510,10883511,10883512,10883513,10883514,10883515,10883516,10883517,10883518,10883519,10883520,10883521,10883522,10883523,10883524,10883525,10883526,10883527,10883528,10883529,10883530,10632011,10627668,10627779,10161850,10161851,10161852,10161853,10161854,10161855,10161856,10161857,10161858,10161859,10161860,10161980,10626441,10877228,10590192,10477211,10477212,10477213,10477214,10478056,10478057) 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'