classDatabase: rowCount: command: SELECT p.id, p.code, p.name_en, p.name_url, p.photo, c.category_en, p.price , (SELECT COUNT(products) FROM productsgroups WHERE products=p.id AND productgroups=5) AS isnew , b.logo, b.brand_en, b.brand_url FROM (products p INNER JOIN categories c ON p.category=c.id) LEFT JOIN brands b ON p.brand=b.id WHERE p.visible=1 AND availablefrom>NOW()
'NOW' is not a recognized built-in function name.