Advanced Hedge Fund Directory Search

Close this window

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

Welcome to Hedge Fund Directories

Gain access to the largest global directory dedicated to the Hedge Fund industry; with over 4800 management companies encompassing upwards of 32,000 unique hedge fund and fund of funds contacts

I cannot overstate the value of the HFD Europe and Americas directories. They are wonderfully simple, yet a very powerful approach to presenting oneself in print, email, and more importantly as a business. This solution h....
- Krishna Prasad Marketing Director, Butterfield Fund Services
One of the best directories I've found for this industry!! They provide a direct phone number and email for some of the most well know names in the industry... the support staff are helpful, intuitive and really are acces....
- Paul Stuart Equity Sales, Lehman Brothers

	Hedge Fund Directories	Lipper Tass HedgeWorld	Hedge Co.	Hedge Fund.Net	Barclay Hedge
# of Hedge Funds	4829	3400	3200	2943	2,226
# of Contacts	32,316	16,000	6,500	14,412	19,000
Update Frequency	Daily	Weekly	Weekly	Daily	Monthly
Excel Download
Contact Email
User Controlled
Yearly Purge
Designed For Marketing

All figures estimated as of June '09 | ** Limited Time Offer

59 queries took 149 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `hfd_fund_types`	9	9	17
2	DESCRIBE `hfd_funds`	31	31	8
3	DESCRIBE `hfd_contacts`	23	23	7
4	DESCRIBE `hfd_inaccuracies`	5	5	7
5	DESCRIBE `hfd_user_fund_types`	7	7	7
6	DESCRIBE `hfd_users`	19	19	7
7	DESCRIBE `hfd_discounts`	6	6	6
8	DESCRIBE `hfd_products`	5	5	6
9	DESCRIBE `hfd_testimonials`	8	8	8
10	DESCRIBE `hfd_white_papers`	3	3	8
11	DESCRIBE `hfd_features_competitors`	5	5	9
12	DESCRIBE `hfd_features`	5	5	7
13	DESCRIBE `hfd_competitors`	5	5	7
14	DESCRIBE `hfd_assets`	3	3	8
15	DESCRIBE `hfd_comp_charts`	3	3	8
16	DESCRIBE `hfd_strategies`	2	2	8
17	DESCRIBE `hfd_my_contacts`	5	5	8
18	DESCRIBE `hfd_redemptions`	11	11	7
19	DESCRIBE `hfd_countries`	4	4	6
20	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
21	SELECT `Fund`.`id` FROM `hfd_funds` AS `Fund` WHERE `Fund`.`status` = 'P' AND `Fund`.`source` = 'U'	0	0	0
22	SELECT `Redemption`.`id` FROM `hfd_redemptions` AS `Redemption` WHERE `Redemption`.`status` = 'P'	1	1	0
23	SELECT `FundType`.`id`, `FundType`.`directory`, `FundType`.`price`, `FundType`.`label`, `FundType`.`price_gbp`, `FundType`.`price_eur`, `FundType`.`loc_img`, `FundType`.`is_all_access`, `FundType`.`show_buynow` FROM `hfd_fund_types` AS `FundType` WHERE 1 = 1	7	7	0
24	SELECT `Discount`.`id`, `Discount`.`code`, `Discount`.`fund_type_id`, `Discount`.`desc`, `Discount`.`amount`, `Discount`.`isActive` FROM `hfd_discounts` AS `Discount` WHERE `Discount`.`fund_type_id` IN (1, 2, 3, 4, 5, 6, 7)	11	11	0
25	SELECT `Product`.`id`, `Product`.`fund_type_id`, `Product`.`feature`, `Product`.`order`, `Product`.`status` FROM `hfd_products` AS `Product` WHERE `Product`.`fund_type_id` IN (1, 2, 3, 4, 5, 6, 7)	26	26	0
26	SELECT `CompChart`.`id`, `CompChart`.`name`, `CompChart`.`active` FROM `hfd_comp_charts` AS `CompChart` WHERE 1 = 1	1	1	0
27	SELECT `Testimonial`.`id`, `Testimonial`.`author`, `Testimonial`.`designation`, `Testimonial`.`desc`, `Testimonial`.`created`, `Testimonial`.`modified`, `Testimonial`.`isActive`, `Testimonial`.`isFeatured` FROM `hfd_testimonials` AS `Testimonial` WHERE isFeatured = 'Y' LIMIT 2	2	2	0
28	SELECT `FeaturesCompetitor`.`id`, `FeaturesCompetitor`.`feature_id`, `FeaturesCompetitor`.`competitor_id`, `FeaturesCompetitor`.`fc_type`, `FeaturesCompetitor`.`feature_value`, `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive`, `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_features_competitors` AS `FeaturesCompetitor` LEFT JOIN `hfd_features` AS `Feature` ON (`FeaturesCompetitor`.`feature_id` = `Feature`.`id`) LEFT JOIN `hfd_competitors` AS `Competitor` ON (`FeaturesCompetitor`.`competitor_id` = `Competitor`.`id`) WHERE `fc_type` = 1 ORDER BY `feature_order` ASC, `comp_order` ASC	40	40	0
29	SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 1	1	1	0
30	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 1 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1	5	5	0
31	SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 3	1	1	0
32	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 3 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1	5	5	0
33	SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 5	1	1	0
34	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 5 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1	5	5	0
35	SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 7	1	1	0
36	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 7 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1	5	5	0
37	SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 6	1	1	0
38	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 6 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1	5	5	0
39	SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 2	1	1	0
40	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 2 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1	5	5	0
41	SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 4	1	1	0
42	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 4 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1	5	5	0
43	SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 22	1	1	0
44	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 22 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1	5	5	0
45	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` WHERE `Competitor`.`id` = 1	1	1	0
46	SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`competitor_id` = 1 AND `hfd_features_competitors`.`feature_id` = `Feature`.`id`) WHERE 1 = 1	8	8	0
47	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` WHERE `Competitor`.`id` = 5	1	1	0
48	SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`competitor_id` = 5 AND `hfd_features_competitors`.`feature_id` = `Feature`.`id`) WHERE 1 = 1	8	8	0
49	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` WHERE `Competitor`.`id` = 3	1	1	0
50	SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`competitor_id` = 3 AND `hfd_features_competitors`.`feature_id` = `Feature`.`id`) WHERE 1 = 1	8	8	0
51	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` WHERE `Competitor`.`id` = 4	1	1	0
52	SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`competitor_id` = 4 AND `hfd_features_competitors`.`feature_id` = `Feature`.`id`) WHERE 1 = 1	8	8	0
53	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` WHERE `Competitor`.`id` = 2	1	1	0
54	SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`competitor_id` = 2 AND `hfd_features_competitors`.`feature_id` = `Feature`.`id`) WHERE 1 = 1	8	8	0
55	SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` WHERE `Competitor`.`comp_type` = 1 ORDER BY `id` ASC	5	5	0
56	SELECT `WhitePaper`.`id`, `WhitePaper`.`upload_file`, `WhitePaper`.`status` FROM `hfd_white_papers` AS `WhitePaper` WHERE `status` = 'Y' AND `id` = 1	1	1	0
57	SELECT `Asset`.`id`, `Asset`.`ind`, `Asset`.`asset` FROM `hfd_assets` AS `Asset` WHERE 1 = 1	10	10	0
58	SELECT `Strategy`.`id`, `Strategy`.`strategy` FROM `hfd_strategies` AS `Strategy` WHERE 1 = 1 ORDER BY `strategy` ASC	34	34	0
59	SELECT `Country`.`country_id`, `Country`.`country_name`, `Country`.`country_code`, `Country`.`country_isActive` FROM `hfd_countries` AS `Country` WHERE `country_isActive` = 'Y' ORDER BY `country_name` ASC	237	237	0

59 queries took 149 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `hfd_fund_types`

DESCRIBE `hfd_funds`

DESCRIBE `hfd_contacts`

DESCRIBE `hfd_inaccuracies`

DESCRIBE `hfd_user_fund_types`

DESCRIBE `hfd_users`

DESCRIBE `hfd_discounts`

DESCRIBE `hfd_products`

DESCRIBE `hfd_testimonials`

DESCRIBE `hfd_white_papers`

DESCRIBE `hfd_features_competitors`

DESCRIBE `hfd_features`

DESCRIBE `hfd_competitors`

DESCRIBE `hfd_assets`

DESCRIBE `hfd_comp_charts`

DESCRIBE `hfd_strategies`

DESCRIBE `hfd_my_contacts`

DESCRIBE `hfd_redemptions`

DESCRIBE `hfd_countries`

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 `Redemption`.`id` FROM `hfd_redemptions` AS `Redemption` WHERE `Redemption`.`status` = 'P'

SELECT `FundType`.`id`, `FundType`.`directory`, `FundType`.`price`, `FundType`.`label`, `FundType`.`price_gbp`, `FundType`.`price_eur`, `FundType`.`loc_img`, `FundType`.`is_all_access`, `FundType`.`show_buynow` FROM `hfd_fund_types` AS `FundType` WHERE 1 = 1

SELECT `Discount`.`id`, `Discount`.`code`, `Discount`.`fund_type_id`, `Discount`.`desc`, `Discount`.`amount`, `Discount`.`isActive` FROM `hfd_discounts` AS `Discount` WHERE `Discount`.`fund_type_id` IN (1, 2, 3, 4, 5, 6, 7)

SELECT `Product`.`id`, `Product`.`fund_type_id`, `Product`.`feature`, `Product`.`order`, `Product`.`status` FROM `hfd_products` AS `Product` WHERE `Product`.`fund_type_id` IN (1, 2, 3, 4, 5, 6, 7)

SELECT `CompChart`.`id`, `CompChart`.`name`, `CompChart`.`active` FROM `hfd_comp_charts` AS `CompChart` WHERE 1 = 1

SELECT `Testimonial`.`id`, `Testimonial`.`author`, `Testimonial`.`designation`, `Testimonial`.`desc`, `Testimonial`.`created`, `Testimonial`.`modified`, `Testimonial`.`isActive`, `Testimonial`.`isFeatured` FROM `hfd_testimonials` AS `Testimonial` WHERE isFeatured = 'Y' LIMIT 2

SELECT `FeaturesCompetitor`.`id`, `FeaturesCompetitor`.`feature_id`, `FeaturesCompetitor`.`competitor_id`, `FeaturesCompetitor`.`fc_type`, `FeaturesCompetitor`.`feature_value`, `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive`, `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_features_competitors` AS `FeaturesCompetitor` LEFT JOIN `hfd_features` AS `Feature` ON (`FeaturesCompetitor`.`feature_id` = `Feature`.`id`) LEFT JOIN `hfd_competitors` AS `Competitor` ON (`FeaturesCompetitor`.`competitor_id` = `Competitor`.`id`) WHERE `fc_type` = 1 ORDER BY `feature_order` ASC, `comp_order` ASC

SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 1

SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 1 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1

SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 3

SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 3 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1

SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 5

SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 5 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1

SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 7

SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 7 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1

SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 6

SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 6 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1

SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 2

SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 2 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1

SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 4

SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 4 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1

SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` WHERE `Feature`.`id` = 22

SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`feature_id` = 22 AND `hfd_features_competitors`.`competitor_id` = `Competitor`.`id`) WHERE 1 = 1

SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` WHERE `Competitor`.`id` = 1

SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`competitor_id` = 1 AND `hfd_features_competitors`.`feature_id` = `Feature`.`id`) WHERE 1 = 1

SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` WHERE `Competitor`.`id` = 5

SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`competitor_id` = 5 AND `hfd_features_competitors`.`feature_id` = `Feature`.`id`) WHERE 1 = 1

SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` WHERE `Competitor`.`id` = 3

SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`competitor_id` = 3 AND `hfd_features_competitors`.`feature_id` = `Feature`.`id`) WHERE 1 = 1

SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` WHERE `Competitor`.`id` = 4

SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`competitor_id` = 4 AND `hfd_features_competitors`.`feature_id` = `Feature`.`id`) WHERE 1 = 1

SELECT `Competitor`.`id`, `Competitor`.`competitor`, `Competitor`.`comp_type`, `Competitor`.`comp_order`, `Competitor`.`isActive` FROM `hfd_competitors` AS `Competitor` WHERE `Competitor`.`id` = 2

SELECT `Feature`.`id`, `Feature`.`feature`, `Feature`.`type`, `Feature`.`feature_order`, `Feature`.`isActive` FROM `hfd_features` AS `Feature` JOIN `hfd_features_competitors` ON (`hfd_features_competitors`.`competitor_id` = 2 AND `hfd_features_competitors`.`feature_id` = `Feature`.`id`) WHERE 1 = 1

SELECT `WhitePaper`.`id`, `WhitePaper`.`upload_file`, `WhitePaper`.`status` FROM `hfd_white_papers` AS `WhitePaper` WHERE `status` = 'Y' AND `id` = 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

SELECT `Country`.`country_id`, `Country`.`country_name`, `Country`.`country_code`, `Country`.`country_isActive` FROM `hfd_countries` AS `Country` WHERE `country_isActive` = 'Y' ORDER BY `country_name` ASC

237