Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 882 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 882 Rev 935
Line 122... Line 122...
122 
SELECT SUM(theorie.a) AS théorie, pratique.a AS total FROM \
 122 
SELECT SUM(theorie.a) AS théorie, pratique.a AS total FROM \
123 
	(SELECT COUNT(1) AS a FROM `BASESOURCE`.`TABLEBDTFX` UNION ALL \
 123 
	(SELECT COUNT(1) AS a FROM `BASESOURCE`.`TABLEBDTFX` UNION ALL \
124 
	 SELECT COUNT(1) AS a FROM `BASESOURCE`.`TABLEBDTXA` UNION ALL \
 124 
	 SELECT COUNT(1) AS a FROM `BASESOURCE`.`TABLEBDTXA` UNION ALL \
125 
	 SELECT COUNT(1) AS a FROM `BASESOURCE`.`TABLEISFAN` \
 125 
	 SELECT COUNT(1) AS a FROM `BASESOURCE`.`TABLEISFAN` \
126 
	) AS theorie, \
 126 
	) AS theorie, \
127 
	(SELECT COUNT(1) AS a FROM tb_cel.cel_references) AS pratique;
 127 
	(SELECT COUNT(1) AS a FROM `BASEEDIT`.cel_references) AS pratique;
128 
-- bdtfx+bdtxa+isfan: 141181 (2013/07/23)
 128 
-- bdtfx+bdtxa+isfan: 141181 (2013/07/23)