File: test.sql.psp

package info (click to toggle)
web-mode 17.3.20-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 2,164 kB
  • sloc: lisp: 13,359; javascript: 506; jsp: 113; sh: 10; php: 9; makefile: 8; xml: 2
file content (26 lines) | stat: -rw-r--r-- 491 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
 
<div>
  <?php
  $query = "SELECT
                id,
                GROUP_CONCAT(name)
            FROM
                products
            WHERE
                id > 1";

  $query = "SELECT
                products.id,
                name
            FROM
                products
            LEFT JOIN(
            SELECT
                id
            FROM
                persons
            ) ON persons.id = personId
            WHERE
                persons.id > 12";

  ?>
</div>