Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXPLAIN SELECT nt.deutsch_id, nt.article, n.deutsch_word, ft.french_id, ft.article, f.french_word, p.part, fd.transcription, fd.definition
- FROM translation_enfr ft
- INNER JOIN translation_ende nt ON nt.translation_id = ft.translation_id
- INNER JOIN deutsch n ON n.deutsch_id = nt.deutsch_id
- INNER JOIN french f ON f.french_id = ft.french_id
- INNER JOIN parts p ON p.part_id = ft.part_id
- LEFT JOIN french_details fd ON fd.translation_id = ft.translation_id
- WHERE ft.translation_id =2
- public function getNativeWord($withArticle = true) {
- if(is_null($this->nativeWord)) {
- $q = "SELECT {$langLabel}_word FROM {$langLabel}
- WHERE {$langLabel}_id = :native_id";
- }
- }
- "SELECT {$langLabel}_word FROM {$langLabel} WHERE {$langLabel}_id = :foreign_id"
- "SELECT article FROM translation_en{$this->nativeLang} WHERE translation_id = :translation_id";
- "SELECT parts.part FROM parts INNER JOIN translation ON parts.part_id = translation.part_id WHERE translation_id = :trans_id"
- "SELECT transcription FROM {$langLabel}_details WHERE translation_id = :trans_id";
- "SELECT definition FROM {$langLabel}_details WHERE translation_id = :trans_id";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement