I have the following query and just noticed is not returning the expected results.
{exp:query sql='SELECT cat_id FROM exp_categories WHERE cat_url_title = "{segment_4}"' }
{cat_id}
{embed="fixtures/.weekly_fixtures" catnum="{cat_id}&" start="<?php echo $start_time; ?>" stop="<?php echo $end_time; ?>"}
{/exp:query}Should actually return two cat_id but instead it is returning 1. If I run the query directly in my phpmyadmin it returns the expected results.