Julianna Douglas
Sweetly Sensual Romance
[--
sql_select
db_connection = "'blog'"
results_variable = "@post_ids"
sql = "$post_ids_sql_select"
values = "@values"
--]
[--
sql_select
db_connection = "'blog'"
results_variable = "$item_count"
sql = "$post_ids_count_sql_select"
values = "@values"
--]
Archives
-
[--
sql_select
db_connection = "'blog'"
iterator = "$right_archives"
sql = 'qq{SELECT
DATE_FORMAT(post.created, "%M") AS month,
DATE_FORMAT(post.created, "%Y") AS year,
count(post.post_id) AS post_count
FROM
post
GROUP BY
year,
month
ORDER BY
MAX(post.created) DESC
LIMIT 5}'
--]
[--
format_data
iterator = "$right_archives"
row_format =
'sprintf
(
qq{
- %s %s (%d) \n}, $row->{month}, $row->{year}, $row->{month}, $row->{year}, $row->{post_count}, )' --]
Categories
-
[--
sql_select
db_connection = "'blog'"
results_variable = "@right_categories"
sql = "q{SELECT
category.category_name
FROM
category
ORDER BY
category.category_name
LIMIT 5}"
--]
