| 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` = 'Major League Baseball' LIMIT 1 | | 1 | 1 | 1 |
| 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` = 46 AND `articles_tags`.`article_id` = `Article`.`id`) WHERE 1 = 1 ORDER BY `Article`.`created` DESC | | 1 | 1 | 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`=46 | | 1 | 1 | 1 |
| 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`=46 ORDER BY `created` DESC LIMIT 10 | | 1 | 1 | 1 |
| 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` = 984 LIMIT 1 | | 1 | 1 | 3 |
| 9 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 984 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | | 3 | 3 | 1 |
Toysoft has released their 2008 Major League Baseball schedule and guide for Palm OS. mySchedule MLB includes all 30 MLB team's regular schedules, all team rosters, player salaries, coaches and staff listings. In addition, mySchedule includes a graphical view of player positions and game day games. You can also export any team's schedule to the DateBook or Calendar application with an alarm reminder so you never miss the first pitch.