{exp:weblog:entries weblog="{my_weblog}" limit="{my_limit}" orderby="date" sort="{my_sortOrder}" status="open"}
{paginate}
{/paginate}
{if count==6}
{if:else}
{/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}
{/exp:weblog:entries}
{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}
