Rubriche

SELECT iv_articles.id, iv_articles._title AS title, iv_articles._seo AS seo, iv_articles._text AS text, DATE_FORMAT(iv_articles._date, "%Y-%m-%d") AS timestamp, iv_articles._alias AS alias, iv_articles._path AS path, iv_articles._src AS src, (SELECT iv_rubrics._name FROM iv_rubrics WHERE iv_rubrics.id = 9) AS rubric_name, (SELECT iv_rubrics._seo FROM iv_rubrics WHERE iv_rubrics.id = 9) AS rubric_seo, (SELECT iv_rubrics._image FROM iv_rubrics WHERE iv_rubrics.id = iv_articles._rubric) AS rubric_image FROM iv_articles JOIN iv_articles_categories ON iv_articles_categories._art = iv_articles.id WHERE iv_articles_categories._cat = 10 AND iv_articles._deleted = "0" AND iv_articles._published = "1" AND iv_articles._rubric = "9" ORDER BY iv_articles._date DESC LIMIT 1SELECT iv_articles.id, iv_articles._title AS title, iv_articles._seo AS seo, iv_articles._text AS text, DATE_FORMAT(iv_articles._date, "%Y-%m-%d") AS timestamp, iv_articles._alias AS alias, iv_articles._path AS path, iv_articles._src AS src, (SELECT iv_rubrics._name FROM iv_rubrics WHERE iv_rubrics.id = 3) AS rubric_name, (SELECT iv_rubrics._seo FROM iv_rubrics WHERE iv_rubrics.id = 3) AS rubric_seo, (SELECT iv_rubrics._image FROM iv_rubrics WHERE iv_rubrics.id = iv_articles._rubric) AS rubric_image FROM iv_articles JOIN iv_articles_categories ON iv_articles_categories._art = iv_articles.id WHERE iv_articles_categories._cat = 10 AND iv_articles._deleted = "0" AND iv_articles._published = "1" AND iv_articles._rubric = "3" ORDER BY iv_articles._date DESC LIMIT 1SELECT iv_articles.id, iv_articles._title AS title, iv_articles._seo AS seo, iv_articles._text AS text, DATE_FORMAT(iv_articles._date, "%Y-%m-%d") AS timestamp, iv_articles._alias AS alias, iv_articles._path AS path, iv_articles._src AS src, (SELECT iv_rubrics._name FROM iv_rubrics WHERE iv_rubrics.id = 8) AS rubric_name, (SELECT iv_rubrics._seo FROM iv_rubrics WHERE iv_rubrics.id = 8) AS rubric_seo, (SELECT iv_rubrics._image FROM iv_rubrics WHERE iv_rubrics.id = iv_articles._rubric) AS rubric_image FROM iv_articles JOIN iv_articles_categories ON iv_articles_categories._art = iv_articles.id WHERE iv_articles_categories._cat = 10 AND iv_articles._deleted = "0" AND iv_articles._published = "1" AND iv_articles._rubric = "8" ORDER BY iv_articles._date DESC LIMIT 1SELECT iv_articles.id, iv_articles._title AS title, iv_articles._seo AS seo, iv_articles._text AS text, DATE_FORMAT(iv_articles._date, "%Y-%m-%d") AS timestamp, iv_articles._alias AS alias, iv_articles._path AS path, iv_articles._src AS src, (SELECT iv_rubrics._name FROM iv_rubrics WHERE iv_rubrics.id = 11) AS rubric_name, (SELECT iv_rubrics._seo FROM iv_rubrics WHERE iv_rubrics.id = 11) AS rubric_seo, (SELECT iv_rubrics._image FROM iv_rubrics WHERE iv_rubrics.id = iv_articles._rubric) AS rubric_image FROM iv_articles JOIN iv_articles_categories ON iv_articles_categories._art = iv_articles.id WHERE iv_articles_categories._cat = 10 AND iv_articles._deleted = "0" AND iv_articles._published = "1" AND iv_articles._rubric = "11" ORDER BY iv_articles._date DESC LIMIT 1SELECT iv_articles.id, iv_articles._title AS title, iv_articles._seo AS seo, iv_articles._text AS text, DATE_FORMAT(iv_articles._date, "%Y-%m-%d") AS timestamp, iv_articles._alias AS alias, iv_articles._path AS path, iv_articles._src AS src, (SELECT iv_rubrics._name FROM iv_rubrics WHERE iv_rubrics.id = 10) AS rubric_name, (SELECT iv_rubrics._seo FROM iv_rubrics WHERE iv_rubrics.id = 10) AS rubric_seo, (SELECT iv_rubrics._image FROM iv_rubrics WHERE iv_rubrics.id = iv_articles._rubric) AS rubric_image FROM iv_articles JOIN iv_articles_categories ON iv_articles_categories._art = iv_articles.id WHERE iv_articles_categories._cat = 10 AND iv_articles._deleted = "0" AND iv_articles._published = "1" AND iv_articles._rubric = "10" ORDER BY iv_articles._date DESC LIMIT 1SELECT iv_articles.id, iv_articles._title AS title, iv_articles._seo AS seo, iv_articles._text AS text, DATE_FORMAT(iv_articles._date, "%Y-%m-%d") AS timestamp, iv_articles._alias AS alias, iv_articles._path AS path, iv_articles._src AS src, (SELECT iv_rubrics._name FROM iv_rubrics WHERE iv_rubrics.id = 4) AS rubric_name, (SELECT iv_rubrics._seo FROM iv_rubrics WHERE iv_rubrics.id = 4) AS rubric_seo, (SELECT iv_rubrics._image FROM iv_rubrics WHERE iv_rubrics.id = iv_articles._rubric) AS rubric_image FROM iv_articles JOIN iv_articles_categories ON iv_articles_categories._art = iv_articles.id WHERE iv_articles_categories._cat = 10 AND iv_articles._deleted = "0" AND iv_articles._published = "1" AND iv_articles._rubric = "4" ORDER BY iv_articles._date DESC LIMIT 1SELECT iv_articles.id, iv_articles._title AS title, iv_articles._seo AS seo, iv_articles._text AS text, DATE_FORMAT(iv_articles._date, "%Y-%m-%d") AS timestamp, iv_articles._alias AS alias, iv_articles._path AS path, iv_articles._src AS src, (SELECT iv_rubrics._name FROM iv_rubrics WHERE iv_rubrics.id = 7) AS rubric_name, (SELECT iv_rubrics._seo FROM iv_rubrics WHERE iv_rubrics.id = 7) AS rubric_seo, (SELECT iv_rubrics._image FROM iv_rubrics WHERE iv_rubrics.id = iv_articles._rubric) AS rubric_image FROM iv_articles JOIN iv_articles_categories ON iv_articles_categories._art = iv_articles.id WHERE iv_articles_categories._cat = 10 AND iv_articles._deleted = "0" AND iv_articles._published = "1" AND iv_articles._rubric = "7" ORDER BY iv_articles._date DESC LIMIT 1