Browse

Genre



Article Genres

SELECT *, COUNT(article_genre_drp_id) AS occ FROM article_genre LEFT JOIN article_genre_drp ON art_genre_id = article_genre_drp_id LEFT JOIN article ON article_genre_id = article_id LEFT JOIN issue ON issue_id = article_issue_id LEFT JOIN magazine ON issue_magazine_id = magazin_id WHERE publish_on_home = 1 GROUP BY article_genre_drp_id ORDER BY LOWER(art_genre_eng) ASC Disk full (/tmp/#sql_22ea_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")