(mysqlt): select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID) and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) left join PageTypes pt on pt.ctID = cv.ctID inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and (ak_pebble_authorName LIKE '%Pierre%') and (p1.cID!='128') and cvName != '' and pt.ctID = '10' and (ak_exclude_page_list = 0 OR ak_exclude_page_list is null) and PagePaths.cPath like '/apps/%' and PagePaths.ppIsCanonical = '1' and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and ((select count(cID) from PagePermissionAssignments ppa1 inner join PermissionAccessList pa1 on ppa1.paID = pa1.paID where ppa1.cID = if(p2.cID is null, p1.cInheritPermissionsFromCID, p2.cInheritPermissionsFromCID) and pa1.accessType = 10 and pa1.pdID in (0)
and pa1.peID in (2) and (if(pa1.peID = 4 and p1.uID <>0, false, true)) and (ppa1.pkID = 1 and cv.cvIsApproved = 1)) > 0
or (p1.cPointerExternalLink !='' AND p1.cPointerExternalLink IS NOT NULL)) and ((select count(cID) from PagePermissionAssignments ppaExclude inner join PermissionAccessList paExclude on ppaExclude.paID = paExclude.paID where ppaExclude.cID = if(p2.cID is null, p1.cInheritPermissionsFromCID, p2.cInheritPermissionsFromCID) and accessType = -1 and pdID in (0)
and paExclude.peID in (2) and (if(paExclude.peID = 4 and p1.uID <>0, false, true)) and (ppaExclude.pkID = 1 and cv.cvIsApproved = 1)) = 0) and ak_pebble_flag = '0' and ak_pebble_subApp = '0' and p1.cIsActive = '1' order by ak_pebble_dateAdded desc limit 0,56
-
Description
RChrono is a chronometer watchapp for the PEBBLE watch (Firmware 2).
Features are:
• 30 laps
• Up to 999h59min59s
• Final time calculation
• Interval timer
• Hydration timer
• Heart rate measurement (manual procedure)
• Auto-distance
• Time display
• Completely offline (no need of a smartphone)
• Data saved if you quit the application
How it works?
First, RChrono is a standard chronometer with 30 lap's capacity. The interesting feature is the final time calculation.
An example of use is better than a long description.
You want to run a marathon. In the setting menu, you set 42.2 for the final distance. At the beginning of the race you start the chronometer. Commonly on a marathon you have label each 5km. At each label, you press the lap button, you enter the distance and the watch will estimate the final time. The final time will be updated each you time you enter a new distance.
In order to calculate the final time, the program calculates your average speed and estimate the final time assuming that you will continue to run at the same speed. Simple…
The Auto-distance feature allows the program to automatically add an amount of distance at each lap. For example, if you set 5 the program will add 5 to the distance each time you press the lap button. You will have just to validate the distance (or you can modify the distance).
More information here: http://dpsite.free.fr/index.php5?n=Main.RChrono
created by - Pierre