fork download
copy 
  1. <?php
  2.  
  3. // your code goes here
  4.  
  5. $query = <<<QUERY
  6. SELECT
  7. f.date_gmt::date as "Date Assessed"
  8. n.last_name || ', '' || n.first_name AS "Full Name"
  9. FROM
  10. fines as f
  11. JOIN
  12. record_metadata as r
  13. ON
  14. r.id = f.record_metadata_id
  15. JOIN
  16. fullname as n
  17. ON
  18. n.id = f.record_metadata_id
  19. QUERY;
  20.  
  21. echo $query;
Success #stdin #stdout 0s 82560KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
SELECT
f.date_gmt::date as "Date Assessed"
n.last_name || ', '' || n.first_name AS "Full Name"
FROM
fines as f
JOIN
record_metadata as r
ON
r.id = f.record_metadata_id
JOIN
fullname as n
ON
n.id = f.record_metadata_id
https://ideone.com/vrI2xm
language:
PHP (php 7.3.5)
created:
6 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!