SELECT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams, u.userName AS nomeColunista , u.image AS imgColunista , u.userID AS idColunista FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid LEFT JOIN #__k2_users u ON u.userID = i.created_by WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2016-08-25 14:39:23' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-08-25 14:39:23' ) AND i.catid IN (SELECT id FROM #__k2_categories WHERE parent IN (1,18) AND id NOT IN (1,18) AND published=1 AND trash=0) OR i.id IN (SELECT itemID FROM #__k2_additional_categories WHERE catid IN(1,18 ) )  ORDER BY i.publish_up DESC LIMIT 0 , 5
Produtos e Serviços : Guia de Fornecedores Cotações Online
Categorias
SELECT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams, u.userName AS nomeColunista , u.image AS imgColunista , u.userID AS idColunista FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid LEFT JOIN #__k2_users u ON u.userID = i.created_by WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2016-08-25 14:39:23' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-08-25 14:39:23' ) AND i.catid=11 AND i.catid IN(11) OR i.id IN (SELECT itemID FROM #__k2_additional_categories WHERE catid IN(11 ) )  ORDER BY i.created DESC LIMIT 0 , 6
Seções
SELECT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams, u.userName AS nomeColunista , u.image AS imgColunista , u.userID AS idColunista FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid LEFT JOIN #__k2_users u ON u.userID = i.created_by WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2016-08-25 14:39:23' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-08-25 14:39:23' ) AND i.catid=31 AND i.catid IN(31) OR i.id IN (SELECT itemID FROM #__k2_additional_categories WHERE catid IN(31 ) )  ORDER BY i.created DESC LIMIT 0 , 2
SELECT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams, u.userName AS nomeColunista , u.image AS imgColunista , u.userID AS idColunista FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid LEFT JOIN #__k2_users u ON u.userID = i.created_by WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2016-08-25 14:39:23' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-08-25 14:39:23' ) AND i.catid=33 AND i.catid IN(33) OR i.id IN (SELECT itemID FROM #__k2_additional_categories WHERE catid IN(33 ) )  ORDER BY i.created DESC LIMIT 0 , 2
SELECT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams, u.userName AS nomeColunista , u.image AS imgColunista , u.userID AS idColunista FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid LEFT JOIN #__k2_users u ON u.userID = i.created_by WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2016-08-25 14:39:23' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-08-25 14:39:23' ) AND i.catid=30 AND i.catid IN(30) OR i.id IN (SELECT itemID FROM #__k2_additional_categories WHERE catid IN(30 ) )  ORDER BY i.created DESC LIMIT 0 , 2
SELECT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams, u.userName AS nomeColunista , u.image AS imgColunista , u.userID AS idColunista FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid LEFT JOIN #__k2_users u ON u.userID = i.created_by WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2016-08-25 14:39:23' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-08-25 14:39:23' ) AND i.catid=5 AND i.catid IN(5) OR i.id IN (SELECT itemID FROM #__k2_additional_categories WHERE catid IN(5 ) )  ORDER BY i.id DESC LIMIT 0 , 6
Enquete

Como o seu condomínio escolhe um fornecedor de produtos ou serviços?

SELECT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams, u.userName AS nomeColunista , u.image AS imgColunista , u.userID AS idColunista FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid AND i.published = 1  LEFT JOIN #__k2_users u ON u.userID = i.created_by WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2016-08-25 14:39:23' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-08-25 14:39:23' ) AND i.catid=39 AND ( i.catid IN(39) OR i.id IN (SELECT itemID FROM #__k2_additional_categories WHERE catid IN(39 ) ) )AND i.id in (SELECT MAX(id) As id FROM #__k2_items GROUP BY created_by ORDER by created_by) ORDER BY i.created DESC LIMIT 0 , 3
Acesse sua Administradora