1 debug
2 SQLFormatter::parseQuery
SELECT * FROM tblUsers WHERE id=42 AND email='john@example.com' AND testI = 0 AND testS='test2'
3 SQLFormatter::highlightHTML
SELECT  FROM tblUsers WHERE id=42 AND email='john@example.com' AND testI = 0 AND testS='test2'

4 SQLFormatter::format
SELECT FROM tblUsers WHERE id = 42 AND email = 'john@example.com' AND testI = 0 AND testS = 'test2'
5 SQLFormatter::highlightHTML(SQLFormatter::format
SELECT   
FROM  tblUsers  
WHERE  id = 42  AND  email = 'john@example.com'  AND  testI  =  0  AND  testS = 'test2'
6 SQLFormatter::highlightHTML(DB::getParsedQueryString
SELECT  FROM tbl WHERE name IN ('John','Bob') AND age NOT IN (12,15)
SELECT * FROM tbl WHERE name='Paul' AND age > 15 AND height <= 13.75
SELECT * FROM tbl WHERE name='Peter' AND age > 15 AND height <= 13.75
SELECT *
FROM tblUsers
WHERE age>30
AND role=&#039;editor&#039;
10 
SELECT id AS ii, name AS nn, tblUsers.*
    (SELECT COUNT(*) 
     FROM `tblOrders`
     WHERE tblOrders.user_id = tblUsers.id
     AND status='paid') AS paidOrders
FROM tblUsers
WHERE age > 30 AND role = 'editor'
ORDER BY name ASC
11 
 SELECT id AS ii, name AS nn, tblUsers.* (SELECT COUNT(*)  FROM `tblOrders` WHERE tblOrders.user_id = tblUsers.id AND status='paid') AS paidOrders FROM tblUsers WHERE age > 30 AND role = 'editor' ORDER BY name ASC
12 
 
SELECT  id  AS  ii,
     name  AS  nn,
     tblUsers.*  (

    SELECT  COUNT(*)   
    FROM  `tblOrders`  
    WHERE  tblOrders.user_id  =  tblUsers.id  AND  status = 'paid'
)  AS  paidOrders  
FROM  tblUsers  
WHERE  age  >  30  AND  role  =  'editor'  ORDER  BY  name  ASC
12 
 
SELECT  id  AS  ii,
     name  AS  nn,
     tblUsers.*  (

    SELECT  COUNT(*)   
    FROM  `tblOrders`  
    WHERE  tblOrders.user_id  =  tblUsers.id  AND  status = 'paid'
)  AS  paidOrders  
FROM  tblUsers  
WHERE  age  >  30  AND  role  =  'editor'  ORDER  BY  name  ASC
Essenstypen

🍽️ Essenstyp Test

Welcher Essenstyp bist du?

ausgearbeitet von Sonja Tousch

In 5 Minuten weisst du Bescheid! Starte jetzt deinen kostenlosen Test!

Nachdem du deine E-Mail-Adresse eingetragen und das Formular abgeschickt hast, gelangst du zu deinem individuell generierten Test.




Mit deiner Eintragung meldest du dich zum Newsletter an und erhältst Zugang zum exklusiven Persönlichkeitstest. Du kannst dich jederzeit wieder abmelden. Informationen zum Abbestellen sowie unsere Datenschutzpraktiken und unsere Verpflichtung zum Schutz deiner Privatsphäre findest du in unseren Datenschutzbestimmungen.