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(8838431,8838432,10873261,8838523,8838524,10930361,8574270,11040904,11040905,11040906,11040907,11040908,7068378,7068379,8621298,10870758,10870796,10873836,10873868,10874060,10963496,10963497,4971141,7074262,10862689,10862690,8575648,7074559,7074579,7074580,7074605,7074629,7074870,8619782,8619783,8619784,7074973,8619927,7075100,8561096,11039865,11039866,11039867,11039868,10929494,8629960,8630035,8630097,7067659,11040443,7075867,10873160,7201294,7064329,8075265,8559480,10931908,10843341,10843342,10843343,8911724,8559955,8572217,10104296,7202584,10104569,10932860,10932861,10932862,4967845,4967846,4967847,4967848,4967849,3227107,10099981,11039522,8560799,10100017,10933229,10961570,10961571,10961572,10961573,10961574,10961575,10961576,8619767,3927392,3927393,3927394,11048962,11036941,11036942,11036943,10102414,8835004,8064540,10842328,8835253,3238239,3238240,8908023,8908024,7068968,8908025,8555964,7069025,7069026,8556007,8556008,8556009,8556010,8556035,8556036,8556037,8563967,10863661,8615354,3926054,3656375,8564773,11023043,10942074,11048461,3927017,10997393,10997394,8909844,8909851,10618007,10618008,10918569,10918570,10918577,10918578,10918579,10923606,10923607,10923608,10923609,7196506,7196510,7196514,10923855,10923856,10923857,10923858,10923859,10924097,10924098,10924099,10924100,10924101,8554544,7157320,7157439,10924547,10924548,10924549,10924550,10924551,10924552,10924553,10924554,10924555,10924556,10924557,10924558,10924559,10924560,10924561,10924562,10924563,10924564,10924565,10924566,10924567,10924568,10924569,10924570,10924571,10924572,10924573,10924574,10924744,10924745,10924746,10924747,10924748,10924749,10919887,10919888,10919889,10919890,8555755,8555756,10427381,11005706,10917867,10917868,10917869,8578537,8578593,8578594,8578595,8578596,8578597,8578607,8578893,3230633,10847972,9217086,9217087,9217088,9217089,9217090,9217091,9217092,9217093,10952421,3582211,3582212,8904418,8577853,10953462,10953463,10922322,10922323,10922324,10922325,10922326,10922327,9174099,9174100,9174101,3962510,7025078,9913700,10612403,9187952,9187953,9187954,9187955,9187956,7026346,7026513,3654078,7018542,7026546,9915220,7026843,8567747,8567748,10428677,10125867,10125933,4974806,4974807,4974808,7023688,4974930,4974931,4974932,990496,7023814,8551549,8551550,8551551,3286069,3286070,3651904,2809382,2809385,2809399,10512770,9203160,10519096,8861811,7022041,6680749,7022201,9200796,9200797,9200805,10125288,7022761,9161171,10417156,10428675,10428676,7019972,8864865,6678603,6678606,6670710,6670711,8854363,8854369,8569083,8569084,8569193,8569194,7020488,9917105,9917107,9207086,9207087,9207088,9191124,8550311,6667208,8855149,8855150,8855229,9207683,7021461,10116017,10116018,6680059,10468664,10946283,10946284,10946285,10946286,10883978,10175061,10175062,10914322,10914323,10914324,10914325,10914326,10914327,10914328,10914329,10155391,10155392,10155393,10155394,10155395,8594533,10904815,10904816,10904817,10904818,10904819,10904828,10904829,10904830,10904831,10904832,10915029,10915030,10915035,10171119,10186330,10186331,10186332,10186333,10186334,10186335,10910353,10158592,10158593,10158594,10158595,10158596,10158597,10158598,10158599,10158600,10158601,10158602,10158603,10158604,10173690,10903128,10184167,10184168,10184169,10184170,10184171,10946279,10946280,10946281,10946282,10171554,10171555,10171556,10171557,10171558,10171559,10186587,10186588,10186589,10186590,10186591,10186592,10186593,10186594,10186595,10186596,10186597,10186598,10186599,10186600,10186601,10181725,10905882,10905883,10187405,10876570,10906648,10906649,10906650,10589659,10583752,10644239,10644240,10644241,10653382,10653383,10653384,10653385,10650770,10650771,10650772,10650773,10650774,10650775,10650776,10650777,10650778,10650779,10603572,10603573,10645258,10645259,10645260,10645261,10645262,10645263,10645264,10582350,10651685,10528178,10536617,10536618,10422397,10422436,10505346,10505347,10505348,10424463,10424496,10508422,10508423,10508424,10508425,10423888,10423959,10481246,10481247,10481248,10481249,10481250,10490483,10479725,10479726,10479727,10479728,10479729,10479730,10479731,10479732,10479733,10479734,10479735,10479736,10479737,10479738,10479739,10479740,10473833,10480035,10480036,10480037,10480038,10480039,10480040,10480041,10480042,10495161,10495502) 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'