where and joins are not working

[mfhassan22]

I use the code and also tried before on where() but they are not working where as the filter() is working which i used before instead of where() the profiler shows 6 queries execution which are below
$this->datatables -> select('packages_subject_id,packages_subject.packages_id,packages_subject.subject_id,packages.name AS pname,subject.name AS sname') ->join('packages','packages_subject.packages_id=packages.packages_id','left') ->join('subject','packages_subject.subject_id=subject.subject_id','left') ->from('packages_subject');
*************************************************_Queries profiler debug_******************************************
0.0001 SELECTpackages_subject_id,packages_subject.packages_id,packages_subject.subject_id,packages_subject.outlet_id,packages.nameASpname,subject.nameASsname FROMpackages_subject LEFT JOINpackagesONpackages_subject.packages_id=packages.packages_id LEFT JOINsubjectONpackages_subject.subject_id=subject.subject_id 0.0000 SELECT * FROMpackages_subject LEFT JOINpackagesONpackages_subject.packages_id=packages.packages_id LEFT JOINsubjectONpackages_subject.subject_id=subject.subject_id 0.0000 SELECT * FROMpackages_subject LEFT JOINpackagesONpackages_subject.packages_id=packages.packages_id LEFT JOINsubjectONpackages_subject.subject_id=subject.subject_id 0.0000 SELECT * FROMpackages_subject 0.0000 SELECT * FROMpackages_subject LEFT JOINpackagesONpackages_subject.packages_id=packages.packages_id LEFT JOINsubjectONpackages_subject.subject_id=subject.subject_id 0.0000 SELECT * FROMpackages_subject LEFT JOINpackagesONpackages_subject.packages_id=packages.packages_id LEFT JOINsubjectONpackages_subject.subject_id=subject.subject_id``

[Ridwan226]

is it correct how to solve field duplication