global $_CB_database;

// Delete all folders
$query				=	'SELECT *'
					.	"\n FROM " . $_CB_database->NameQuote( '#__comprofiler_plugin_gallery_folders' )
					.	"\n WHERE " . $_CB_database->NameQuote( 'asset' ) . " = " . $_CB_database->Quote( 'ASSET_HERE' );
$_CB_database->setQuery( $query );
$folders			=	$_CB_database->loadObjectList( null, '\CB\Plugin\Gallery\Table\FolderTable', array( $_CB_database ) );

/** @var FolderTable[] $folders */
foreach ( $folders as $folder ) {
	$folder->delete();
}

// Delete all items
$query				=	'SELECT *'
					.	"\n FROM " . $_CB_database->NameQuote( '#__comprofiler_plugin_gallery_items' )
					.	"\n WHERE " . $_CB_database->NameQuote( 'asset' ) . " = " . $_CB_database->Quote( 'ASSET_HERE' );
$_CB_database->setQuery( $query );
$items				=	$_CB_database->loadObjectList( null, '\CB\Plugin\Gallery\Table\ItemTable', array( $_CB_database ) );

/** @var ItemTable[] $items */
foreach ( $items as $item ) {
	$item->delete();
}