带位修改的OUR查询输出

select a.packagename as packagename, a.packageid as packageid, 
a.packageduration as days, (a.packageprice + a.seater_4) as price,
b.statename,
substring_index(GROUP_CONCAT( DISTINCT (select f.placename )  SEPARATOR ', '),',',4) 
placename,
substring_index(GROUP_CONCAT( DISTINCT (select d.packagetypename )  SEPARATOR ', 
'),',',4) packagetypename
from tblpackages a
inner join tblstates b on b.stateid = a.stateid              
inner join tblpackage_packagetypes c on c.packageid = a.packageid
inner  join tblpackagetype d on d.packagetypeid = c.packagetypeid
inner join tblpackageplaces e on e.packageid = a.packageid
left join tblplaces f on f.placeid = e.placeid  and d.packagetypename = 'religious'
                 group by a.packageid

pname，pid，days，price，statename，placename，packagetypename
测试1，1，3，111，xyz，（katra，shiv khori），宗教
测试2，2，3，444，xyz，（katra），宗教
test3，3，3，445，xyz，null，（家庭，夫妻，冒险，朋友）
测试4，4，555，xyz，（katra，patnitop，sanasar，nathatop），（宗教，家庭，夫妻，冒险）
test6，666，，null，（家庭，冒险，朋友）
不需要包id 3和6

我建议把标准移到 WHERE 条款 ON 子句，并使该联接成为左联接：

SELECT ...
FROM tblpackages a
INNER JOIN tblstates b
    ON b.stateid = a.stateid              
INNER JOIN tblpackage_packagetypes c
    ON c.packageid = a.packageid
LEFT JOIN tblpackagetype d
    ON d.packagetypeid = c.packagetypeid AND d.placename = 'placename'
INNER JOIN tblpackageplaces e
    ON e.packageid = a.packageid
INNER JOIN tblplaces f
    ON f.placeid = e.placeid
GROUP BY
    a.packageid