' || ( CASE WHEN t.status = 1 THEN 'Active' ELSE 'Disabled' END) || '' AS status, " . " 'Disable' AS action FROM test_accounts t LEFT JOIN members m ON m.id = t.member_id " . $whereQuery . " ORDER BY t.id "; return $query; } }