Array
(
    [count] => SELECT COUNT(*) count
	FROM wp_hg_image i
	LEFT JOIN wp_hg_window ON i.win_id = wp_hg_window.id
	LEFT JOIN wp_hg_window_top ON i.win_top_id = wp_hg_window_top.id
	LEFT JOIN wp_hg_glass ON i.glass_id = wp_hg_glass.id
	LEFT JOIN wp_hg_door_finish ON i.finish_id = wp_hg_door_finish.id
	LEFT JOIN wp_hg_build_style ON i.style_id = wp_hg_build_style.id
	LEFT JOIN wp_hg_door_size ON i.size_id = wp_hg_door_size.id
	LEFT JOIN wp_hg_deco_hardware ON i.deco_id = wp_hg_deco_hardware.id
	LEFT JOIN wp_hg_model ON i.model_id = wp_hg_model.id
	LEFT JOIN wp_hg_collection ON i.col_id = wp_hg_collection.id
	LEFT JOIN wp_hg_material ON i.mat_id = wp_hg_material.id
	LEFT JOIN wp_hg_type ON i.type_id = wp_hg_type.id
	WHERE 1=1
	 ORDER BY i.rating DESC 
    [results] => 
	SELECT i.id, i.filename, i.tags, i.credit, i.rating,
	wp_hg_type.id type_id, wp_hg_type.name type_name,
	wp_hg_material.id mat_id, wp_hg_material.name mat_name,
	wp_hg_collection.id col_id, wp_hg_collection.name col_name,
	wp_hg_model.id mod_id, wp_hg_model.name mod_name,
	wp_hg_window.id win_id, wp_hg_window.name win_name,
	wp_hg_window_top.id win_top_id, wp_hg_window_top.name win_top_name,
	wp_hg_glass.id glass_id, wp_hg_glass.name glass_name,
	wp_hg_door_finish.id finish_id, wp_hg_door_finish.name finish_name,
	wp_hg_build_style.id style_id, wp_hg_build_style.name style_name,
	wp_hg_door_size.id size_id, wp_hg_door_size.name size_name,
	wp_hg_deco_hardware.id deco_id, wp_hg_deco_hardware.name deco_name
	
	FROM wp_hg_image i
	LEFT JOIN wp_hg_window ON i.win_id = wp_hg_window.id
	LEFT JOIN wp_hg_window_top ON i.win_top_id = wp_hg_window_top.id
	LEFT JOIN wp_hg_glass ON i.glass_id = wp_hg_glass.id
	LEFT JOIN wp_hg_door_finish ON i.finish_id = wp_hg_door_finish.id
	LEFT JOIN wp_hg_build_style ON i.style_id = wp_hg_build_style.id
	LEFT JOIN wp_hg_door_size ON i.size_id = wp_hg_door_size.id
	LEFT JOIN wp_hg_deco_hardware ON i.deco_id = wp_hg_deco_hardware.id
	LEFT JOIN wp_hg_model ON i.model_id = wp_hg_model.id
	LEFT JOIN wp_hg_collection ON i.col_id = wp_hg_collection.id
	LEFT JOIN wp_hg_material ON i.mat_id = wp_hg_material.id
	LEFT JOIN wp_hg_type ON i.type_id = wp_hg_type.id
	WHERE 1=1
	 ORDER BY i.rating DESC LIMIT 0, 18
)
    
    	Array
(
    [search_start] => 0
    [search_count] => 18
    [search_material] => 
    [search_type] => 
    [search_collection] => 
    [search_term] => 
    [search_window] => 
    [search_window_top] => 
    [search_glass] => 
    [search_door_finish] => 
    [search_building_style] => 
    [search_door_size] => 
    [search_deco_hardware] => 
    [search_tags] => 
    [search_advanced] => 
)
    

Advanced Search

Window
Door Finish
Deco Hardware
Window Top
Building Style
Tags
Glass
Door Size

Clear Search