DELETE upt FROM #__mycomponent_user_posts AS upt WHERE upt.posts=0 AND upt.owner=0 AND upt.favorite=0 AND upt.subscribed=0 AND upt.params=''

DELETE FROM #__mycomponent_user_posts AS upt WHERE upt.posts=0 AND upt.owner=0 AND upt.favorite=0 AND upt.subscribed=0 AND upt.params=''

$db = Factory::getDBO();
try {
    $query = $db->getQuery(true)
                ->delete("#__mycomponent_user_posts")
                ->where(["posts + owner + favorite + subscribed = 0",
                         "params = ''"]);
    $db->setQuery($query);
    $db->execute();
    if (!$affrows = $db->getAffectedRows()) {
        echo "Possible Logic Error - No Qualifying Rows To Delete";
    }
    echo "Success $affrows Deleted Rows";
} catch (Exception $e) {
    echo "Syntax Error"; // . "Query: " . $query->dump() . " & Error: " . $e->getMessage();
}

$query = $db->getQuery(true)
            ->delete("#__mycomponent_user_posts")
            ->where(["posts = 0",
                     "owner = 0",
                     "favorite = 0",
                     "subscribed = 0",
                     "params = ''"]);