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. how does $wpdb differ to WP_Query?
  67. WP_Query – filter or directly?
  68. How can I save an array from a random post sequence for later use?
  69. Does WordPress generate an automatic page for post formats?
  70. Why is WP-Query spelled like it is?
  71. Pagination not working Search posts
  72. Why I can’t get old posts instead of recent with WP_Query?
  73. WP_Query arguments to fetch custom post type posts which are in certain category?
  74. WP_Query loop within WP_Query loop
  75. How to fetch only media that was already attached to a post/page?
  76. WP_Query won’t retrieve raw HTML?
  77. Remove a specific category ID from related post
  78. Any number in meta key (wp query)
  79. Understanding the orderby in WP_Query?
  80. Multisite wp_query & switch_to_blog issue
  81. complex get_posts() query to select child pages
  82. Widget only in first post
  83. How can I change the term “Published” next to # of posts published on WordPress dashboard All Posts page?
  84. WP_query pagination on frontpage
  85. WP Query by 4 different taxonomies
  86. WordPress Query by Category using Post Slug
  87. WP Query for all events prior to current date
  88. Displaying posts from sub taxonomies only
  89. get term objects and post objects in query
  90. Issue generating custom filter for cpt admin columns
  91. How to take parameters from a function and make them editable as attributes in a shortcode
  92. Object of class WP_Query could not be converted to int inside shortcode
  93. display post multiple times based on array of dates
  94. Sorting is not working in WordPress WP_Query
  95. Add custom WP_Query after the first 3 posts
  96. Weird results using wp-query with ‘date_query’ for last week
  97. How to count post meta key values for all posts in database
  98. Why won’t my paged wp_query work? [duplicate]
  99. 1500+ duplicate queries via get_option function (query monitor)
  100. after refresh the id that shows correct in first time click, changes to 1