Miscellany

[test]
exten => 10,1,Mysql(Query resultid ${connid} Select count(TRC.id_ramal) from ramais_condicaotempo TRC LEFT JOIN condicaotempo TC on TRC.id_condicaotempo=TC.id_condicaotempo) ; list the rows
exten => 10,n,Mysql(Fetch fetchid ${resultid} ${cond_loop}) ; store the rows
exten => 10,n,Mysql(Clear ${resultid})
exten => 10,n,Mysql(Query resultid ${connid} select\ count\(TS\.no_tempo)\  from\ ramais\ TR\ LEFT\ JOIN\ condicaotempo\ TS\ on\ TS\.id_condicaotempo=TR\.id_condicaotempo\ where\ no_status=\'A\'\ and\ id_ramal=${CALLERIDNUM})
exten => 10,n,Mysql(Fetch fetchid ${resultid} var_row1 var_row2 var_row3) ; this line must be populated as much lines count returns
exten => 10,n,NoOp(${condicaotempo} ${condtempo})
exten => 10,n,Mysql(Clear ${resultid})
exten => 10,n,Mysql(Disconnect ${connid})
exten => 10,n,GotoIf($["${condicaotempo}" != "NULL"]?make_time:macro_exit)
exten => 10,n(make_time),GotoIfTime(${condicaotempo}?apps-redt,${app-condicaotempo},1)
exten => 10,n,NoOp(${condicaotempo})
exten => 10,n,Hangup
exten => 10,n(macro_exit),MacroExit