-- Connection Id: 952
-- User: qlikview
-- Host: 192.168.51.68:62842
-- DB: woopra_php
-- Command: Query
-- Time: 3
-- State: Sending data
SELECT
	a.*,
	ap1.property_value as 'Site ID',
	ap2.property_value as 'Hit App Host',
	ap3.property_value as 'Hit Layout',
	ap4.property_value as 'Hit Platform',
	ap5.property_value as 'Hit Is Test',
	ap6.property_value as 'Hit Error Message',
	ap7.property_value as 'Hit Step',
	ap8.property_value as 'Hit Transaction ID',
	ap9.property_value as 'Hit Affiliate ID',
	ap10.property_value as 'Hit Theme ID',
	ap11.property_value as 'Hit ICE Theme ID',
	ap12.property_value as 'Hit Title',
	ap13.property_value as 'Hit Weighting Segment',
	ap14.property_value as 'Hit Price Optimization Rate',
	ap15.property_value as 'Hit Back Discount Offer Rate'
FROM
	actions a
LEFT JOIN action_properties ap1 ON (ap1.yearmonth = 1502 AND ap1.action_hash = a.hash AND ap1.property_key_id = (SELECT id FROM property_keys WHERE property_key='site_id'))
LEFT JOIN action_properties ap2 ON (ap2.yearmonth = 1502 AND ap2.action_hash = a.hash AND ap2.property_key_id = (SELECT id FROM property_keys WHERE property_key='apphost'))
LEFT JOIN action_properties ap3 ON (ap3.yearmonth = 1502 AND ap3.action_hash = a.hash AND ap3.property_key_id = (SELECT id FROM property_keys WHERE property_key='layout'))
LEFT JOIN action_properties ap4 ON (ap4.yearmonth = 1502 AND ap4.action_hash = a.hash AND ap4.property_key_id = (SELECT id FROM property_keys WHERE property_key='platform'))
LEFT JOIN action_properties ap5 ON (ap5.yearmonth = 1502 AND ap5.action_hash = a.hash AND ap5.property_key_id = (SELECT id FROM property_keys WHERE property_key='test'))
LEFT JOIN action_properties ap6 ON (ap6.yearmonth = 1502 AND ap6.action_hash = a.hash AND ap6.property_key_id = (SELECT id FROM property_keys WHERE property_key='errors'))
LEFT JOIN action_properties ap7 ON (ap7.yearmonth = 1502 AND ap7.action_hash = a.hash AND ap7.property_key_id = (SELECT id FROM property_keys WHERE property_key='step'))
LEFT JOIN action_properties ap8 ON (ap8.yearmonth = 1502 AND ap8.action_hash = a.hash AND ap8.property_key_id = (SELECT id FROM property_keys WHERE property_key='transaction_id'))
LEFT JOIN action_properties ap9 ON (ap9.yearmonth = 1502 AND ap9.action_hash = a.hash AND ap9.property_key_id = (SELECT id FROM property_keys WHERE property_key='affiliate_id'))
LEFT JOIN action_properties ap10 ON (ap10.yearmonth = 1502 AND ap10.action_hash = a.hash AND ap10.property_key_id = (SELECT id FROM property_keys WHERE property_key='theme_id'))
LEFT JOIN action_properties ap11 ON (ap11.yearmonth = 1502 AND ap11.action_hash = a.hash AND ap11.property_key_id = (SELECT id FROM property_keys WHERE property_key='ice_theme_id'))
LEFT JOIN action_properties ap12 ON (ap12.yearmonth = 1502 AND ap12.action_hash = a.hash AND ap12.property_key_id = (SELECT id FROM property_keys WHERE property_key='title'))
LEFT JOIN action_properties ap13 ON (ap13.yearmonth = 1502 AND ap13.action_hash = a.hash AND ap13.property_key_id = (SELECT id FROM property_keys WHERE property_key='weighting_seg'))
LEFT JOIN action_properties ap14 ON (ap14.yearmonth = 1502 AND ap14.action_hash = a.hash AND ap14.property_key_id = (SELECT id FROM property_keys WHERE property_key='po_rate'))
LEFT JOIN action_properties ap15 ON (ap15.yearmonth = 1502 AND ap15.action_hash = a.hash AND ap15.property_key_id = (SELECT id FROM property_keys WHERE property_key='bdo_rate'))
 WHERE
						a.datetime  >= "2015-02-17:00:00:00"
					AND a.datetime  <= "2015-02-17:23:59:59"
					AND a.yearmonth = 1502