query
RESULTSET
query
  BEZEICHNUNG COUNTARTICLES ID INSTANCE NAME PERMALINK TYPEID TYPE_PERMALINK
1 Foto-Praxis 80 11 inspiration Nikon MAGAZIN Foto-Praxis 1 nikon-magazin
2 Kamera Know-How 50 3 inspiration Nikon MAGAZIN Kamera-Know-How 1 nikon-magazin
3 Interviews 46 4 inspiration Nikon MAGAZIN Interviews 1 nikon-magazin
4 Reiseberichte 17 2 inspiration Nikon MAGAZIN Reiseberichte 1 nikon-magazin
5 Nikon Geschichte 5 6 inspiration Nikon MAGAZIN Nikon-Geschichte 1 nikon-magazin
6 Professional 4 9 inspiration Nikon MAGAZIN Professional 1 nikon-magazin
7 Wettbewerbe 1 7 inspiration Nikon MAGAZIN Wettbewerbe 1 nikon-magazin
CACHED false
EXECUTIONTIME 0
SQL SELECT c.id, c.bezeichnung, c.typeId, c.permalink, COUNT(a.id) as countArticles, t.name, t.instance, t.permalink as type_permalink FROM nikonglobal.dbo.inspiration_category c LEFT JOIN nikonglobal.dbo.inspiration_article a ON c.id = a.categoryId LEFT JOIN nikonglobal.dbo.inspiration_type t ON t.id = c.typeId WHERE a.active = 1 AND (a.fromDate IS NULL OR a.fromDate <= ?) AND a.show_ch = 1 AND c.typeId = 1 GROUP BY c.id, c.bezeichnung, c.typeId, c.permalink, t.name, t.instance, t.permalink ORDER BY COUNT(a.id) DESC
SQLPARAMETERS
array
1 2020-09-21 11:55:27.125
Keine Artikel gefunden.

ZURÜCK