How to reduce numbers of AND used in this MYSQL query : This is the query I am working on and somehow it takes to much time and eventually times out, which makes me think if I can reduce the number of AND in the WHERE Clause. I am new to this Huge Queries, Please help me out. Thank you :) 

    SELECT sfog.entity_id, 
    (
    CASE 
        WHEN sfog.status = 'delivered' THEN 'Order'
        WHEN sfog.status IN ('return','rtndelivered','closed') THEN 'Return Order'
        WHEN sfog.status = 'CanceledBS' THEN 'CanceledBS Order'
    END) AS Type,
	
	CONCAT(cev1.value,' ', cev2.value) AS 'Vendor Name',
	sfog.status AS Status,
	sfog.increment_id AS OrderNo ,
	sfosh.created_at AS 'Invoice Date',
	mo.tracking_number AS 'Tracking Number',
	CONCAT(sfoa.firstname,' ', sfoa.lastname) AS 'Customer Name',
	CONCAT(sfoa.street,' ',sfoa.city,' ',sfoa.region,' ',sfoa.postcode) AS 'Address',
	sfoa.email AS 'Email',
	group_concat( DISTINCT sfoi.sku SEPARATOR ', ') AS `Product Name`,
	sfo.total_qty_ordered AS 'Qty',
	SUM(ms.totalamountut) AS 'Order Value'

    FROM sales_flat_order_grid sfog, sales_flat_order_status_history sfosh, customer_entity_varchar cev1, customer_entity_varchar cev2, marketplace_orders mo, sales_flat_order_address sfoa, sales_flat_order_item sfoi, sales_flat_order sfo, marketplace_saleslist ms

    WHERE sfog.status IN ('delivered','return','rtndelivered','closed','CanceledBS') and sfosh.parent_id = sfog.entity_id and cev1.attribute_id = '5' and cev2.attribute_id = '7' and mo.seller_id = cev1.entity_id and mo.seller_id = cev2.entity_id and mo.order_id = sfog.entity_id and sfoa.parent_id = sfog.entity_id and sfoi.order_id = sfog.entity_id and sfo.entity_id = sfog.entity_id and ms.mageorderid = sfog.entity_id GROUP BY sfog.entity_id;