array(12) { ["rec_type"]=> string(6) "rapide" ["rec_tri"]=> NULL ["rec_tri_sens"]=> NULL ["rec_clss"]=> string(3) "207" ["typecritere"]=> int(5) ["critere"]=> string(3) "207" ["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 = '207' 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 = '207' 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(4) "1019" ["nbpages"]=> int(68) ["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 = '207' 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 = '207' 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

Air du temps

Afficher davantage d'ouvrages
Haut de page