MySQL database Query:
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
The following query throw the next error:
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
I added the session id from my existing query