Index: branches/5.2.x/units/reports/reports_tag_processor.php =================================================================== diff -u -N -r14569 -r15009 --- branches/5.2.x/units/reports/reports_tag_processor.php (.../reports_tag_processor.php) (revision 14569) +++ branches/5.2.x/units/reports/reports_tag_processor.php (.../reports_tag_processor.php) (revision 15009) @@ -1,6 +1,6 @@ Application->RecallVar('report_options')); $per_step = 20; - $cats = $this->Conn->Query('SELECT * FROM '.TABLE_PREFIX.'Category ORDER BY CategoryId LIMIT '.$field_values['offset'].', '.$per_step); + $cats = $this->Conn->Query('SELECT * FROM '.TABLE_PREFIX.'Categories ORDER BY CategoryId LIMIT '.$field_values['offset'].', '.$per_step); foreach ($cats as $a_cat) { if ($field_values['Recursive']) { @@ -62,7 +62,7 @@ ON p.ProductId = od.ProductId LEFT JOIN '.TABLE_PREFIX.'CategoryItems AS ci ON ci.ItemResourceId = p.ResourceId - LEFT JOIN '.TABLE_PREFIX.'Category AS c + LEFT JOIN '.TABLE_PREFIX.'Categories AS c ON c.CategoryId = ci.CategoryId WHERE o.Status = 4 @@ -288,7 +288,7 @@ ON p.ProductId = od.ProductId LEFT JOIN '.TABLE_PREFIX.'CategoryItems AS ci ON ci.ItemResourceId = p.ResourceId - LEFT JOIN '.TABLE_PREFIX.'Category AS c + LEFT JOIN '.TABLE_PREFIX.'Categories AS c ON c.CategoryId = ci.CategoryId '.$ebay_joins.' WHERE @@ -315,7 +315,7 @@ ON p.ProductId = od.ProductId LEFT JOIN '.TABLE_PREFIX.'CategoryItems AS ci ON ci.ItemResourceId = p.ResourceId - LEFT JOIN '.TABLE_PREFIX.'Category AS c + LEFT JOIN '.TABLE_PREFIX.'Categories AS c ON c.CategoryId = ci.CategoryId '.$ebay_joins.' WHERE