Error: select p.*, pr.SelectGenre, pr.Genre2, pr.Title as PropertyTitle, p.PropertyID AS PID, pi.ThumbLg as CoverThumb, pi.GalleryImage as Cover,(select ThumbLg from pf_projects_product_gallery where Position=1 and FilePurpose='gallery' and FileCategory='preview pages' and ProductID=p.ID limit 1) as FirstPage, (SELECT r.Title FROM pf_rg_entries AS r JOIN pf_projects_positions AS pos ON ( r.ID = pos.EntryID AND pos.PositionType = 'artist' ) WHERE pos.PropertyID = PID LIMIT 1 ) AS Artist from pf_projects_products as p join pf_projects_property as pr on pr.ID=p.PropertyID left join pf_projects_product_gallery as pi on (pi.ProductID=p.ID and pi.FilePurpose='branding' and pi.FileCategory='cover') where p.Type=11 and pr.IsActive=1 and p.Active=1 order by

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 '' at line 11