[REQUETE]
NOM="QRY_contafechados"
SQL="SELECT  	COUNT(Anodesportivo.Fechado) AS Count_1 FROM  	Anodesportivo WHERE  	Anodesportivo.Fechado = 'False'"
ARBRE="/* Génération automatique de l'abre de la requête QRY_contafechados */ $clRequete = null; if (!bReloadFrom($clRequete,'res/QRY_contafechados_cache_17')) {  $clRequeteSelection_1 = new FMK_SQL_Requete(1); $clClauseSelect_2 = new FMK_SQL_Select(); $clClauseSelect_2->m_eOPTIONSELECT = 1; $clOpAgregat_3 = new FMK_SQL_OpExpression(31,'COUNT','COUNT(Anodesportivo.Fechado)'); $clRubExpSimple_4 = new FMK_SQL_Rubrique(); $clRubExpSimple_4->m_sNom = 'Anodesportivo.Fechado'; $clRubExpSimple_4->m_sAlias = 'Fechado'; $clRubExpSimple_4->m_sNomFichier = 'Anodesportivo'; $clRubExpSimple_4->m_sAliasFichier = 'Anodesportivo'; $clRubExpSimple_4->m_nPosDebut = 16; $clRubExpSimple_4->m_nPosFin = 36; $clOpAgregat_3->add($clRubExpSimple_4); $clOpAgregat_3->m_tabOptionsExpression['eOPTIONSELECT'] = 1; $clOpAgregat_3->m_nPosDebut = 10; $clOpAgregat_3->m_nPosFin = 37; $clOpAgregat_3->m_sAlias = 'Count_1'; $clClauseSelect_2->add($clOpAgregat_3); $clRequeteSelection_1->m_clSelect =& $clClauseSelect_2; $clClauseFrom_5 = new FMK_SQL_From(); $clFromFichier_6 = new FMK_SQL_Fichier(); $clFromFichier_6->m_sNom = 'Anodesportivo'; $clFromFichier_6->m_sAlias = ''; $clClauseFrom_5->add($clFromFichier_6); $clRequeteSelection_1->m_clFrom =& $clClauseFrom_5; $clClauseWhere_7 = null; $clClauseWhere_7 = new FMK_SQL_Where(); $clOpExp_8 = new FMK_SQL_OpExpression(9,'=','Anodesportivo.Fechado = \'False\''); $clRubExpSimple_9 = new FMK_SQL_Rubrique(); $clRubExpSimple_9->m_sNom = 'Anodesportivo.Fechado'; $clRubExpSimple_9->m_sAlias = 'Fechado'; $clRubExpSimple_9->m_sNomFichier = 'Anodesportivo'; $clRubExpSimple_9->m_sAliasFichier = 'Anodesportivo'; $clRubExpSimple_9->m_nPosDebut = 83; $clRubExpSimple_9->m_nPosFin = 103; $clRubExpSimple_9->m_nPosDebut = 83; $clRubExpSimple_9->m_nPosFin = 103; $clOpExp_8->add($clRubExpSimple_9); $xOP_LIT_10 = new FMK_SQL_Item(); $xOP_LIT_10->m_sNom = 0; $xOP_LIT_10->m_nPosDebut = 107; $xOP_LIT_10->m_nPosFin = 113; $clOpExp_8->add($xOP_LIT_10); $clOpExp_8->m_nPosDebut = 83; $clOpExp_8->m_nPosFin = 113; $clClauseWhere_7->add($clOpExp_8); $clRequeteSelection_1->m_clWhere =& $clClauseWhere_7; $clClauseGroupBy_11 = null; $clRequeteSelection_1->m_clGroupBy =& $clClauseGroupBy_11; $clClauseHaving_12 = null; $clRequeteSelection_1->m_clHaving =& $clClauseHaving_12; $clClauseOrderBy_13 = null; $clRequeteSelection_1->m_clOrderBy =& $clClauseOrderBy_13; $clClauseLimit_14 = new FMK_SQL_Limit(); $clClauseLimit_14->m_nType = 0; $clClauseLimit_14->m_nNombreEnregs = -1; $clClauseLimit_14->m_nDepuis = 0; $clRequeteSelection_1->m_clLimit =& $clClauseLimit_14; $clRequete =& $clRequeteSelection_1; $clRequete->m_sNom = 'QRY_contafechados'; $clRequete->m_sCodeOriginel = 'SELECT  	COUNT(Anodesportivo.Fechado) AS Count_1 FROM  	Anodesportivo WHERE  	Anodesportivo.Fechado = \'False\''; $clRequete->term('res/QRY_contafechados_cache_17'); } //fin du test de reload depuis le cache "
ARBRE_CACHE="res/QRY_contafechados_cache_17"
[PARAMETRES]
NB=0

[RUBRIQUES]
NB=1
ALIAS0="Count_1"
FICHIER0=""
RUBRIQUE0="Count_1"

[FICHIERS]
NB=1
FICHIER0="Anodesportivo"
FICHIERCONNEXION0="Mysql_conn"

[TRIS]
NB=0