Server shutdown in progress
SELECT p.*, IF(LENGTH(name_lv), name_lv, name_lv) AS _name_sort FROM SC_products p WHERE( ( (p.productID IN (1133116,1163295,1204875,1204885,1204892,1205263,1231561,1232876,1236685,1236686,1240975,1240997,1240998,1241052,1241137,1244470,1244477,1244527,1244539,1244549,1244815,1245372,1254615,1254616,1254656,1254667,1254668,1254669,1263222,1263313,1269418,1269489,1269948,1269949,1270142,1270143,1278389,1278390,1278391,1278392,1280841,1280852,1280854,1280891,1281056,1281067,1281068,1281090,1281119,1283675,1284766,1284769,1284771,1285518,1285525,1286506,1286509,1286532,1287029,1287133,1287216,1287217,1287218,1287220,1287221,1287222,1287229,1287232,1287234,1287235,1287236,1287239,1287354,1287355,1287781)) OR (p.categoryID IN (24016373)) ) AND ( enabled=1)) AND in_country_lv=1 AND p.productID NOT IN (SELECT productID FROM SC_category_product cp1, SC_categories c1
WHERE cp1.categoryID=c1.categoryID AND c1.disabled=1 AND cp1.productID=p.productID AND p.hidden_category_visable=0) AND p.productID NOT IN (SELECT productID FROM SC_category_product cp1 WHERE cp1.productID=p.productID AND cp1.categoryID IN (3671,6163,6955,12835,23980021,23980964,23984349,25453885,25986857,23980024,23980026,23980022,23980025,23980023,23987770,23987768,23987769,23987771)) ORDER BY sort_order, _name_sort LIMIT 0,40