
        SELECT  COUNT(*) AS rowsQty 
        FROM purchase 
        INNER JOIN provider ON CONCAT(provider.id) = CONCAT(purchase.provider_id) 
        LEFT JOIN purchase_vs_item ON purchase_vs_item.purchaseId = purchase.id 
        LEFT JOIN item ON item.id = purchase_vs_item.item_id 
        WHERE purchase.deleted = '0'  AND (purchase.code LIKE LOWER('%%') OR provider.name LIKE LOWER('%%') OR purchase.reference_number LIKE LOWER('%%') OR item.name LIKE LOWER('%%') OR item.brand LIKE LOWER('%%') ) ;