Query failed: SELECT DISTINCT b.id, b.isbn, b.isbn13, b.title, b.publisher_id, b.imprint_id, b.series, b.pages, b.publication_date, b.street_date, b.edition, b.reprint, b.url, b.url_text, b.price, b.tagline, p.name as publisher_name, bt.text as summary, i.name as imprint_name FROM book b, publisher p, genre g, genre_map gm LEFT JOIN book_text bt ON bt.type = 'Summary' and bt.book_id = b.id LEFT JOIN imprint i ON b.imprint_id = i.id WHERE b.publisher_id = p.id AND b.publication_date between from_unixtime(1328072399) and from_unixtime(1330577940) and gm.book_id = b.id and ((gm.genre_id = '36') || (gm.genre_id = '37') || (gm.genre_id = '140') || (gm.genre_id = '141')|| (gm.genre_id = '38')) ORDER BY b.publication_date DESC