1194 - Table 'opa' is marked as crashed and should be repaired

[millbilly]

Pretty handed with MySQL/PHPmyadmin to repair the table - but stumped. I do not see a table "opa"

Full error message:
1194 - Table 'opa' is marked as crashed and should be repaired

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '9' and opa.orders_id = opb.orders_id and opb.products_id != '9' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

Many thanks in advance for help-

[pgmarshall]

opb is referenced in also_purchased_products.php as TABLE_ORDERS_PRODUCTS

If you look in database_tables.php this relates to orders_products

Regards,

[millbilly]

Thanks much! Backed up, repaired and optimized.