Rubrik:
    Ausgabe: 

SELECT count(distinct T2.id) FROM thes_artikel_hilf AS T1 INNER JOIN ha_artikel AS T2 ON T1.artikel_id = T2.id WHERE ostart <= 1425536954 AND T1.thes_id IN (9984, 9985) AND T2.id NOT IN (SELECT artikel_id FROM thes_artikel_hilf WHERE thes_id IN (9988, 9994, 9995, 9998, 9999)) AND artikeltyp='ha' AND T2.objekt IN ('BDW')

SELECT distinct T2.id, T2.ostart, T2.otime, T2.ausgabe, T2.seite, T2.objekt, T2.dachzeile, T2.htitel, T2.vorspann, T2.artikel, T2.thema, T2.autor, T2.artikeltyp, T1.thes_id FROM thes_artikel_hilf AS T1 INNER JOIN ha_artikel AS T2 ON T1.artikel_id = T2.id WHERE ostart <= 1425536954 AND T1.thes_id IN (9984, 9985) AND T2.id NOT IN (SELECT artikel_id FROM thes_artikel_hilf WHERE thes_id IN (9988, 9994, 9995, 9998, 9999)) AND artikeltyp='ha' AND T2.objekt IN ('BDW') ORDER BY ausgabe DESC, seite ASC LIMIT 30,10

Autor:

Volltext:

Keine Suchergebnisse gefunden!