Skip to main content Help Control Panel

Login   A+   A-

Home «   Help index «   Formatting Codes «  

Live codes

SELECT articles.* FROM yacs_articles AS articles WHERE (articles.anchor LIKE 'section:4028') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2025-10-28 22:10:13') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-10-28 22:10:13'))) ORDER BY rank, edit_date DESC, title LIMIT 0,101
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', edit_date DESC, title LIMIT 0,101' at line 1

SELECT articles.* FROM yacs_articles AS articles WHERE (articles.anchor LIKE 'section:4027') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2025-10-28 22:10:13') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-10-28 22:10:13'))) ORDER BY rank, publish_date DESC, title LIMIT 0,101
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', publish_date DESC, title LIMIT 0,101' at line 1

SELECT articles.* FROM yacs_articles AS articles WHERE (articles.anchor LIKE 'section:4362') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2025-10-28 22:10:13') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-10-28 22:10:13'))) ORDER BY rank, edit_date DESC, title LIMIT 0,101
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', edit_date DESC, title LIMIT 0,101' at line 1

SELECT articles.* FROM yacs_articles AS articles WHERE (articles.anchor LIKE 'section:4029') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2025-10-28 22:10:13') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-10-28 22:10:13'))) ORDER BY rank, publish_date DESC, title LIMIT 0,101
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', publish_date DESC, title LIMIT 0,101' at line 1

SELECT articles.* FROM yacs_articles AS articles WHERE (articles.anchor LIKE 'section:2358') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2025-10-28 22:10:13') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-10-28 22:10:13'))) ORDER BY rank, edit_date DESC, title LIMIT 0,101
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', edit_date DESC, title LIMIT 0,101' at line 1

SELECT articles.* FROM yacs_articles AS articles WHERE (articles.anchor LIKE 'section:4180') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2025-10-28 22:10:13') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-10-28 22:10:13'))) ORDER BY rank, edit_date DESC, title LIMIT 0,101
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', edit_date DESC, title LIMIT 0,101' at line 1

SELECT articles.* FROM yacs_articles AS articles WHERE (articles.anchor LIKE 'section:4516') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2025-10-28 22:10:13') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-10-28 22:10:13'))) ORDER BY rank, edit_date DESC, title LIMIT 0,101
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', edit_date DESC, title LIMIT 0,101' at line 1

SELECT articles.* FROM yacs_articles AS articles WHERE (articles.anchor LIKE 'section:4113') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2025-10-28 22:10:13') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-10-28 22:10:13'))) ORDER BY rank, edit_date DESC, title LIMIT 0,101
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', edit_date DESC, title LIMIT 0,101' at line 1

On this page we are introducing codes related to dynamic queries of site content.

ContentClick to slide

Sections [sections] [sections=section:<id>]

ExampleRendering
[sections]

Assigned sections [sections=self] [sections=user:<id>]

ExampleRendering
[sections.folded=self]
Click to slide Rallye Neige & Glace
Click to slide Rallye des Princesses
Click to slide Tout sur l'édition 2008
Click to slide TransAfricaine Classic : 11 au 29 novembre 2008
Click to slide Patrick Zaniroli Promotion, c'est aussi ... (4 sections)
Click to slide Benvenuto
Click to slide Nouveau site
Click to slide Welcome

Categories [categories] [categories=category:<id>]

ExampleRendering
[categories]

Assigned categories [categories=self] [categories=user:<id>]

ExampleRendering
[categories=self]

Recent pages [published] [published=section:<id>] [published=category:<id>]

Use the simplest form to display a compact list of pages, or limit the scope.

ExampleRendering
[published.decorated]
NewsLetter Juin 2012 Published on June 19 2012, in Divers
Friday 1 June: Stage 5 -Le Castellet - Monaco Edited on June 13 2012, in Back to the 13rd Edition of the Rallye des Princesses
Thursday 31 May: Stage 4- Le Rouret - Le Castellet Edited on June 13 2012, in Back to the 13rd Edition of the Rallye des Princesses
Wednesday 30 May, 2013: Stage 3: Vichy - Le Rouret (07) Edited on June 13 2012, in Back to the 13rd Edition of the Rallye des Princesses
Tuesday 29 May, 2013 : Stage 2 : La Châtre - Vichy (03) Edited on June 10 2012, in Back to the 13rd Edition of the Rallye des Princesses
Monday 28 May, 2013 : Stage 1 : Paris - La Châtre (36) Edited on June 10 2012, in Back to the 13rd Edition of the Rallye des Princesses
Sunday 27 May, 2012 : Checks to The Invalides in Paris Edited on June 10 2012, in Back to the 13rd Edition of the Rallye des Princesses

Personal pages [published=self] [published=user:<id>]

ExampleRendering
[published=self, 20]

Recent updates [updated] [updated=section:<id>] [updated=category:<id>]

Use the simplest form to display a compact list of pages, or limit the scope.

ExampleRendering
[updated.timeline]
à vendre VW iltis armée belge (1 comment) (popular)  
commented by raoul Radulph de Méré on Oct. 21 2012
Retour sur le rallye des Princesses 2012 (popular)  
edited by Viviane Zaniroli on Sep. 7 2012
TOUS NOS RENDEZ-VOUS (popular)  
edited by Viviane Zaniroli on Sep. 5 2012
Bienvenue (popular)  
edited by Viviane Zaniroli on Sep. 3 2012
Stages d'initiation à la régularité (popular)  
file uploaded by Viviane Zaniroli on Sep. 3 2012
NewsLetter Juin 2012 (popular)  
published by Viviane Zaniroli on June 19 2012
A different kind of women’s motor sport event! (popular)  
edited by Viviane Zaniroli on June 13 2012

Personal updates [updated=self] [updated=user:<id>]

ExampleRendering
[updated=self, 12]

Hall of fame [read] [read=section:<id>]

Use the simplest form to display a compact list of pages, or limit the scope.

ExampleRendering
[read]

Personal hits [read=self] [read=user:<id>]

ExampleRendering
[read=self]

Hall of fame [voted] [voted=section:<id>]

Use the simplest form to display a compact list of pages, or limit the scope.

ExampleRendering
[voted]

Personal hits [voted=self] [voted=user:<id>]

ExampleRendering
[voted=self]

Collections [collections]

Use the configuration panel for collections to create new collections of files.

ExampleRendering
[collections]

Present users [users=present]

ExampleRendering
[users=present]
Help

Please note that actual rendering depends on the selected skin.