Revision c2f4b2304287f54ec6fbaf00ec2cc7263bd97075
Committed on 18/07/2016 12:56 am by
Bruno Fassino <[email protected]> [GitHub Diff]
Corrections to CustomQueries
1) Query objects_with_multiple_main_nodes: a table name is missing (" FROM o, ezcontentobject_tree n")
2) Query objects_with_bad_attribute_count: It is OK, but when used as subquery just to get the count of the results, an error
Error Code: 1060. Duplicate column name 'contentclass_id'
is produced, at least in MySQL which does not accept duplicated column names in subqueries. To avoid this I added an alias to the first occurrence of the name.
