User panel

Login - Register

View announcements:

Showing page 1 of 1

Announcement titleSymbol nameSector nameMarket name
This is a new announcementDSFالقطاع الehkdالسوق الاول
This is anannouncementASDالقطاع الehkdالسوق الاول

6 queries took 84 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `announcements`8822
2DESCRIBE `markets`2214
3DESCRIBE `sectors`3314
4DESCRIBE `symbols`4414
5SELECT COUNT(*) AS `count` FROM `announcements` AS `Announcement` LEFT JOIN `markets` AS `Market` ON (`Announcement`.`market_id` = `Market`.`id`) LEFT JOIN `sectors` AS `Sector` ON (`Announcement`.`sector_id` = `Sector`.`id`) LEFT JOIN `symbols` AS `Symbol` ON (`Announcement`.`symbol_id` = `Symbol`.`id`) WHERE 1 = 1 1120
6SELECT `Announcement`.`id`, `Announcement`.`title`, `Announcement`.`content`, `Announcement`.`market_id`, `Announcement`.`sector_id`, `Announcement`.`symbol_id`, `Announcement`.`created`, `Announcement`.`updated`, `Market`.`id`, `Market`.`name`, `Sector`.`id`, `Sector`.`name`, `Sector`.`market_id`, `Symbol`.`id`, `Symbol`.`name`, `Symbol`.`sector_id`, `Symbol`.`market_id` FROM `announcements` AS `Announcement` LEFT JOIN `markets` AS `Market` ON (`Announcement`.`market_id` = `Market`.`id`) LEFT JOIN `sectors` AS `Sector` ON (`Announcement`.`sector_id` = `Sector`.`id`) LEFT JOIN `symbols` AS `Symbol` ON (`Announcement`.`symbol_id` = `Symbol`.`id`) WHERE 1 = 1 LIMIT 20220