| Class Database caught error: mysql error: [1064: 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 'ORDER BY sp.listingTypeId DESC, sp.companyName ASC' at line 4] in EXECUTE("SELECT distinct sp.*, s.abbreviation, s.state, c.country, splt.listingType FROM `serviceProvider` sp inner join serviceProviderListingType splt on sp.listingTypeId = splt.id inner join lu_state s on sp.state = s.abbreviation inner join lu_country c on sp.countryId = c.id inner join serviceProviderCatAssign spca on sp.id = spca.providerId inner join serviceProviderCategory spc on spca.categoryId = spc.id WHERE sp.rowStatus = 1 and spc.rowStatus = 1 and splt.rowStatus = 1 and s.rowStatus = 1 and sp.expirationDate >= NOW() and spc.id = ORDER BY sp.listingTypeId DESC, sp.companyName ASC") Class Database caught error: mysql error: [1064: 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 'AND rowStatus = 1' at line 1] in EXECUTE("SELECT * FROM serviceProviderCategory WHERE id= AND rowStatus = 1") |