The issue might be with your INNER JOINs. Try and temporarily replace them with (LEFT) OUTER JOINs and see if any data get returned. , The problem might lie with your INNER JOINs. Temporarily replace them with (LEFT) OUTER JOINs and see if any data get returned. ... View more