File: tests/expected/creator/issue57.sql

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

 

Contents

Class file image Download
SELECT a.*, SUM(b.home) AS home, b.language, l.image, l.sef, l.title_native FROM iuz6l_menu_types AS a LEFT JOIN iuz6l_menu AS b ON b.menutype = a.menutype AND b.home != 0 LEFT JOIN iuz6l_languages AS l ON l.lang_code = language WHERE (b.client_id = 0 OR b.client_id IS NULL) GROUP BY a.id, a.menutype, a.description, a.title, b.menutype, b.language, l.image, l.sef, l.title_native

For more information send a message to info at phpclasses dot org.