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 = '10000202'
and ai.authors_id = '10000202'
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 "
Cartile autorului - LibrariaOnline.ro
Acest site folosește cookies pentru a furniza servicii și funcționalități personalizate. Prin vizitarea site-ului nostru, îți dai acordul pentru descărcarea acestor cookies.
Am inteles