PHP Classes

File: tests/expected/creator/issue89.sql

Recommend this page to a friend!
  Classes of Michael Cummings   PHP SQL Parser Class   tests/expected/creator/issue89.sql   Download  
File: tests/expected/creator/issue89.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP SQL Parser Class
Parse SQL to extract the SQL query structure
Author: By
Last change:
Date: 5 years ago
Size: 477 bytes
 

Contents

Class file image Download 
SELECT ut.id, ut.numero_cartella, ut.nome, ut.cognome, floor(DATEDIFF(de.`data`,ut.data_di_nascita) / 365) AS eta, sx.valore AS sesso, cd.valore AS diagnosi_prevalente, co.valore AS consapevolezza, DATEDIFF(de.`data`,az.data_inizio_assistenza) AS durata_assistenza_giorni, ld.valore AS luogo_decesso, ca.valore AS carico_assistenza, if(sa.id is null,null,if(sa.fkey_cod_care_giver_interno__con_chi_vive = 1,'si','no')) AS vive_solo, sn.valore AS oltre_70 FROM gen_cms_utenti ut