Online Demo

You don't have the latest Flash player, click here to download it.

The above online demonstration shows you how the Quick Search, Advanced Search and Result works in Hedge Fund Directories.net.

22 queries took 80 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `hfd_contents`	6	6	6
2	DESCRIBE `hfd_white_papers`	3	3	6
3	DESCRIBE `hfd_assets`	3	3	5
4	DESCRIBE `hfd_strategies`	2	2	5
5	DESCRIBE `hfd_user_fund_types`	7	7	6
6	DESCRIBE `hfd_users`	19	19	6
7	DESCRIBE `hfd_fund_types`	8	8	6
8	DESCRIBE `hfd_funds`	28	28	6
9	DESCRIBE `hfd_contacts`	17	17	6
10	DESCRIBE `hfd_inaccuracies`	5	5	5
11	DESCRIBE `hfd_discounts`	6	6	5
12	DESCRIBE `hfd_products`	5	5	6
13	DESCRIBE `hfd_my_contacts`	5	5	6
14	DESCRIBE `hfd_redemptions`	10	10	6
15	SELECT `Contact`.`id` FROM `hfd_contacts` AS `Contact` LEFT JOIN `hfd_funds` AS `Fund` ON (`Contact`.`fund_id` = `Fund`.`id`) WHERE `Contact`.`status` = 'P' AND `Contact`.`source` = 'U'	0	0	0
16	SELECT `Fund`.`id` FROM `hfd_funds` AS `Fund` WHERE `Fund`.`status` = 'P' AND `Fund`.`source` = 'U'	2	2	0
17	SELECT `Contact`.`id`, `Contact`.`fund_id`, `Contact`.`fund_name`, `Contact`.`contact_salutation`, `Contact`.`contact_surname`, `Contact`.`contact_forename`, `Contact`.`contact_job_title`, `Contact`.`contact_address`, `Contact`.`contact_country`, `Contact`.`contact_phone`, `Contact`.`contact_fax`, `Contact`.`contact_email`, `Contact`.`contact_region`, `Contact`.`source`, `Contact`.`status`, `Contact`.`created`, `Contact`.`modified` FROM `hfd_contacts` AS `Contact` WHERE `Contact`.`fund_id` IN (1222339, 1222341)	0	0	0
18	SELECT `Inaccuracy`.`id`, `Inaccuracy`.`user_id`, `Inaccuracy`.`fund_id`, `Inaccuracy`.`desc`, `Inaccuracy`.`created` FROM `hfd_inaccuracies` AS `Inaccuracy` WHERE `Inaccuracy`.`fund_id` IN (1222339, 1222341)	0	0	0
19	SELECT `Redemption`.`id` FROM `hfd_redemptions` AS `Redemption` WHERE `Redemption`.`status` = 'P'	0	0	0
20	SELECT `Content`.`id`, `Content`.`content_title`, `Content`.`content_cat`, `Content`.`content_desc`, `Content`.`content_isActive`, `Content`.`modified` FROM `hfd_contents` AS `Content` WHERE `Content`.`content_cat` = 'demo' LIMIT 1	1	1	0
21	SELECT `Asset`.`id`, `Asset`.`ind`, `Asset`.`asset` FROM `hfd_assets` AS `Asset` WHERE 1 = 1	10	10	0
22	SELECT `Strategy`.`id`, `Strategy`.`strategy` FROM `hfd_strategies` AS `Strategy` WHERE 1 = 1 ORDER BY `strategy` ASC	34	34	0

22 queries took 80 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `hfd_contents`

DESCRIBE `hfd_white_papers`

DESCRIBE `hfd_assets`

DESCRIBE `hfd_strategies`

DESCRIBE `hfd_user_fund_types`

DESCRIBE `hfd_users`

DESCRIBE `hfd_fund_types`

DESCRIBE `hfd_funds`

DESCRIBE `hfd_contacts`

DESCRIBE `hfd_inaccuracies`

DESCRIBE `hfd_discounts`

DESCRIBE `hfd_products`

DESCRIBE `hfd_my_contacts`

DESCRIBE `hfd_redemptions`

SELECT `Contact`.`id` FROM `hfd_contacts` AS `Contact` LEFT JOIN `hfd_funds` AS `Fund` ON (`Contact`.`fund_id` = `Fund`.`id`) WHERE `Contact`.`status` = 'P' AND `Contact`.`source` = 'U'

SELECT `Fund`.`id` FROM `hfd_funds` AS `Fund` WHERE `Fund`.`status` = 'P' AND `Fund`.`source` = 'U'

SELECT `Contact`.`id`, `Contact`.`fund_id`, `Contact`.`fund_name`, `Contact`.`contact_salutation`, `Contact`.`contact_surname`, `Contact`.`contact_forename`, `Contact`.`contact_job_title`, `Contact`.`contact_address`, `Contact`.`contact_country`, `Contact`.`contact_phone`, `Contact`.`contact_fax`, `Contact`.`contact_email`, `Contact`.`contact_region`, `Contact`.`source`, `Contact`.`status`, `Contact`.`created`, `Contact`.`modified` FROM `hfd_contacts` AS `Contact` WHERE `Contact`.`fund_id` IN (1222339, 1222341)

SELECT `Inaccuracy`.`id`, `Inaccuracy`.`user_id`, `Inaccuracy`.`fund_id`, `Inaccuracy`.`desc`, `Inaccuracy`.`created` FROM `hfd_inaccuracies` AS `Inaccuracy` WHERE `Inaccuracy`.`fund_id` IN (1222339, 1222341)

SELECT `Redemption`.`id` FROM `hfd_redemptions` AS `Redemption` WHERE `Redemption`.`status` = 'P'

SELECT `Content`.`id`, `Content`.`content_title`, `Content`.`content_cat`, `Content`.`content_desc`, `Content`.`content_isActive`, `Content`.`modified` FROM `hfd_contents` AS `Content` WHERE `Content`.`content_cat` = 'demo' LIMIT 1

SELECT `Asset`.`id`, `Asset`.`ind`, `Asset`.`asset` FROM `hfd_assets` AS `Asset` WHERE 1 = 1

SELECT `Strategy`.`id`, `Strategy`.`strategy` FROM `hfd_strategies` AS `Strategy` WHERE 1 = 1 ORDER BY `strategy` ASC