array(12) { ["rec_type"]=> string(6) "rapide" ["rec_tri"]=> NULL ["rec_tri_sens"]=> NULL ["rec_clss"]=> string(3) "201" ["typecritere"]=> int(5) ["critere"]=> string(3) "201" ["requete"]=> string(2965) "SELECT * FROM (SELECT e.codstock, titre, auteur, image2, RESUME, edition, codclub, datelibrairie, familleweb FROM (SELECT codstock, min(CODCLUB) as tc FROM (SELECT DISTINCT a.codstock, a.titre, a.auteur, a.image2, a.RESUME, a.edition, a.datelibrairie, a.codclub, a.familleweb, coalesce(d.WCL_CLASSIFICATION, '') AS wcl FROM EDITO_STOCK a, REFERENCE b, STOCK c, WEB_CLASSIFICATION d WHERE a.codstock = b.codstock AND a.codstock = c.codstock AND (c.balance > '0' OR c.etat != 'E') AND c.codmag = '10' AND a.codstock = d.WCL_PRODUCT_NUMBER AND b.groupe = 1 AND b.typeart <> 'S' AND ( (b.cetelem <= 0) OR (b.cetelem IS NULL) ) AND (WCL_CLASSIFICATION = '201' OR WCL_CLASSIFICATION REGEXP REPLACE(CONCAT('(', (SELECT GROUP_CONCAT(DISTINCT sChildrenTheme.STH_SEARCH_TERM) FROM `SETTINGS_MENU_SUBENTRIES` sParent LEFT JOIN `SETTINGS_MENU_SUBENTRIES` sChildren ON (sParent.SMS_ID = sChildren.SMS_PARENT_ID OR sParent.SMS_ID = sChildren.SMS_ID) AND sParent.SMS_CLUB = sChildren.SMS_CLUB LEFT JOIN SETTINGS_THEME sChildrenTheme on REPLACE(sChildren.SMS_URL_PARAMS, 'codtheme=', '') = sChildrenTheme.STH_ID AND sChildrenTheme.STH_CLUB = 12 WHERE sParent.SMS_FAMILLE = '201' AND sParent.SMS_CLUB = 12 AND sChildren.SMS_URL_PAGE = 'theme' AND sChildrenTheme.STH_SEARCH_TERM <> ''), ')'), ',', '|')) AND d.WCL_CLUB_CODE = 12 ) as T1 where wcl > '' group by T1.codstock) as T2 left join EDITO_STOCK e on T2.codstock = e.codstock and e.CODCLUB = T2.tc) as T3" ["nbarticles"]=> string(3) "101" ["nbpages"]=> int(7) ["npage"]=> int(1) ["debut"]=> int(0) ["fin"]=> int(15) } SELECT * FROM (SELECT e.codstock, titre, auteur, image2, RESUME, edition, codclub, datelibrairie, familleweb FROM (SELECT codstock, min(CODCLUB) as tc FROM (SELECT DISTINCT a.codstock, a.titre, a.auteur, a.image2, a.RESUME, a.edition, a.datelibrairie, a.codclub, a.familleweb, coalesce(d.WCL_CLASSIFICATION, '') AS wcl FROM EDITO_STOCK a, REFERENCE b, STOCK c, WEB_CLASSIFICATION d WHERE a.codstock = b.codstock AND a.codstock = c.codstock AND (c.balance > '0' OR c.etat != 'E') AND c.codmag = '10' AND a.codstock = d.WCL_PRODUCT_NUMBER AND b.groupe = 1 AND b.typeart <> 'S' AND ( (b.cetelem <= 0) OR (b.cetelem IS NULL) ) AND (WCL_CLASSIFICATION = '201' OR WCL_CLASSIFICATION REGEXP REPLACE(CONCAT('(', (SELECT GROUP_CONCAT(DISTINCT sChildrenTheme.STH_SEARCH_TERM) FROM `SETTINGS_MENU_SUBENTRIES` sParent LEFT JOIN `SETTINGS_MENU_SUBENTRIES` sChildren ON (sParent.SMS_ID = sChildren.SMS_PARENT_ID OR sParent.SMS_ID = sChildren.SMS_ID) AND sParent.SMS_CLUB = sChildren.SMS_CLUB LEFT JOIN SETTINGS_THEME sChildrenTheme on REPLACE(sChildren.SMS_URL_PARAMS, 'codtheme=', '') = sChildrenTheme.STH_ID AND sChildrenTheme.STH_CLUB = 12 WHERE sParent.SMS_FAMILLE = '201' AND sParent.SMS_CLUB = 12 AND sChildren.SMS_URL_PAGE = 'theme' AND sChildrenTheme.STH_SEARCH_TERM <> ''), ')'), ',', '|')) AND d.WCL_CLUB_CODE = 12 ) as T1 where wcl > '' group by T1.codstock) as T2 left join EDITO_STOCK e on T2.codstock = e.codstock and e.CODCLUB = T2.tc) as T3 au Club Nouvelles Clés

Bien dans sa tête

livre '10 minutes par jour pour enchanter son quotidien' de Pascale Wettstein label-offer -20 %

10 minutes par jour pour enchanter son quotidien

Pascale Wettstein

Nous traversons trop souvent nos journées à accomplir machinalement la multitude de tâches quotidiennes qui nous incombent, sans prêter attention aux innombrables petites joies qui parsèment notre chemin. Et si nous ouvrions grand les yeux et partions à la découverte de notre propre pays des...

Afficher davantage d'ouvrages
Haut de page

Utilisation des cookies

En poursuivant votre navigation sans modifier vos paramètres, vous acceptez l'utilisation des cookies ou technologies similaires pour disposer de services et d'offres adaptés à vos centres d'intérêts ainsi que pour la sécurisation des transactions sur notre site. Pour plus d’informations, gérer ou modifier les paramètres, cliquez ici.