1146 Table 'purplezen.product_book_extra' doesn't exist
in:
[select distinct c.categories_id as id, cd.categories_name as name
from products p, products_to_categories p2c, categories c, categories_description cd, product_book_extra pme, books_to_genres bta
where p.products_status = 1
and pme.products_id = p2c.products_id
and p.products_id = p2c.products_id
and p2c.categories_id = c.categories_id
and p2c.categories_id = cd.categories_id
and cd.language_id = '1'
and bta.book_genre_id = '8'
and bta.products_id = p.products_id
order by cd.categories_name]