« Modèle:ReqMytheme2 » : différence entre les versions
De Mythemes
Aucun résumé des modifications |
Aucun résumé des modifications |
||
| Ligne 3 : | Ligne 3 : | ||
|fields=Re._pageName, Re.word, Re.pos, Oe._pageName=Œuvre,Oe.univers=Univers, My.categorie, Re.liste=Liste, Re.effGlob, Re.effLoc, Re.coefRep, Re.coefSurRep, Re.distance, Re.coocClassique, Re.csrd | |fields=Re._pageName, Re.word, Re.pos, Oe._pageName=Œuvre,Oe.univers=Univers, My.categorie, Re.liste=Liste, Re.effGlob, Re.effLoc, Re.coefRep, Re.coefSurRep, Re.distance, Re.coocClassique, Re.csrd | ||
|join on=Re.oeuvreId=Oe.oeuvreId, Re.mythemeId=My.mythemeId | |join on=Re.oeuvreId=Oe.oeuvreId, Re.mythemeId=My.mythemeId | ||
|where=Re.mythemeId="{{{mythemeId|}}}" {{#if:{{{auteurs|}}}|AND ( {{#arraymap:{{{auteurs}}}|;|XXX| Oe.auteurs HOLDS "XXX"}}) }}{{#if:{{{lieuPub|}}}|AND lieuPub NEAR ("{{{lieuPub}}}",10 km) }}{{#if:{{{langs|}}}|AND ( {{#arraymap:{{{langs}}}|;|XXX| Oe.lang = "XXX"|\s OR \s}}) }}{{#if:{{{datePubInf|}}}|AND Oe.datePub > "{{{datePubInf}}}" }}{{#if:{{{datePubSup|}}}| AND Oe.datePub < "{{{datePubSup}}}" }}{{#if:{{{dateFiction|}}}| AND ( {{#arraymap:{{{dateFiction}}}|;|XXX| Oe.dateFiction = "XXX"}}) }}{{#if:{{{lieuFiction|}}}|AND ( {{#arraymap:{{{lieuFiction}}}|;|XXX| Oe.lieuFiction = "XXX"| \s OR \s }}) }}{{#if:{{{univers|}}}|AND ( {{#arraymap:{{{univers}}}|;|XXX| univers HOLDS "XXX"| \s OR \s }}) }}{{#if:{{{pos|}}}|AND ( {{#arraymap:{{{pos}}}|;|XXX| Re.pos HOLDS "XXX"| \s OR \s }}) }} AND effGlob > "{{{effGlob|1}}}" AND effLoc > "{{{effLoc|1}}}" AND coefRep > "{{{coefRep|0}}}" AND coefSurRep > "{{{coefSurRep|1}}}" AND distance < "{{{distance|2}}}" AND csrd > "{{{csrd|0}}}" {{#if:{{{categorie|}}}|AND ( {{#arraymap:{{{categorie}}}|;|XXX| My.categorie HOLDS "XXX"| \s OR \s }}) }} | |where=Re.mythemeId="{{{mythemeId|}}}" {{#if:{{{auteurs|}}}|AND ( {{#arraymap:{{{auteurs}}}|;|XXX| Oe.auteurs HOLDS "XXX"|\s OR \s}}) }}{{#if:{{{lieuPub|}}}|AND lieuPub NEAR ("{{{lieuPub}}}",10 km) }}{{#if:{{{langs|}}}|AND ( {{#arraymap:{{{langs}}}|;|XXX| Oe.lang = "XXX"|\s OR \s}}) }}{{#if:{{{datePubInf|}}}|AND Oe.datePub > "{{{datePubInf}}}" }}{{#if:{{{datePubSup|}}}| AND Oe.datePub < "{{{datePubSup}}}" }}{{#if:{{{dateFiction|}}}| AND ( {{#arraymap:{{{dateFiction}}}|;|XXX| Oe.dateFiction = "XXX"|\s OR \s}}) }}{{#if:{{{lieuFiction|}}}|AND ( {{#arraymap:{{{lieuFiction}}}|;|XXX| Oe.lieuFiction = "XXX"| \s OR \s }}) }}{{#if:{{{univers|}}}|AND ( {{#arraymap:{{{univers}}}|;|XXX| univers HOLDS "XXX"| \s OR \s }}) }}{{#if:{{{pos|}}}|AND ( {{#arraymap:{{{pos}}}|;|XXX| Re.pos HOLDS "XXX"| \s OR \s }}) }} AND effGlob > "{{{effGlob|1}}}" AND effLoc > "{{{effLoc|1}}}" AND coefRep > "{{{coefRep|0}}}" AND coefSurRep > "{{{coefSurRep|1}}}" AND distance < "{{{distance|2}}}" AND csrd > "{{{csrd|0}}}" {{#if:{{{categorie|}}}|AND ( {{#arraymap:{{{categorie}}}|;|XXX| My.categorie HOLDS "XXX"| \s OR \s }}) }} | ||
|group by=Re.word,Re.oeuvreId,Re.mythemeId | |group by=Re.word,Re.oeuvreId,Re.mythemeId | ||
|format= dynamic table | |format= dynamic table | ||
