Warning: mysqli_query(): (HY000/126): Got error '126 "Index is corrupted"' for '/tmp/#sql-temptable-248a1d-b04670-33d10b.MAI' in /home/computerland/public_html/includes/functions/database.php on line 189
126 - Got error '126 "Index is corrupted"' for '/tmp/#sql-temptable-248a1d-b04670-33d10b.MAI'

select distinct p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, p.products_image_orientation, s.specials_new_products_price, s.specials_price_catalog, p.products_price_cash, p.products_stock_status_id, p.products_quantity, pd.products_short_description, m.manufacturers_name from products p inner join products_to_domains p2d on p2d.products_id=p.products_id and p2d.domains_id='4' left join manufacturers m using(manufacturers_id), products_description pd left join specials s on s.status = '1' and s.customers_group_id = 0 and s.products_id=pd.products_id, products_to_categories p2c, categories c inner join categories_to_domains c2d on c2d.categories_id=c.categories_id and c2d.domains_id='4' where p2c.categories_id=c.categories_id and p2c.products_id=p.products_id and c.categories_status=1 and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '6' and p.products_id<>'0' and p.parent_id=0 order by p.products_date_added DESC limit 60

[TEP STOP]