En esta sección ponemos a su disposición de forma totalmente libre y gratuita los siguientes documentos de interés:
SQL error: Expression #3 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'qqy647.doc.doc_titulo' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT cat1.* FROM tbl_arc_categorias cat1 INNER JOIN tbl_arc_categorias cat2 ON cat2.cat_left BETWEEN cat1.cat_left AND cat1.cat_right INNER JOIN tbl_arc_documentos doc ON doc.cat_id = cat2.cat_id WHERE cat1.cat_level = 1 GROUP BY cat1.cat_id ORDER BY cat1.cat_titulo, cat1.cat_id, doc.doc_titulo, doc.doc_actualizado DESC
|
|