| 1 | DESCRIBE `tags` | | 2 | 2 | 1 |
| 2 | DESCRIBE `articles` | | 12 | 12 | 1 |
| 3 | DESCRIBE `articles_tags` | | 2 | 2 | 1 |
| 4 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` WHERE `Tag`.`tag` = 'pdabuzz' LIMIT 1 | | 1 | 1 | 0 |
| 5 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` JOIN `articles_tags` ON (`articles_tags`.`tag_id` = 10 AND `articles_tags`.`article_id` = `Article`.`id`) WHERE 1 = 1 ORDER BY `Article`.`created` DESC | | 33 | 33 | 1 |
| 6 | SELECT COUNT(*) AS `count` FROM `articles_tags` AS `ArticlesTag` LEFT JOIN `articles` AS `Article` ON (`ArticlesTag`.`article_id` = `Article`.`id`) LEFT JOIN `tags` AS `Tag` ON (`ArticlesTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`id`=10 | | 1 | 1 | 0 |
| 7 | SELECT `ArticlesTag`.`article_id`, `ArticlesTag`.`tag_id`, `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified`, `Tag`.`id`, `Tag`.`tag` FROM `articles_tags` AS `ArticlesTag` LEFT JOIN `articles` AS `Article` ON (`ArticlesTag`.`article_id` = `Article`.`id`) LEFT JOIN `tags` AS `Tag` ON (`ArticlesTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`id`=10 ORDER BY `created` DESC LIMIT 10 | | 10 | 10 | 0 |
| 8 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 982 LIMIT 1 | | 1 | 1 | 0 |
| 9 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 982 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | | 2 | 2 | 0 |
| 10 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 981 LIMIT 1 | | 1 | 1 | 0 |
| 11 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 981 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | | 3 | 3 | 0 |
| 12 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 974 LIMIT 1 | | 1 | 1 | 0 |
| 13 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 974 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | | 4 | 4 | 1 |
| 14 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 975 LIMIT 1 | | 1 | 1 | 1 |
| 15 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 975 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | | 4 | 4 | 1 |
| 16 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 976 LIMIT 1 | | 1 | 1 | 0 |
| 17 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 976 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | | 2 | 2 | 1 |
| 18 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 977 LIMIT 1 | | 1 | 1 | 1 |
| 19 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 977 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | | 3 | 3 | 1 |
| 20 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 978 LIMIT 1 | | 1 | 1 | 1 |
| 21 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 978 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | | 3 | 3 | 0 |
| 22 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 896 LIMIT 1 | | 1 | 1 | 1 |
| 23 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 896 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | | 3 | 3 | 2 |
| 24 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 897 LIMIT 1 | | 1 | 1 | 1 |
| 25 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 897 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | | 2 | 2 | 0 |
| 26 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 898 LIMIT 1 | | 1 | 1 | 0 |
| 27 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 898 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | | 3 | 3 | 1 |
Resco has released an all new version of Resco Explorer for Palm OS devices. Explorer is a powerful and feature rich file system browser, image viewer, launcher, zipper, backup utility and FTP/LAN browser with an impressive range of features and customizable options. The new 2008 version includes many GUI improvements including smooth scrolling and an improved search dialogue, bluetooth browsing and FTP support, an improved audio player with network streaming support, new general options and a secure storage area that will allow you to encrypt files and folders of your data in a secured area. You can view the full list of updates here.
(Credit: Solar Technology)
]]>