user warning: Not unique table/alias: 'term_node_69'
query: CREATE TEMPORARY TABLE temp_faceted_search_results_2 (nid int unsigned NOT NULL, PRIMARY KEY (nid)) Engine=HEAP SELECT DISTINCT n.nid AS nid, 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp)) - 1337760136) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + MAX(c.comment_count) * 1)) AS score FROM node AS n INNER JOIN taxonomy_facets_term_node AS term_node_69 ON n.nid = term_node_69.nid INNER JOIN taxonomy_facets_term_node AS term_node_69 ON n.nid = term_node_69.nid LEFT JOIN node_comment_statistics AS c ON n.nid = c.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( ((n.status = 1) AND (n.type IN ('product')) AND (term_node_69.tid = 69) AND (term_node_69.tid = 69)) AND n.nid IN (SELECT DISTINCT node.nid AS nid
FROM node node
LEFT JOIN ec_product ec_product ON node.vid = ec_product.vid
LEFT JOIN content_type_product node_data_field_usd ON node.vid = node_data_field_usd.vid
LEFT JOIN content_field_ten_san_pham node_data_field_ten_san_pham ON node.vid = node_data_field_ten_san_pham.vid
LEFT JOIN content_field_gia_sp node_data_field_gia_sp ON node.vid = node_data_field_gia_sp.vid
LEFT JOIN content_field_cong_suat node_data_field_cong_suat ON node.vid = node_data_field_cong_suat.vid
LEFT JOIN content_field_sort node_data_field_sort ON node.vid = node_data_field_sort.vid
LEFT JOIN content_type_product node_data_field_sp_duoc_sap_xep ON node.vid = node_data_field_sp_duoc_sap_xep.vid
INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( (node.status = 1) AND (node.type in ('product'))
)) )GROUP BY n.nid ASC ORDER BY score DESC in /home/hopphat/domains/hopphat.com/public_html/sites/all/modules/faceted_search/faceted_search.inc on line 1174.
user warning: Table 'hopphat_db.temp_faceted_search_results_2' doesn't exist
query: SELECT COUNT(*) FROM temp_faceted_search_results_2 in /home/hopphat/domains/hopphat.com/public_html/sites/all/modules/faceted_search/faceted_search.inc on line 1175.