gistfile1.txt

SELECT
	`field_2_0` AS `field_2_00`,
	`dateAndHour` AS `dateAndHour0`,
	SUM(`num`) AS `SUM_num0`,
	(
		SUM(`pay`) / nullif(SUM(`cost`), 0)
	) AS `c14525866493040`,
	(
		SUM(`paycount`) / nullif(SUM(`click`), 0)
	) AS `c14525866268950`,
	(
		SUM(`click`) / nullif(SUM(`impressions`), 0)
	) AS `c14525866105110`,
	(
		SUM(`cost`) / nullif(SUM(`click`), 0)
	) AS `c14525865967750`,
	(
		SUM(`cost`) / nullif(SUM(`carttotal`), 0)
	) AS `c14525866741380`
FROM
	(
		SELECT
			`_t_89ac4c`.`_d9d081` AS `field_2_0`,
			`_t_89ac4c`.`_1748ef` AS `dateAndHour`,
			`_t_0588cd`.`_5a8a51` AS `field_2_1`,
			`_t_89ac4c`.`_661db5` AS `num`,
			`_t_0588cd`.`_7109ab` AS `impressions`,
			`_t_0588cd`.`_04daeb` AS `click`,
			`_t_0588cd`.`_b2ebf9` AS `cost`,
			`_t_0588cd`.`_c8f3c3` AS `paycount`,
			`_t_0588cd`.`_4a72b2` AS `pay`,
			`_t_0588cd`.`_8a0e61` AS `carttotal`
		FROM
			(
				SELECT
					`_t_559b54`.`_82eb19` AS `_d9d081`,
					`_t_559b54`.`_30acdd` AS `_1748ef`,
					`_t_559b54`.`_20a4a3` AS `_661db5`
				FROM
					(
						SELECT
							`_t_90be41`.`_1dd03d` AS `_0ba968`,
							`_t_90be41`.`_09f15f` AS `_30acdd`,
							`_t_90be41`.`_31cb4a` AS `_789197`,
							`_t_8134e9`.`_c17093` AS `_9238bb`,
							`_t_8134e9`.`_2b03d7` AS `_2d85a2`,
							`_t_8134e9`.`_41c07b` AS `_82eb19`,
							`_t_8134e9`.`_1096d1` AS `_55912d`,
							`_t_8134e9`.`_b43751` AS `_ceb423`,
							`_t_8134e9`.`_173ca2` AS `_001801`,
							`_t_8134e9`.`_bb6ad7` AS `_1afa77`,
							`_t_8134e9`.`_0b285d` AS `_fd90a7`,
							`_t_90be41`.`_85ea16` AS `_20a4a3`,
							`_t_90be41`.`_6e8c99` AS `_ece4f4`,
							`_t_8134e9`.`_21c30c` AS `_fa0774`,
							`_t_8134e9`.`_8fe120` AS `_d06ce2`
						FROM
							(
								SELECT
									`nick` AS `_1dd03d`,
									`dateAndHour` AS `_09f15f`,
									`type` AS `_31cb4a`,
									`num` AS `_85ea16`,
									`latestOpTime` AS `_6e8c99`
								FROM
									`user_db_1`.`dp_ztc_h_op_log_share`
								WHERE
									(`user_id` = 100099)
								AND (`group_id` = 100000)
								AND (`dp_src_id` = 198)
							) AS _t_90be41
						CROSS JOIN (
							SELECT
								`field_0` AS `_c17093`,
								`field_1` AS `_2b03d7`,
								`field_2` AS `_41c07b`,
								`field_3` AS `_1096d1`,
								`field_5` AS `_b43751`,
								`field_6` AS `_173ca2`,
								`field_7` AS `_bb6ad7`,
								`id` AS `_0b285d`,
								`field_4` AS `_21c30c`,
								`field_8` AS `_8fe120`
							FROM
								`user_db_1`.`dp_file_619_464_100099_100000`
						) AS _t_8134e9 ON (
							`_t_90be41`.`_1dd03d` = `_t_8134e9`.`_c17093`
						)
					) AS _t_559b54
			) AS _t_89ac4c
		CROSS JOIN (
			SELECT
				`_t_f5a081`.`_0cbad5` AS `_5a8a51`,
				`_t_f5a081`.`_8f6b01` AS `_7109ab`,
				`_t_f5a081`.`_7e7a39` AS `_04daeb`,
				`_t_f5a081`.`_e54287` AS `_b2ebf9`,
				`_t_f5a081`.`_edfeda` AS `_c8f3c3`,
				`_t_f5a081`.`_d1c0dc` AS `_4a72b2`,
				`_t_f5a081`.`_fbc26c` AS `_8a0e61`
			FROM
				(
					SELECT
						`_t_3480c6`.`_c17093` AS `_8ff68f`,
						`_t_3480c6`.`_2b03d7` AS `_be14fe`,
						`_t_3480c6`.`_41c07b` AS `_0cbad5`,
						`_t_3480c6`.`_1096d1` AS `_0b7523`,
						`_t_3480c6`.`_b43751` AS `_77d946`,
						`_t_3480c6`.`_173ca2` AS `_6d60ce`,
						`_t_3480c6`.`_bb6ad7` AS `_60786d`,
						`_t_3480c6`.`_0b285d` AS `_ec6f75`,
						`_t_c0b7ea`.`_abdb83` AS `_af1f75`,
						`_t_c0b7ea`.`_c01da2` AS `_34c7e5`,
						`_t_c0b7ea`.`_71f39f` AS `_49e539`,
						`_t_3480c6`.`_21c30c` AS `_a431a9`,
						`_t_3480c6`.`_8fe120` AS `_c6f57f`,
						`_t_c0b7ea`.`_372f34` AS `_8f6b01`,
						`_t_c0b7ea`.`_e9b723` AS `_7e7a39`,
						`_t_c0b7ea`.`_4b9c8d` AS `_e54287`,
						`_t_c0b7ea`.`_1710b9` AS `_e93813`,
						`_t_c0b7ea`.`_6a4198` AS `_2170f4`,
						`_t_c0b7ea`.`_b7f13b` AS `_074727`,
						`_t_c0b7ea`.`_8e3a5f` AS `_f1a31c`,
						`_t_c0b7ea`.`_2084fa` AS `_3d8d8c`,
						`_t_c0b7ea`.`_9d3e02` AS `_5662d5`,
						`_t_c0b7ea`.`_1da47a` AS `_fbc26c`,
						`_t_c0b7ea`.`_7f1af8` AS `_6dff9c`,
						`_t_c0b7ea`.`_90812c` AS `_903ae0`,
						`_t_c0b7ea`.`_21d4b0` AS `_558491`,
						`_t_c0b7ea`.`_78e610` AS `_72611c`,
						`_t_c0b7ea`.`_e81a14` AS `_284988`,
						`_t_c0b7ea`.`_fd7d18` AS `_edfeda`,
						`_t_c0b7ea`.`_6d3161` AS `_d1c0dc`,
						`_t_c0b7ea`.`_22cced` AS `_03046b`,
						`_t_c0b7ea`.`_4cdee3` AS `_128510`,
						`_t_c0b7ea`.`_93e695` AS `_aff32a`
					FROM
						(
							SELECT
								`field_0` AS `_c17093`,
								`field_1` AS `_2b03d7`,
								`field_2` AS `_41c07b`,
								`field_3` AS `_1096d1`,
								`field_5` AS `_b43751`,
								`field_6` AS `_173ca2`,
								`field_7` AS `_bb6ad7`,
								`id` AS `_0b285d`,
								`field_4` AS `_21c30c`,
								`field_8` AS `_8fe120`
							FROM
								`user_db_1`.`dp_file_619_464_100099_100000`
						) AS _t_3480c6
					CROSS JOIN (
						SELECT
							`nick` AS `_abdb83`,
							`date` AS `_c01da2`,
							`source` AS `_71f39f`,
							`impressions` AS `_372f34`,
							`click` AS `_e9b723`,
							`cost` AS `_4b9c8d`,
							`directpaycount` AS `_1710b9`,
							`directpay` AS `_6a4198`,
							`indirectpaycount` AS `_b7f13b`,
							`indirectpay` AS `_8e3a5f`,
							`favItemCount` AS `_2084fa`,
							`favShopCount` AS `_9d3e02`,
							`carttotal` AS `_1da47a`,
							`indirectcarttotal` AS `_7f1af8`,
							`directcarttotal` AS `_90812c`,
							`ctr` AS `_21d4b0`,
							`cpc` AS `_78e610`,
							`cpm` AS `_e81a14`,
							`paycount` AS `_fd7d18`,
							`pay` AS `_6d3161`,
							`favCount` AS `_22cced`,
							`roi` AS `_4cdee3`,
							`roc` AS `_93e695`
						FROM
							`user_db_1`.`dp_ztc_d_rpt_cust_share`
						WHERE
							(`user_id` = 100099)
						AND (`group_id` = 100000)
						AND (`dp_src_id` = 177)
					) AS _t_c0b7ea ON (
						`_t_3480c6`.`_c17093` = `_t_c0b7ea`.`_abdb83`
					)
				) AS _t_f5a081
		) AS _t_0588cd ON (
			`_t_89ac4c`.`_d9d081` = `_t_0588cd`.`_5a8a51`
		)
	) AS `__1nbp2f`
GROUP BY
	`field_2_00`,
	`dateAndHour0`
LIMIT 501