Writing SQL Query to Remove Product Description from Database

There are only one relation between Magento quote item tables & sales order tables and that is sales_flat_order.quote_id=sales_flat_quote_item.quote_id.

In magento,sales_flat_quote_item_option does not have any direct relation with sales_flat_order.It have an indirection relation

sales_flat_order.quote_id=sales_flat_quote.quote_id=> sales_flat_quote_item.item_id=sales_flat_quote_item_option.item_id

Query seem like:

SELECT * FROM sales_flat_quote_item_option where item_id in (
        select item_id from  sales_flat_quote_item  where quote_id in (
            SELECT quote_id FROM sales_flat_order  where entity_id =ORDER_ID

        )

)

I have tested this and it works but since it involves the deletion of products, I strongly recommend that you backup your database first.

include 'app/Mage.php';
Mage::app();

Mage::register('isSecureArea', 1);

$limit    = 100;
$model    = Mage::getModel('catalog/product');
$resource = $model->getResource();
$adapter  = $resource->getReadConnection();
$name     = $resource->getAttribute('name');

// retrieve a list of all products that have more than 1 occurrence of the same name
$select = $adapter->select()->from($name->getBackendTable(),array($resource->getIdFieldName(),'value','count' => 'COUNT(*)','entity_ids' => new Zend_Db_Expr("GROUP_CONCAT({$resource->getIdFieldName()})")));
$select->where('attribute_id = ?',$name->getAttributeId());
$select->where('entity_type_id = ?',$name->getEntityTypeId());
$select->group('value');
$select->having('count > 1');
$select->limit($limit);
$result = $adapter->fetchAll($select);

// here, we remove the lowest product id from each set of duplicate-named products. 
// the theory is that the product which was created first, hence the lowest 
// product id, is the one you want to keep
$result = array_map(function($row){
    $entityIds = explode(',',$row['entity_ids']);
    $min = min($entityIds);
    $key = array_search($min, $entityIds);
    unset($entityIds[$key]);
    $row['entity_ids'] = $entityIds;
    return $row;
},$result);

// now that we have narrowed down to the ids of the products we want to delete, 
// lets get all product ids to delete into a single array
$entityIds = array();
foreach($result as $row){
    $entityIds = array_merge($entityIds,$row['entity_ids']);
}

// lets delete each one individually
$collection = $model->getCollection();
$collection->addFieldToFilter($resource->getIdFieldName(),array('in' => $entityIds));
foreach($collection as $product){
    $product->delete();
}