classDatabase: rowCount: command: SELECT p.id, p.code, p.name_el, p.name_url, p.price, p.photo, pg.name_el AS groupName FROM productgroups pg LEFT JOIN (productsgroups pgr LEFT JOIN products p ON pgr.products = p.id) ON pg.id = pgr.productgroups WHERE p.visible=1 AND '/' & pg.name_url='/new-products'
The data types varchar and nvarchar are incompatible in the '&' operator.