{assign_variable:my_weblog="writer|filmmaker"} {assign_variable:my_sortOrder="desc"} {assign_variable:my_template_group="site"} {embed="site/_header"} {embed="site/_nav"} {assign_variable:my_limit="6"}
{exp:weblog:entries weblog="{my_weblog}" limit="{my_limit}" orderby="date" sort="{my_sortOrder}" status="open"} {paginate} {/paginate} {if count==6}
{if:else}
{/if}
{/exp:weblog:entries}
{exp:reeposition} {exp:weblog:entries weblog="{my_weblog}" limit="{my_limit}" orderby="date" sort="{my_sortOrder}" status="open"} {paginate} {reeposition:item}{pagination_links}{/reeposition:item} {/paginate}
{if weblog_short_name=='writer'} {exp:query sql="SELECT relate.rel_child_id as rel_artistID, titles.title as rel_columnName FROM exp_relationships as relate, exp_weblog_titles as titles WHERE relate.rel_id = {writer_category} AND titles.entry_id = rel_child_id "}{rel_columnName}{/exp:query} {if:elseif weblog_short_name=='filmmaker'} {exp:query sql="SELECT relate.rel_child_id as rel_artistID, titles.title as rel_columnName FROM exp_relationships as relate, exp_weblog_titles as titles WHERE relate.rel_id = {filmmaker_category} AND titles.entry_id = rel_child_id "}{rel_columnName}{/exp:query} {if:else} {exp:query sql="SELECT relate.rel_child_id as rel_artistID, titles.title as rel_columnName FROM exp_relationships as relate, exp_weblog_titles as titles WHERE relate.rel_id = {performer_category} AND titles.entry_id = rel_child_id "}{rel_columnName}{/exp:query} {/if}
{entry_date format="%m.%d"}
{title}
{exp:query sql="SELECT AVG(s.rating) AS ave_rating FROM exp_ez_rate_stats s WHERE s.entry_id = {entry_id} AND module_name = 'weblog' GROUP BY s.entry_id"}
{/exp:query}
{/exp:weblog:entries}
{exp:weblog:entries weblog="{my_weblog}" limit="{my_limit}" orderby="date" sort="{my_sortOrder}" status="open"} {paginate} {/paginate}
{/exp:weblog:entries}
{reeposition:put_item}
{/exp:reeposition}