get list of item SKUs from orders in Magento through MySQL database

If you want to extract data from orders placed in Magento 1.7 through MYSQL query. Magento 1.7 database tables are changed from previous version of Magento.

Two table in Magento 1.7 database have core data for orders table

1.sales_flat_order
2.sales_flat_order_item

SELECT  items.order_id AS orderid,
		items.item_id AS itemid,
		orders.total_item_count AS total_items_in_order,
		items.created_at AS orderdate,
		items.product_type,
		items.sku AS itemcode,
		items.name AS itemname,
		items.price_incl_tax AS itemprice,
		items.tax_amount AS itemtax,
		items.discount_amount AS discount,
		items.qty_ordered AS qty_ordered,
		items.qty_shipped AS qty_shipped,
		address.email AS email,
		address.prefix AS title,
		address.firstname AS firstname,
		address.street AS address,
		address.city AS city,
		address.region AS region,
		address.country_id AS country,
		address.postcode AS postcode,
		address.lastname
FROM sales_flat_order AS orders 
        JOIN sales_flat_order_item AS items 
          ON items.order_id = orders.entity_id 
        LEFT JOIN sales_flat_order_address AS address
          ON orders.entity_id = address.parent_id
WHERE 
         items .created_at BETWEEN  '2010-02-15 00:00:00' AND '2013-07-31 00:00:00'

If some one is using older version Like Magento 1.3 or other old versions

two table have core orders data in Magento Database.

1.sales_order
2.sales_flat_order_item

SELECT
sales_order.increment_id,
sales_flat_order_item.sku,
sales_flat_order_item.product_id,
sales_flat_order_item.product_type,
sales_flat_order_item.name,
sales_flat_order_item.created_at,
sales_flat_order_item.qty_ordered
FROM
sales_flat_order_item
Inner Join sales_order ON sales_flat_order_item.order_id = sales_order.entity_id
WHERE
sales_flat_order_item.created_at BETWEEN  '2012-12-15 10:59:55' AND '2012-12-30 10:59:55'