SELECT DISTINCT YEAR(chyxy_posts.created_at) AS year, MONTH(chyxy_posts.created_at) AS month, chyxy_posts.created_at AS created_at FROM chyxy_posts WHERE (chyxy_posts.status = 'public') GROUP BY YEAR(chyxy_posts.created_at), MONTH(chyxy_posts.created_at) ORDER BY chyxy_posts.created_at DESCArray ( [:status] => public )#0 /home/joek/public_html/includes/class/SQL.php(220): Query->__construct(Object(SQL), 'SELECT DISTINCT...', Array, false) #1 /home/joek/public_html/includes/class/SQL.php(257): SQL->query('SELECT DISTINCT...', Array, false) #2 /home/joek/public_html/includes/controller/Main.php(286): SQL->select('posts', Array, Array, Array, Array, NULL, NULL, Array) #3 /home/joek/public_html/includes/class/Route.php(115): MainController->archive() #4 /home/joek/public_html/index.php(22): Route->init() #5 {main}Log In →
Chyrp 2.5.2 © Chyrp Team 2019