FM / Statements

/usr/share/php/PhpMyAdmin/SqlParser/Statements/

/usr/share/php/PhpMyAdmin/SqlParser/Statements

Name	Size	Mode	Actions
AlterStatement.php	3768	0644	edit dl rm
AnalyzeStatement.php	636	0644	edit dl rm
BackupStatement.php	527	0644	edit dl rm
CallStatement.php	739	0644	edit dl rm
CheckStatement.php	527	0644	edit dl rm
ChecksumStatement.php	451	0644	edit dl rm
CreateStatement.php	22928	0644	edit dl rm
DeleteStatement.php	11678	0644	edit dl rm
DropStatement.php	1433	0644	edit dl rm
ExplainStatement.php	200	0644	edit dl rm
InsertStatement.php	7459	0644	edit dl rm
LoadStatement.php	11074	0644	edit dl rm
LockStatement.php	3494	0644	edit dl rm
MaintenanceStatement.php	1503	0644	edit dl rm
NotImplementedStatement.php	1374	0644	edit dl rm
OptimizeStatement.php	641	0644	edit dl rm
PurgeStatement.php	3853	0644	edit dl rm
RenameStatement.php	1377	0644	edit dl rm
RepairStatement.php	570	0644	edit dl rm
ReplaceStatement.php	5335	0644	edit dl rm
RestoreStatement.php	477	0644	edit dl rm
SelectStatement.php	7436	0644	edit dl rm
SetStatement.php	2028	0644	edit dl rm
ShowStatement.php	1280	0644	edit dl rm
TransactionStatement.php	2348	0644	edit dl rm
TruncateStatement.php	747	0644	edit dl rm
UpdateStatement.php	2334	0644	edit dl rm

Edit: /usr/share/php/PhpMyAdmin/SqlParser/Statements/SelectStatement.php (7436B)

<?php
/**
 * `SELECT` statement.
 */

declare(strict_types=1);

namespace PhpMyAdmin\SqlParser\Statements;

use PhpMyAdmin\SqlParser\Components\ArrayObj;
use PhpMyAdmin\SqlParser\Components\Condition;
use PhpMyAdmin\SqlParser\Components\Expression;
use PhpMyAdmin\SqlParser\Components\FunctionCall;
use PhpMyAdmin\SqlParser\Components\IndexHint;
use PhpMyAdmin\SqlParser\Components\IntoKeyword;
use PhpMyAdmin\SqlParser\Components\JoinKeyword;
use PhpMyAdmin\SqlParser\Components\Limit;
use PhpMyAdmin\SqlParser\Components\OptionsArray;
use PhpMyAdmin\SqlParser\Components\OrderKeyword;
use PhpMyAdmin\SqlParser\Statement;

/**
 * `SELECT` statement.
 *
 * SELECT
 *     [ALL | DISTINCT | DISTINCTROW ]
 *       [HIGH_PRIORITY]
 *       [MAX_STATEMENT_TIME = N]
 *       [STRAIGHT_JOIN]
 *       [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
 *       [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
 *     select_expr [, select_expr ...]
 *     [FROM table_references
 *       [PARTITION partition_list]
 *     [WHERE where_condition]
 *     [GROUP BY {col_name | expr | position}
 *       [ASC | DESC], ... [WITH ROLLUP]]
 *     [HAVING where_condition]
 *     [ORDER BY {col_name | expr | position}
 *       [ASC | DESC], ...]
 *     [LIMIT {[offset,] row_count | row_count OFFSET offset}]
 *     [PROCEDURE procedure_name(argument_list)]
 *     [INTO OUTFILE 'file_name'
 *         [CHARACTER SET charset_name]
 *         export_options
 *       | INTO DUMPFILE 'file_name'
 *       | INTO var_name [, var_name]]
 *     [FOR UPDATE | LOCK IN SHARE MODE]]
 */
class SelectStatement extends Statement
{
    /**
     * Options for `SELECT` statements and their slot ID.
     *
     * @var array
     */
    public static $OPTIONS = [
        'ALL' => 1,
        'DISTINCT' => 1,
        'DISTINCTROW' => 1,
        'HIGH_PRIORITY' => 2,
        'MAX_STATEMENT_TIME' => [
            3,
            'var=',
        ],
        'STRAIGHT_JOIN' => 4,
        'SQL_SMALL_RESULT' => 5,
        'SQL_BIG_RESULT' => 6,
        'SQL_BUFFER_RESULT' => 7,
        'SQL_CACHE' => 8,
        'SQL_NO_CACHE' => 8,
        'SQL_CALC_FOUND_ROWS' => 9,
    ];

public static $END_OPTIONS = [
        'FOR UPDATE' => 1,
        'LOCK IN SHARE MODE' => 1,
    ];

/**
     * The clauses of this statement, in order.
     *
     * @see Statement::$CLAUSES
     *
     * @var array
     */
    public static $CLAUSES = [
        'SELECT' => [
            'SELECT',
            2,
        ],
        // Used for options.
        '_OPTIONS' => [
            '_OPTIONS',
            1,
        ],
        // Used for selected expressions.
        '_SELECT' => [
            'SELECT',
            1,
        ],
        'INTO' => [
            'INTO',
            3,
        ],
        'FROM' => [
            'FROM',
            3,
        ],
        'FORCE' => [
            'FORCE',
            1,
        ],
        'USE' => [
            'USE',
            1,
        ],
        'IGNORE' => [
            'IGNORE',
            3,
        ],
        'PARTITION' => [
            'PARTITION',
            3,
        ],

'JOIN' => [
            'JOIN',
            1,
        ],
        'FULL JOIN' => [
            'FULL JOIN',
            1,
        ],
        'INNER JOIN' => [
            'INNER JOIN',
            1,
        ],
        'LEFT JOIN' => [
            'LEFT JOIN',
            1,
        ],
        'LEFT OUTER JOIN' => [
            'LEFT OUTER JOIN',
            1,
        ],
        'RIGHT JOIN' => [
            'RIGHT JOIN',
            1,
        ],
        'RIGHT OUTER JOIN' => [
            'RIGHT OUTER JOIN',
            1,
        ],
        'NATURAL JOIN' => [
            'NATURAL JOIN',
            1,
        ],
        'NATURAL LEFT JOIN' => [
            'NATURAL LEFT JOIN',
            1,
        ],
        'NATURAL RIGHT JOIN' => [
            'NATURAL RIGHT JOIN',
            1,
        ],
        'NATURAL LEFT OUTER JOIN' => [
            'NATURAL LEFT OUTER JOIN',
            1,
        ],
        'NATURAL RIGHT OUTER JOIN' => [
            'NATURAL RIGHT JOIN',
            1,
        ],

'WHERE' => [
            'WHERE',
            3,
        ],
        'GROUP BY' => [
            'GROUP BY',
            3,
        ],
        'HAVING' => [
            'HAVING',
            3,
        ],
        'ORDER BY' => [
            'ORDER BY',
            3,
        ],
        'LIMIT' => [
            'LIMIT',
            3,
        ],
        'PROCEDURE' => [
            'PROCEDURE',
            3,
        ],
        'UNION' => [
            'UNION',
            1,
        ],
        'EXCEPT' => [
            'EXCEPT',
            1,
        ],
        'INTERSECT' => [
            'INTERSECT',
            1,
        ],
        '_END_OPTIONS' => [
            '_END_OPTIONS',
            1,
        ],
        // These are available only when `UNION` is present.
        // 'ORDER BY'                      => ['ORDER BY', 3],
        // 'LIMIT'                         => ['LIMIT', 3],
    ];

/**
     * Expressions that are being selected by this statement.
     *
     * @var Expression[]
     */
    public $expr = [];

/**
     * Tables used as sources for this statement.
     *
     * @var Expression[]
     */
    public $from = [];

/**
     * Index hints
     *
     * @var IndexHint[]
     */
    public $index_hints;

/**
     * Partitions used as source for this statement.
     *
     * @var ArrayObj
     */
    public $partition;

/**
     * Conditions used for filtering each row of the result set.
     *
     * @var Condition[]
     */
    public $where;

/**
     * Conditions used for grouping the result set.
     *
     * @var OrderKeyword[]
     */
    public $group;

/**
     * Conditions used for filtering the result set.
     *
     * @var Condition[]
     */
    public $having;

/**
     * Specifies the order of the rows in the result set.
     *
     * @var OrderKeyword[]
     */
    public $order;

/**
     * Conditions used for limiting the size of the result set.
     *
     * @var Limit
     */
    public $limit;

/**
     * Procedure that should process the data in the result set.
     *
     * @var FunctionCall
     */
    public $procedure;

/**
     * Destination of this result set.
     *
     * @var IntoKeyword
     */
    public $into;

/**
     * Joins.
     *
     * @var JoinKeyword[]
     */
    public $join;

/**
     * Unions.
     *
     * @var SelectStatement[]
     */
    public $union = [];

/**
     * The end options of this query.
     *
     * @see static::$END_OPTIONS
     *
     * @var OptionsArray
     */
    public $end_options;

/**
     * Gets the clauses of this statement.
     *
     * @return array
     */
    public function getClauses()
    {
        // This is a cheap fix for `SELECT` statements that contain `UNION`.
        // The `ORDER BY` and `LIMIT` clauses should be at the end of the
        // statement.
        if (! empty($this->union)) {
            $clauses = static::$CLAUSES;
            unset($clauses['ORDER BY'], $clauses['LIMIT']);
            $clauses['ORDER BY'] = [
                'ORDER BY',
                3,
            ];
            $clauses['LIMIT'] = [
                'LIMIT',
                3,
            ];

return $clauses;
        }

return static::$CLAUSES;
    }
}

cmd: