SELECT s.style_id, s.parent_id AS style_parent_id, s.folder AS style_folder_name, t.folder AS theme_folder_name, t.parent_id AS theme_parent_id, t.total_column, s.l_width, s.c_width, s.r_width
FROM phpfox_theme_style AS s
     JOIN phpfox_theme AS t
            ON(t.theme_id = s.theme_id)

WHERE s.is_default = 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	ref	is_default	is_default	1	const	1
1	SIMPLE	t	eq_ref	PRIMARY,theme_id	PRIMARY	2	ckjewels_activehood.s.theme_id	1

SELECT folder AS parent_style_folder
FROM phpfox_theme_style
WHERE style_id = 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_style	ref	style_id	style_id	2	const	1

SELECT cf.*, cmv.option_id as customValue
FROM phpfox_custom_field AS cf
     JOIN phpfox_module AS m
            ON(m.module_id = cf.module_id AND m.is_active = 1)
     LEFT JOIN phpfox_user_custom_multiple_value AS cmv
            ON(cmv.field_id = cf.field_id)

WHERE cf.type_id IN ('user_main','user_panel','profile_panel') AND cf.is_active = 1 AND cf.user_group_id = 0 AND cf.on_signup = 1
ORDER BY cf.ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	cmv	system		MISSING KEY				const row not found
1	SIMPLE	cf	ALL		MISSING KEY			7	Using where; Using filesort
1	SIMPLE	m	ref	is_active,module_id,module_is_active	module_is_active	78	ckjewels_activehood.cf.module_id,const	6	Using index

SELECT sp.*
FROM phpfox_subscribe_package AS sp
WHERE sp.is_active = 1 AND sp.is_registration = 1
ORDER BY sp.ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE				MISSING KEY				Impossible WHERE noticed after reading const tables