SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.titel AS titel_2, c0_.titel_url AS titel_url_3, c0_.time_public AS time_public_4, c0_.time_tracker AS time_tracker_5, c0_.icon AS icon_6, c0_.status AS status_7, u1_.user AS user_8, c2_.comments AS comments_9, c2_.views AS views_10, c2_.reports AS reports_11, c3_.member AS member_12, c3_.voornaam AS voornaam_13, c3_.achternaam AS achternaam_14, c3_.dateLine AS dateLine_15 FROM content_items c0_ INNER JOIN content_categories_items c5_ ON c0_.id = c5_.item_id INNER JOIN content_categories c4_ ON c4_.id = c5_.categorie_id INNER JOIN fokcentral.users u1_ ON c0_.user = u1_.user LEFT JOIN content_item_counters c2_ ON (c2_.content_id = c0_.id) INNER JOIN fokfrontpage.crew c3_ ON (c3_.user = u1_.user) WHERE c0_.status = 'active' AND c0_.time_public <= UNIX_TIMESTAMP() AND c4_.id = ? ORDER BY c0_.time_tracker DESC LIMIT 10