php - MySQL 服务器版本，用于使用近 id 的正确语法

Question

MySQL数据库查询:

SELECT * 
FROM (SELECT * 
      FROM (`static_package_data`) 
          LEFT JOIN package_interest pi ON static_package_data.id=pi.package_details_id 
      WHERE `package_availability_type` = 'all' 
            AND `admin_status` = 'ACTIVE' 
            AND `status` = 'ACTIVE' 
            AND static_package_data.package_price BETWEEN 2000 AND 5000
            AND WHERE 'static_package_data.session_id'='AE44278818'
      GROUP BY static_package_data.id 
      UNION ALL 
      SELECT *
      FROM (`static_package_data`) 
          LEFT JOIN package_interest pi ON  static_package_data.id=pi.package_details_id 
      WHERE `package_availability_type` ='range' 
          AND `admin_status` = 'ACTIVE' 
          AND `status` = 'ACTIVE' 
          AND `to_date` >= '2017-02-04'AND static_package_data.package_price BETWEEN 2000 AND 5000 
          AND WHERE 'static_package_data.session_id'='AE44278818'
      GROUP BY static_package_data.id 
      ) as dt LIMIT 0 , 10

以下查询引发下一个错误:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near WHERE 'static_package_data.session_id'='AE44278818' GROUP BY static_package_data.' at line 1

我从现有查询中添加了 session ID

Answer 1

简单，

SELECT * 
FROM   ( 
                 SELECT    * 
                 FROM      (`static_package_data`) 
                 LEFT JOIN package_interest pi 
                 ON        static_package_data.id=pi.package_details_id 
                 WHERE     `package_availability_type` = 'all' 
                 AND       `admin_status` = 'ACTIVE' 
                 AND       `status` = 'ACTIVE' 
                 AND       static_package_data.package_price BETWEEN 2000 AND       5000 
                 AND 
                 WHERE     'static_package_data.session_id'='AE44278818' 
                 GROUP BY  static_package_data.id 
                 UNION ALL 
                 SELECT    * 
                 FROM      (`static_package_data`) 
                 LEFT JOIN package_interest pi 
                 ON        static_package_data.id=pi.package_details_id 
                 WHERE     `package_availability_type` ='range' 
                 AND       `admin_status` = 'ACTIVE' 
                 AND       `status` = 'ACTIVE' 
                 AND       `to_date` >= '2017-02-04' 
                 AND       static_package_data.package_price BETWEEN 2000 AND       5000 
                 AND 
                 WHERE     'static_package_data.session_id'='AE44278818' 
                 GROUP BY  static_package_data.id ) AS dt limit 0 , 
       10;