string(1697) "select distinct a.authors_id, a.authors_name, a.authors_image, a.date_added, a.last_modified, a.site, ai.languages_id, ai.url_clicked, ai.date_last_click, ai.authors_description , COUNT(distinct p.products_id) as total from products p INNER JOIN products_actors pa ON pa.products_id = p.products_id INNER JOIN products_authors a ON a.authors_id=pa.actors_id INNER JOIN products_authors_info ai ON a.authors_id=ai.authors_id LEFT JOIN products_to_categories as __products__to__categories__ ON __products__to__categories__.products_id = p.products_id LEFT JOIN categories as __category__1 ON __category__1.categories_id = __products__to__categories__.categories_id LEFT JOIN categories as __category__2 ON __category__2.categories_id = __category__1.parent_id LEFT JOIN categories as __category__3 ON __category__3.categories_id = __category__2.parent_id LEFT JOIN categories as __category__4 ON __category__4.categories_id = __category__3.parent_id LEFT JOIN categories as __category__5 ON __category__5.categories_id = __category__4.parent_id where pa.actors_id = '10000683' and ai.authors_id = '10000683' and ai.languages_id = '1' GROUP BY a.authors_id, a.authors_name, a.authors_image, a.date_added, a.last_modified, a.site, ai.languages_id, ai.url_clicked, ai.date_last_click, ai.authors_description "