Following SQL successfully runs in any SQL editor but showing SERVER ERROR in the response of laravel 8.0.
Can anyone help me on this what needs to be changed in the raw query so that it runs successfully.
Response output is follows:
message: server error
SELECT
(SELECT s.salesarea
FROM orbitsales_role r
WHERE r.salesperson = s.salesperson
AND r.accessto = 'nasir'
AND s.isdeleted = 0
AND s.dateofsale BETWEEN '2022-06-01' AND '2022-08-31') 'OthersSalesArea'
, (SELECT COUNT(s.id)
FROM orbitsales_role r
WHERE r.salesperson = s.salesperson
AND r.accessto = 'nasir'
AND s.isdeleted = 0
AND s.dateofsale BETWEEN '2022-06-01' AND '2022-08-31') 'OthersSalesCount'
, (SELECT SUM(s.planprice)
FROM orbitsales_role r
WHERE r.salesperson = s.salesperson
AND r.accessto = 'nasir'
AND s.isdeleted = 0
AND s.dateofsale BETWEEN '2022-06-01' AND '2022-08-31') 'OthersMRC'
, (SELECT SUM(s.collectedbdt)
FROM orbitsales_role r
WHERE r.salesperson = s.salesperson
AND r.accessto = 'nasir'
AND s.isdeleted = 0
AND s.dateofsale BETWEEN '2022-06-01' AND '2022-08-31') 'OthersCollectedAmount'
, (SELECT COUNT(DISTINCT s.salesperson)
FROM orbitsales_role r
WHERE r.salesperson = s.salesperson
AND r.accessto = 'nasir'
AND s.isdeleted = 0
AND s.dateofsale BETWEEN '2022-06-01' AND '2022-08-31') 'OthersSalesPerson'
, (SELECT COUNT(v.id)
FROM orbit_visitinfo v, orbitvisitinfo_role r
WHERE r.salesperson = v.salesperson
AND r.accessto = 'nasir'
AND v.isdeleted = 0
AND s.salesarea = v.visitarea
AND v.dateofvisit BETWEEN '2022-06-01' AND '2022-08-31') 'visitareaCount'
FROM orbit_dailysales s
WHERE s.dateofsale BETWEEN '2022-06-01' AND '2022-08-31'
AND s.isdeleted = 0
GROUP BY s.salesarea
ORDER BY COUNT(s.id) DESC