Contact

We want to hear what you think - good, or bad! 
Fill in the form below and we'll get back to as soon as we can!

TDE Game Reference

Found Combat Techniques: 1


DEBUG - Start


-> Database-Connect
bisherige Verarbeitungszeit (sec): 2.2074270248413

Database connect successful.

SQL-Statement: Items/List

		SELECT DISTINCT combat_technique
		FROM tbl_en_combat_techniques 
		LEFT JOIN tbl_en_combat_techniques_publications 
		  ON tbl_en_combat_techniques_publications.pid = tbl_en_combat_techniques.id
		LEFT JOIN tbl_en_publication 
		  ON tbl_en_publication.id = tbl_en_combat_techniques_publications.id_publication
		 
		WHERE  ADDDATE(FROM_UNIXTIME(tbl_en_publication.publication_date,'%Y.%m.%d'),90)<= curdate()  
		ORDER BY combat_technique ASC; 
		

duration - total (sec): 2.2085418701172

DEBUG - End


Genutzte / Gefundene Datenbanktabellen

Tabelle: tbl_en_attributes (Anzahl: 2)
[75] LEFT JOIN tbl_en_attributes
[171] LEFT JOIN tbl_en_attributes

Tabelle: tbl_en_combat_techniques (Anzahl: 3)
[52] FROM tbl_en_combat_techniques
[97] FROM tbl_en_combat_techniques
[211] FROM tbl_en_combat_techniques

Tabelle: tbl_en_combat_techniques_primary_attribute (Anzahl: 2)
[74] FROM tbl_en_combat_techniques_primary_attribute
[169] LEFT JOIN tbl_en_combat_techniques_primary_attribute

Tabelle: tbl_en_combat_techniques_publications (Anzahl: 2)
[120] FROM tbl_en_combat_techniques_publications
[212] LEFT JOIN tbl_en_combat_techniques_publications

Tabelle: tbl_en_improvement_cost (Anzahl: 2)
[98] LEFT JOIN tbl_en_improvement_cost
[182] LEFT JOIN tbl_en_improvement_cost

Tabelle: tbl_en_publication (Anzahl: 2)
[121] LEFT JOIN tbl_en_publication
[214] LEFT JOIN tbl_en_publication

Tabelle: 0 (Anzahl: 3)
[156] $sql_join = "";
[168] $sql_join .= "
[181] $sql_join .= "


This page is only for testing!