mysql query formatting online

http://sqlformat.appspot.com/

example :

SELECT `e`.*,
       `cat_index`.`position` AS `cat_index_position`,
       `price_index`.`price`,
       `price_index`.`tax_class_id`,
       `price_index`.`final_price`,
       IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`,
       `price_index`.`min_price`,
       `price_index`.`max_price`,
       `price_index`.`tier_price`,
       `at_special_price`.`value` AS `special_price`,
       `at_special_from_date`.`value` AS `special_from_date`,
       `at_special_to_date`.`value` AS `special_to_date`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id
AND cat_index.store_id='1'
AND cat_index.visibility IN(2, 4)
AND cat_index.category_id='3'
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id
AND price_index.website_id = '1'
AND price_index.customer_group_id = 0
INNER JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`)
AND (`at_special_price`.`attribute_id` = '567')
AND (`at_special_price`.`store_id` = 0)
INNER JOIN `catalog_product_entity_datetime` AS `at_special_from_date` ON (`at_special_from_date`.`entity_id` = `e`.`entity_id`)
AND (`at_special_from_date`.`attribute_id` = '568')
AND (`at_special_from_date`.`store_id` = 0)
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_to_date` ON (`at_special_to_date`.`entity_id` = `e`.`entity_id`)
AND (`at_special_to_date`.`attribute_id` = '569')
AND (`at_special_to_date`.`store_id` = 0)
WHERE (at_special_price.value != '')
  AND (at_special_from_date.value <= '2013-05-29 01:42:24')
  AND (((((at_special_to_date.value >= '2013-05-30 00:00:00')
          OR (at_special_to_date.value IS NULL)))))
ORDER BY rand() ASC, `e`.`entity_id` DESC
Advertisements