SELECT * FROM CM_ArticleModel WHERE 1 AND category = "ristoranti" AND (language = "it" OR language = "all") AND deleted = 0 AND searchable = 1 AND (expirationDate > NOW() OR expirationDate IS NULL) AND (publishDate <= NOW() OR publishDate IS NULL) AND (type = "articolo" OR type = "ilnipposario" OR type = "notizia-del-giorno") AND MATCH (title,content,tags) AGAINST (" publishdate ") ORDER BY MATCH (title,content,tags) AGAINST (" publishdate ") DESC, publishDate DESC LIMIT 0, 18
SELECT * FROM CM_ArticleModel WHERE 1 AND category = "ristoranti" AND (language = "it" OR language = "all") AND deleted = 0 AND searchable = 1 AND (expirationDate > NOW() OR expirationDate IS NULL) AND (publishDate <= NOW() OR publishDate IS NULL) AND type = "anagrafica" AND MATCH (title,comune,tags) AGAINST ("publishdate") ORDER BY MATCH (title,comune,tags) AGAINST ("publishdate") DESC, title ASC LIMIT 0, 40