Aller à la navigation
Aller au contenu principal
Application ciao Disponible sur iTunes Appli sur Google Play
Estime de soi : ton thermomètre

Nouveau dans la rubrique Argent :

Test

Quiz

Dernières Questions Réponses

SELECT questions.ref, questions.question, reponses.reponse, textcat(textcat(textcat(cast (date_part('day',questions.date_question) as text), '.'), textcat(cast (date_part('month',questions.date_question) as text), '.')), cast (date_part('year',questions.date_question) as text)), textcat(textcat(textcat(cast(date_part('day',questions.date_reponse) as text), '.'), textcat(cast (date_part('month',questions.date_reponse) as text), '.')), cast ( date_part('year',questions.date_reponse) as text)), chapitres.chapitre, chapitres.chapitrecourt, b_multirub, titre, pseudos.pseudo, pseudos.annee_naissance, pseudos.refsex, cantons.canton, b_perso, b_repondu, intro_perso, intro_publique, b_multirub, refparent, b_enrep, questions.pays FROM questions, reponses, chapitres, pseudos, cantons WHERE (questions.ref=reponses.ref ) AND questions.refcanton=cantons.ref AND questions.refchapitre = chapitres.ref AND questions.refpseudo=pseudos.ref AND b_repondu='t' AND b_afficher='t' AND b_perso='f' AND (b_multirub = 'f' or (b_multirub = 't' and b_enrep='t')) AND date_question < now()-cast((345600 ||'seconds') AS interval) AND b_perso='f' AND ( ( ((questions.refchapitre NOT IN(23,24) AND date_question > now()-cast((365 ||'days') AS interval)) OR (questions.refchapitre IN(23,24) AND date_question > now()-cast((1460 ||'days') AS interval)) ) AND (b_validite='t' OR b_validite IS null) ) OR (date_question > now()-cast((60 ||'days') AS interval) AND (b_validite='f' OR b_validite IS null)) ) AND questions.refparent is null and pseudos.pseudo != 'Eclairage CIAO' ORDER BY questions.ref desc LIMIT 60 OFFSET 0; Array ( [HTTP_HOST] => www.ciao.ch [HTTP_ACCEPT_ENCODING] => x-gzip, gzip, deflate [HTTP_USER_AGENT] => CCBot/2.0 (http://commoncrawl.org/faq/) [HTTP_ACCEPT_LANGUAGE] => en-us,en-gb,en;q=0.7,*;q=0.3 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 [PATH] => /usr/local/bin:/usr/bin:/bin [SERVER_SIGNATURE] =>
Apache/2.2.16 (Debian) Embperl/2.3.0 PHP/5.3.3-7+squeeze14 with Suhosin-Patch Midgard/8.09.9.2 mod_perl/2.0.4 Perl/v5.10.1 Server at www.ciao.ch Port 80
[SERVER_SOFTWARE] => Apache/2.2.16 (Debian) Embperl/2.3.0 PHP/5.3.3-7+squeeze14 with Suhosin-Patch Midgard/8.09.9.2 mod_perl/2.0.4 Perl/v5.10.1 [SERVER_NAME] => www.ciao.ch [SERVER_ADDR] => 62.220.129.212 [SERVER_PORT] => 80 [REMOTE_ADDR] => 54.197.65.82 [DOCUMENT_ROOT] => /var/lib/midgard/vhosts/search/80 [SERVER_ADMIN] => [no address given] [SCRIPT_FILENAME] => /var/cache/midgard/midgardlive/2-4-7-0.php [REMOTE_PORT] => 42639 [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_PROTOCOL] => HTTP/1.0 [REQUEST_METHOD] => GET [QUERY_STRING] => [REQUEST_URI] => /f/ [SCRIPT_NAME] => /f/ [PHP_SELF] => /f/ [REQUEST_TIME] => 1418898351 [argv] => Array ( ) [argc] => 0 )

Voir toutes les Q/R