<commit_before><?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
    <entry key="tech.culture">
        <![CDATA[
			SELECT
  				max(CAST(SUBSTRING(stack.r_province, 8, 2) AS INTEGER))
			FROM counter counter
    			INNER JOIN stack stack ON counter.id_stack = stack.id
    			INNER JOIN r_country country ON counter.r_country = country.name
			WHERE counter.type = ':techType'
    			AND country.culture in :cultures
    			AND stack.ID_GAME = :idGame
			;
		]]>
    </entry>
</properties><commit_msg>DB2 and Mysql different syntax<commit_after><?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
	<entry key="income.exoRes">
		<![CDATA[
			SELECT
				SUM(price)
			FROM (
  				SELECT
  					SUM(er.NUMBER) * CAST(SUBSTRING(s.R_PROVINCE, 6, 1) AS INTEGER) AS PRICE
  				FROM exotic_resources er
  					INNER JOIN establishment e ON er.ID_ESTABLISHMENT = e.ID
  					INNER JOIN counter c0 ON e.ID_COUNTER = c0.ID
  					INNER JOIN counter c1 ON c1.type = concat(er.RESOURCE, '_PRICE')
  					INNER JOIN stack s ON c1.ID_STACK = s.ID
  				WHERE c0.R_COUNTRY = ':countryName'
  					AND s.ID_GAME = :idGame
  				GROUP BY er.RESOURCE, s.R_PROVINCE
			) as t
		;
		]]>
	</entry>
    <entry key="tech.culture">
        <![CDATA[
			SELECT
  				max(CAST(SUBSTRING(stack.r_province, 8, 2) AS INTEGER))
			FROM counter counter
    			INNER JOIN stack stack ON counter.id_stack = stack.id
    			INNER JOIN r_country country ON counter.r_country = country.name
			WHERE counter.type = ':techType'
    			AND country.culture in :cultures
    			AND stack.ID_GAME = :idGame
			;
		]]>
    </entry>
</properties>
{'fraction_non_alphanumeric': 0.12013729977116705, 'fraction_numerical': 0.010869565217391304, 'mean_word_length': 2.89532293986637, 'pattern_counts': {'":': 0, '<': 20, '<?xml version=': 2, '>': 20, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 2}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3145899', 'n_tokens_mistral': 748, 'n_tokens_neox': 625, 'n_words': 155}