0
SQL=SELECT a.id,a.title,a.introtext,DATE_FORMAT(a.created, "%Y-%m-%d") as created,a.catid,cc.access AS cat_access,cc.published AS cat_state,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug FROM zzsq_content AS a LEFT JOIN zzsq_content_frontpage AS f ON f.content_id = a.id LEFT JOIN zzsq_categories AS cc ON cc.id = a.catid WHERE a.id != 40021 AND a.state = 1 AND a.access IN (1,1) AND 1 = 2 OR a.catid IN (79,151,144,109,110,111,115,90,112,113,147,116,117,78,128,142,148,123,114,80,91,93,127) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-02-14 12:35:51') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-02-14 12:35:51') order by rand() LIMIT 0, 1
Home Page