The Brazilian Open

0 - SQL=SELECT content.id AS iid, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.images AS images, content.featured AS frontpage, content.access AS access, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, users.name AS author_username, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid FROM suncity_content AS content LEFT JOIN suncity_categories AS categories ON categories.id = content.catid LEFT JOIN suncity_users AS users ON users.id = content.created_by LEFT JOIN suncity_content_rating AS content_rating ON content_rating.content_id = content.id WHERE ORDER BY content.created ASC

Ir para página inicial: Página Inicial.