SELECT sum( weight ) totalWeight, objectId
FROM TempTable
INNER JOIN T_Context ON TempTable.Name = T_Context.name
INNER JOIN T_Context_Object ON T_Context.id = T_Context_Object.contextId
WHERE T_Context.name
IN ('Accueil son','dummy') AND T_Context.environnement = 'cms' AND T_Context_Object.objectType='wallEnd' GROUP BY objectId Order by totalWeight desc;/n
SELECT sum( weight ) totalWeight, objectId
FROM TempTable
INNER JOIN T_Context ON TempTable.Name = T_Context.name
INNER JOIN T_Context_Object ON T_Context.id = T_Context_Object.contextId
WHERE T_Context.name
IN ('Accueil image','dummy') AND T_Context.environnement = 'cms' AND T_Context_Object.objectType='wallEnd' GROUP BY objectId Order by totalWeight desc;/n
SELECT sum( weight ) totalWeight, objectId
FROM TempTable
INNER JOIN T_Context ON TempTable.Name = T_Context.name
INNER JOIN T_Context_Object ON T_Context.id = T_Context_Object.contextId
WHERE T_Context.name
IN ('Accueil petit electro','dummy') AND T_Context.environnement = 'cms' AND T_Context_Object.objectType='wallEnd' GROUP BY objectId Order by totalWeight desc;/n
SELECT sum( weight ) totalWeight, objectId
FROM TempTable
INNER JOIN T_Context ON TempTable.Name = T_Context.name
INNER JOIN T_Context_Object ON T_Context.id = T_Context_Object.contextId
WHERE T_Context.name
IN ('Accueil gros electro','dummy') AND T_Context.environnement = 'cms' AND T_Context_Object.objectType='wallEnd' GROUP BY objectId Order by totalWeight desc;/n
SELECT sum( weight ) totalWeight, objectId
FROM TempTable
INNER JOIN T_Context ON TempTable.Name = T_Context.name
INNER JOIN T_Context_Object ON T_Context.id = T_Context_Object.contextId
WHERE T_Context.name
IN ('Accueil telecom','dummy') AND T_Context.environnement = 'cms' AND T_Context_Object.objectType='wallEnd' GROUP BY objectId Order by totalWeight desc;/n
SELECT sum( weight ) totalWeight, objectId
FROM TempTable
INNER JOIN T_Context ON TempTable.Name = T_Context.name
INNER JOIN T_Context_Object ON T_Context.id = T_Context_Object.contextId
WHERE T_Context.name
IN ('Accueil jeux video','dummy') AND T_Context.environnement = 'cms' AND T_Context_Object.objectType='wallEnd' GROUP BY objectId Order by totalWeight desc;/n
