waiting
1030 Got error 28 from storage engine
in:
[select p.products_image, p.products_name, p.quantity_map, p.products_quantity, p.products_id,p.hero_shirts,p.products_model,date(p.products_date_added) as products_date_added, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_description, IF(p.specials_status = 'Special', p.specials_price, NULL) as specials_new_products_price, IF(p.specials_status ='Special', p.specials_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status,p.groupname_id_2 as groupname_id, p.size_id_2 as size_id from new_products p left join products_attributes pr ON p.products_id = pr.products_id where p.products_status = 1 and p.language_id = '1' and (p.products_to_categories like '%#1511#%' or p.products_to_categories like '%#1512#%' or p.products_to_categories like '%#1513#%' or p.products_to_categories like '%#1515#%' or p.products_to_categories like '%#1516#%' or p.products_to_categories like '%#1518#%' or p.products_to_categories like '%#1519#%' or p.products_to_categories like '%#1520#%' or p.products_to_categories like '%#1521#%' or p.products_to_categories like '%#8215#%' or p.products_to_categories like '%#1522#%' or p.products_to_categories like '%#1523#%' or p.products_to_categories like '%#1524#%' or p.products_to_categories like '%#1525#%' or p.products_to_categories like '%#1526#%' or p.products_to_categories like '%#1527#%' or p.products_to_categories like '%#1528#%' or p.products_to_categories like '%#1529#%' or p.products_to_categories like '%#1530#%' or p.products_to_categories like '%#1531#%' or p.products_to_categories like '%#1532#%' or p.products_to_categories like '%#1533#%' or p.products_to_categories like '%#1536#%' or p.products_to_categories like '%#1537#%' or p.products_to_categories like '%#1538#%' or p.products_to_categories like '%#1539#%' or p.products_to_categories like '%#1540#%' or p.products_to_categories like '%#1541#%' or p.products_to_categories like '%#1542#%' or p.products_to_categories like '%#1543#%' or p.products_to_categories like '%#1544#%' or p.products_to_categories like '%#1545#%' or p.products_to_categories like '%#1546#%' or p.products_to_categories like '%#1547#%' or p.products_to_categories like '%#1548#%' or p.products_to_categories like '%#8013#%' or p.products_to_categories like '%#1549#%' or p.products_to_categories like '%#8250#%' or p.products_to_categories like '%#1550#%' or p.products_to_categories like '%#1551#%' or p.products_to_categories like '%#1552#%' or p.products_to_categories like '%#8022#%' or p.products_to_categories like '%#1553#%' or p.products_to_categories like '%#1554#%' or p.products_to_categories like '%#1555#%' or p.products_to_categories like '%#1556#%' or p.products_to_categories like '%#1557#%' or p.products_to_categories like '%#1558#%' or p.products_to_categories like '%#8241#%' or p.products_to_categories like '%#1559#%' or p.products_to_categories like '%#1560#%' or p.products_to_categories like '%#8008#%' or p.products_to_categories like '%#1561#%' or p.products_to_categories like '%#1562#%' or p.products_to_categories like '%#1563#%' or p.products_to_categories like '%#1564#%' or p.products_to_categories like '%#1565#%' or p.products_to_categories like '%#1566#%' or p.products_to_categories like '%#1567#%' or p.products_to_categories like '%#1568#%' or p.products_to_categories like '%#1569#%' or p.products_to_categories like '%#1570#%' or p.products_to_categories like '%#1571#%' or p.products_to_categories like '%#1572#%' or p.products_to_categories like '%#1573#%' or p.products_to_categories like '%#1574#%' or p.products_to_categories like '%#1575#%' or p.products_to_categories like '%#1576#%' or p.products_to_categories like '%#1577#%' or p.products_to_categories like '%#1578#%' or p.products_to_categories like '%#1579#%' or p.products_to_categories like '%#1580#%' or p.products_to_categories like '%#1581#%' or p.products_to_categories like '%#1583#%' or p.products_to_categories like '%#1584#%' or p.products_to_categories like '%#8282#%' or p.products_to_categories like '%#1585#%' or p.products_to_categories like '%#1586#%' or p.products_to_categories like '%#1587#%' or p.products_to_categories like '%#1588#%' or p.products_to_categories like '%#8255#%' or p.products_to_categories like '%#1589#%' or p.products_to_categories like '%#1590#%' or p.products_to_categories like '%#1591#%' or p.products_to_categories like '%#1592#%' or p.products_to_categories like '%#1593#%' or p.products_to_categories like '%#1594#%' or p.products_to_categories like '%#1595#%' or p.products_to_categories like '%#1596#%' or p.products_to_categories like '%#1597#%' or p.products_to_categories like '%#1598#%' or p.products_to_categories like '%#1599#%' or p.products_to_categories like '%#1600#%' or p.products_to_categories like '%#1601#%' or p.products_to_categories like '%#1602#%' or p.products_to_categories like '%#1603#%' or p.products_to_categories like '%#1604#%' or p.products_to_categories like '%#1606#%' or p.products_to_categories like '%#1607#%' or p.products_to_categories like '%#1608#%' or p.products_to_categories like '%#1609#%' or p.products_to_categories like '%#1610#%' or p.products_to_categories like '%#1611#%' or p.products_to_categories like '%#1612#%' or p.products_to_categories like '%#1614#%' or p.products_to_categories like '%#1615#%' or p.products_to_categories like '%#1616#%' or p.products_to_categories like '%#1618#%' or p.products_to_categories like '%#1619#%' or p.products_to_categories like '%#1622#%' or p.products_to_categories like '%#1623#%' or p.products_to_categories like '%#1624#%' or p.products_to_categories like '%#1625#%' or p.products_to_categories like '%#1869#%' or p.products_to_categories like '%#1870#%' or p.products_to_categories like '%#1872#%' or p.products_to_categories like '%#1873#%' or p.products_to_categories like '%#1876#%' or p.products_to_categories like '%#1986#%' or p.products_to_categories like '%#2003#%' or p.products_to_categories like '%#1510#%') group by p.products_id order by p.products_sort_order,ISNULL(p.groupname_id_1 || p.groupname_id_2),ISNULL(p.size_id_1 || p.size_id_2),p.groupname_id_1, p.size_id_1,p.groupname_id_2, p.size_id_2 asc,p.products_id DESC limit 0, 48]