PHP Classes

File: tests/expected/creator/issue105.sql

Recommend this page to a friend!
  Classes of Michael Cummings   PHP SQL Parser Class   tests/expected/creator/issue105.sql   Download  
File: tests/expected/creator/issue105.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: 4 years ago
Size: 667 bytes


Class file image Download
SELECT users0.user_name AS 'CIS UserName', calls.description AS 'Description', contacts2.first_name AS 'Contacts First Name', contacts2.last_name AS 'Contacts Last Name', calls_cstm.date_logged_c AS 'Date', calls_cstm.contact_type_c AS 'Contact Type', dbo.fn_GetAccountName(calls.parent_id) AS 'Account Name' FROM calls LEFT JOIN calls_cstm ON = calls_cstm.id_c LEFT JOIN users users0 ON calls.assigned_user_id = LEFT JOIN contacts contacts2 ON calls.contact_id = WHERE calls.deleted = 0 AND (DATEADD(SECOND,0,calls_cstm.date_logged_c) BETWEEN '2013-01-01' AND '2013-12-31') ORDER BY dbo.fn_GetAccountName(calls.parent_id) ASC LIMIT 15