Reply With Quote
You must be an AppThemes customer and logged in to view this response. cyjambo (August 2nd, 2013)
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) LEFT JOIN (SELECT wp_postmeta.post_id AS ID, CAST(REPLACE(wp_postmeta.meta_value, ',', '') AS SIGNED) AS price FROM wp_postmeta WHERE wp_postmeta.meta_key ="cp_price") P ON (P.ID = wp_posts.ID) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (21) ) AND wp_posts.post_type = 'ad_listing' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') AND (wp_postmeta.meta_key = 'cp_price' ) GROUP BY wp_posts.ID LIMIT 0, 10;
# Time: 120310 22:49:33 # User@Host: XXXXXXXX[XXXXXXXX] @ localhost [] # Query_time: 56.182569 Lock_time: 0.000129 Rows_sent: 10 Rows_examined: 763051458 SET timestamp=1331416173; SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts .... GROUP BY wp_posts.ID LIMIT 0, 10;
cyjambo (August 2nd, 2013)
There are currently 1 users browsing this thread. (0 members and 1 guests)
