querying data via $wpdb and get_row

Try this.

$query = "SELECT * FROM wp_cf7dbplugin_submits a,wp_cf7dbplugin_submits b  WHERE a.field_name="Buyer" AND a.field_value = 1 AND a.submit_time = b.submit_time AND b.field_name = carbrand AND b.field_value="Mercedes"";

global $wpdb;
// return the number of rows found
$results = $wpdb->num_rows($query);
var_dump($results);

Related Posts:

  1. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  2. Should I use Transients with W3 Total Cache APC Caching? [closed]
  3. Add indexing to meta_value in wp_postmeta
  4. Get posts by menu ID
  5. Slow SQL_CALC_FOUND_ROWS Query
  6. What is an efficient way to query based on post_meta?
  7. WP_Query Performance Issues with meta_query
  8. Should close $wpdb via $wpdb->close()
  9. Get the post permalink within the loop but without additional DB query
  10. Filter WordPress posts by between parameter
  11. Retrieve featured image (thumbnail) url from multiple posts with one query
  12. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  13. What’s faster? One big query, or several smaller ones?
  14. How WordPress attaches its Featured Images with posts?
  15. Order by custom table and multiplication
  16. why update and delete query not worked in custom table?
  17. How to implement a new row_count method in WordPress?
  18. wp_Qwery works to slow
  19. Show all data in database table and make it into an interactive table
  20. No results found from a $wpdb->get_results() query when trying to join more than one meta key query
  21. database query with more than a couple meta hangs and doesn’t complete
  22. How to access custom WordPress database tables
  23. Is it possible to query from external database? [duplicate]
  24. WP User Query with Custom Fields and Search Results
  25. List of ways to access WordPress database?
  26. Specify strict ‘order by’ in WordPress query
  27. How to set up hierarchical relationships without using plugins / meta query
  28. how to get Nearby zipcode
  29. Does WordPress have something like Drupal’s DB API?
  30. Using Transients
  31. Slow Query On Search
  32. how to write wordpress query for multiple metakeys checking?
  33. Wpdb->query result show 1 but is not an integer
  34. Why having more than 10 clauses in WP_Query results in some outputs being dropped?
  35. Storing an array of objects related to each user
  36. Retrieve data from wordpress db via input and put those result in dropdown
  37. WP Query – filtering terms with regex
  38. WP_Query with page_ids in arguments without a result
  39. Function to retrieve IDs of posts, cache results, and improve wp_query
  40. Issue with data array format
  41. Why last row deleted when refresh page
  42. Query a database based on form input then output to another page [closed]
  43. wp query search multi terms
  44. How to get meta key list efficiently?
  45. How to get user avatar via WPDB
  46. How to extend WP_query to a specific table?
  47. Fix wp_term_relationships slow query in get_posts
  48. Translating WP query into to SQL query
  49. update_post_meta performance in a loop woocommerce
  50. update_post_meta performance in a loop woocommerce
  51. WP_Term_Query->get_terms() very slow query for WordPress filter
  52. Separate by Category Post Type
  53. I removed the “wp_rm_logs” table and am constantly getting this error
  54. Track write actions to the database
  55. Include post_status check within $wpdb query
  56. wpdb get_results() returns only 2 rows
  57. Website goes slow down after importing long database
  58. WP_Query always returning the last custom post
  59. option select form always deleting the sql query
  60. Optimising amount of calls to custom fields
  61. 294 Queries on Mainpage of WordPress
  62. how to add limit records in wordpress query
  63. Custom WP_query in Jnews theme returns thousands of posts
  64. WP_Query by meta key not returning any posts
  65. SQL query into to WP query
  66. When to use WP_query(), query_posts() and pre_get_posts
  67. WP query taxonomy input differs to output?
  68. WP_Query min and max values
  69. assign 2 $args to one wp_query
  70. Calling a custom excerpt function in a local loop
  71. How would I format a query that depends on post parent taxonomy
  72. Minimising Database Queries when using Advanced Custom Fields
  73. WP_Query Group by Author and Order each group DESC
  74. List only posts from specific category on category page
  75. Most popular post for last 7 days
  76. WP Pagination on Posts Search Results Page resulting from AJAX WP Query
  77. Query multiple meta values
  78. Why isn’t my multiple orderby working?
  79. WP_Query() order by post content lenght?
  80. reset to main loop doesnt work
  81. echo a specific meta_key queried through a custom post
  82. WP_Query returns posts_per_page + 1 every time
  83. Merge two search functions for custom post type
  84. problems with comments_number()
  85. Get a list of ACF Repeater-Fields as array
  86. query_vars empty when using custom url with custom rewrite rule
  87. Attempt to display site authors in a carousel – User Image not Outputting inside li tags
  88. Why my query is not “Main_query”?
  89. Facing problem with tax_query results
  90. How to add a “base” filter for all posts visible to visitors on the site?
  91. Woocommerce featured products query no longer working
  92. add action for wordpress query at a specific position
  93. Updating an intensive wp_query result once daily
  94. Custom WP_query and integrating into theme file
  95. new WP_query using custom fields
  96. Having Trouble Running Query From Shortcode Using Tribe’s Events Plugin
  97. Change ‘post_modify’ with a query
  98. An archive page without post format (just standard post)
  99. Get posts using multiple values from ACF checkbox as meta query wordpress
  100. Why ignore_sticky_posts argument is in sticky post query?