Psicólogos tcc

SQL: [397] SELECT DISTINCT d.idDepartamento, d.isoPais, d.nombreDep, d.uriDep, d.textDep

SQL: [41] SELECT * FROM tags ORDER BY nombreTag ASC

SQL: [373] SELECT DISTINCT(t.id_login), t.* from terapeutas t LEFT JOIN login l ON t.id_login=l.id LEFT JOIN zonas_terapeutas zt ON t.id_login=zt.idTerapeuta WHERE (t.seleccionable=1 OR t.seleccionable_online = 1) AND l.active=1 AND t.listar=1 AND t.tagSearch LIKE '%\\_13\\_%' AND paisDominio = :pais ORDER BY t.featOrder DESC, t.orderls DESC, t.horas_mod DESC  LIMIT :start, :offset

SQL: [299] SELECT COUNT(DISTINCT(t.id_login)) AS total from terapeutas t LEFT JOIN login l ON t.id_login=l.id LEFT JOIN zonas_terapeutas zt ON t.id_login=zt.idTerapeuta WHERE (t.seleccionable=1 OR t.seleccionable_online=1) AND l.active=1 AND t.listar=1 AND t.tagSearch LIKE '%\\_13\\_%' AND paisDominio = :pais

SQL: [361] SELECT DISTINCT z.idZona, z.idDepartamento, z.nombreZona, z.uriZona, z.isoPais FROM zonas z LEFT JOIN zonas_terapeutas zt ON z.idZona=zt.idZona INNER JOIN terapeutas t ON (t.id_login = zt.idTerapeuta) WHERE zt.idZona IS NOT NULL AND z.isoPais=AR AND t.seleccionable = 1 AND (t.tipo_atencion = 'presencial' OR t.tipo_atencion='ambas') ORDER BY z.nombreZona ASC 

SQL: [299] SELECT COUNT(DISTINCT(t.id_login)) AS total from terapeutas t LEFT JOIN login l ON t.id_login=l.id LEFT JOIN zonas_terapeutas zt ON t.id_login=zt.idTerapeuta WHERE (t.seleccionable=1 OR t.seleccionable_online=1) AND l.active=1 AND t.listar=1 AND t.tagSearch LIKE '%\\_13\\_%' AND paisDominio = :pais

SQL: [67] SELECT * FROM config WHERE item='terms_and_conditions' AND paisDominio='AR' LIMIT 1