click the green flag to begein <TABLE class=cakeSqlLog id=cakeSqlLog_120548051747da2c45cb5f81_29476553 cellSpacing=0 summary="Cake SQL Log" border=0> <CAPTION>10 queries took 167 ms</CAPTION> <THEAD> <TR> <TH>Nr</TH> <TH>Query</TH> <TH>Error</TH> <TH>Affected</TH> <TH>Num. rows</TH> <TH>Took (ms)</TH></TR></THEAD> <TBODY> <TR> <TD>1</TD> <TD>SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext` FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE proj_visibility!='delbyusr' AND proj_visibility!='delbyadmin' AND proj_visibility!='delbyusr' AND proj_visibility!='delbyadmin' AND `Project`.`id` = 119462 LIMIT 1</TD> <TD></TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">2</TD></TR> <TR> <TD>2</TD> <TD>SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (119462) </TD> <TD></TD> <TD style="TEXT-ALIGN: right">0</TD> <TD style="TEXT-ALIGN: right">0</TD> <TD style="TEXT-ALIGN: right">1</TD></TR> <TR> <TD>3</TD> <TD>SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext` FROM `users` AS `User` WHERE `User`.`id` = 90475 LIMIT 1</TD> <TD></TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">1</TD></TR> <TR> <TD>4</TD> <TD>INSERT INTO `notifications` (`user_id`,`custom_message`,`status`) VALUES (90475,'We remind you to use appropriate language for all ages, please read the <a href=\"/terms\">Terms of Use</a>','unread')</TD> <TD></TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right"></TD> <TD style="TEXT-ALIGN: right">1</TD></TR> <TR> <TD>5</TD> <TD>SELECT LAST_INSERT_ID() AS insertID</TD> <TD></TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">1</TD></TR> <TR> <TD>6</TD> <TD>SELECT `User`.`username` FROM `users` AS `User` WHERE id = 90475 LIMIT 1</TD> <TD></TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">1</TD></TR> <TR> <TD>7</TD> <TD>SELECT COUNT(*) AS count FROM `notifications` AS `Notification` WHERE user_id=90475 AND status='unread' </TD> <TD></TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">157</TD></TR> <TR> <TD>8</TD> <TD>SELECT `Announcement`.`id`, `Announcement`.`user_id`, `Announcement`.`content`, `Announcement`.`timestamp`, `Announcement`.`isOn`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext` FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE content != '' </TD> <TD></TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">1</TD></TR> <TR> <TD>9</TD> <TD>SELECT COUNT(*) AS count FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE content = '' </TD> <TD></TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">1</TD> <TD style="TEXT-ALIGN: right">1</TD></TR> <TR> <TD>10</TD> <TD>SELECT `Announcement`.`id`, `Announcement`.`user_id`, `Announcement`.`content`, `Announcement`.`timestamp`, `Announcement`.`isOn`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext` FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE 1 = 1 </TD> <TD></TD> <TD style="TEXT-ALIGN: right">3</TD> <TD style="TEXT-ALIGN: right">3</TD> <TD style="TEXT-ALIGN: right">1</TD></TR></TBODY></TABLE>