TYPE=TRIGGERS
triggers='CREATE DEFINER=`rqg`@`localhost` TRIGGER trigger131230 BEFORE INSERT ON trigger131230 FOR EACH ROW INSERT INTO transforms.trigger231230 SELECT /* QNO 17582 CON_ID 11 */ alias1.`col_int` AS cfield1 FROM ( `table0_myisam_int` AS alias1 RIGHT OUTER JOIN `table0_myisam_int` AS alias2 ON (( alias2.`pk` = alias1.`pk` ) AND (alias2.`pk` < alias1.`pk` ) ) ) WHERE ( EXISTS ( SELECT SQ1_alias1.`pk` AS SQ1_ifield1 FROM ( `table0_myisam_int` AS SQ1_alias1, `table0_myisam_int` AS SQ1_alias2 ) WHERE SQ1_alias1.`pk` != alias2.`col_int` AND SQ1_alias2.`col_int` >= SQ1_alias2.`col_int` ) ) AND ( alias1.`pk` > 150 AND alias1.`pk` < ( 116 + 52 ) OR ( alias1.`pk` <> \'f\' OR alias1.`pk` IN (107) ) ) GROUP BY cfield1 ORDER BY cfield1'
sql_modes=1411383296
definers='rqg@localhost'
client_cs_names='latin1'
connection_cl_names='latin1_swedish_ci'
db_cl_names='latin1_swedish_ci'
created=159413617538
