Mysql SELECT posts

I resolved creating SQL query:

SELECT posts.post_title, posts.post_content, trans.element_type,
trans.language_code
FROM wp_posts AS posts

INNER JOIN wp_icl_translations AS trans
ON posts.ID = trans.element_id

INNER JOIN wp_postmeta AS meta
ON posts.ID = meta.post_id

WHERE trans.element_type="post_product"
AND trans.language_code="de"

This is added only if you need something on post_meta:

...
INNER JOIN wp_postmeta AS meta
ON posts.ID = meta.post_id
...

It was my solutions to get all post by language trans.language_code="de", trans.language_code="es", trans.language_code="en" …

Related Posts:

  1. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  2. Cannot add or update a child row: a foreign key constraint fails
  3. How to make MySQL table primary key auto increment with some prefix
  4. sql query with multiple where statements
  5. Cannot delete or update a parent row: a foreign key constraint fails
  6. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  7. Syntax error due to using a reserved word as a table or column name in MySQL
  8. MySQL root password change
  9. Installation of MySQL for Visual Studio 1.2.8 failed
  10. How do I import an SQL file using the command line in MySQL?
  11. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  12. Select from multiple tables without a join?
  13. SQL Query Where Field DOES NOT Contain $x
  14. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  15. SQL – Update multiple records in one query
  16. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  17. Mysql command not found in OS X 10.7
  18. MySQL – UPDATE query based on SELECT Query
  19. grabbing first row in a mysql query only
  20. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  21. Order a MySQL table by two columns
  22. MySQL AS keyword
  23. Should I use the datetime or timestamp data type in MySQL?
  24. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  25. How do I change the data type for a column in MySQL?
  26. Unknown Column In Where Clause
  27. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  28. Cannot connect to Database server (mysql workbench)
  29. mysqld: Can’t change dir to data. Server doesn’t start
  30. How to solve “Error: MySQL shutdown unexpectedly”?
  31. How to create a foreign key in phpmyadmin
  32. Can you do a For Each Row loop using MySQL?
  33. Drop all databases in MySQL
  34. CAST to DECIMAL in MySQL
  35. How to properly create composite primary keys – MYSQL
  36. Failed to Connect to MySQL at localhost:3306 with user root
  37. MySQL – count total number of rows in php
  38. How to get the count of each distinct value in a column?
  39. Data is not constantly loading from custom wordpress table
  40. How do you properly prepare a %LIKE% SQL statement?
  41. How to run WordPress across 2 VMs for high availability
  42. Mysqldump add drop table?
  43. How to disable `SQL_CALC_FOUND_ROWS` [duplicate]
  44. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  45. #1115 – Unknown character set: ‘utf8mb4’
  46. WordPress Deadlock Error
  47. How to do a MySQL dump from production site without using a search and replace script for local development?
  48. How to bulk edit canonical url’s in SQL?
  49. Concurrent / simultaneous MySQL connections
  50. How to check for empty and not a failure
  51. Database: Custom table: sprintf value for DateTime column
  52. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  53. Keeping database within limits, please help!
  54. Best settings for MySQL to speed up site? [closed]
  55. WP_USE_EXT_MYSQL
  56. HTML Entities in Post Title
  57. Can’t find my wordpress DB in phpmyadmin
  58. Deprecated: mysql_connect():
  59. MySQL Rank & $wpdb
  60. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  61. WordPress post_status is future, manually added
  62. How are multiple WordPress WPDB queries handled?
  63. Regarding “Insert query error” in wordpress
  64. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  65. WordPress plugin overloading with tmp tables
  66. Site not responding error – taking long to load [closed]
  67. WordPress(wpdb class) and mysql stored procedures
  68. WordPress plugins for database queries
  69. WordPress doesn’t display accents after migration
  70. Replace a character in all post titles and slugs
  71. Understanding custom php that reads from WP MYSQL
  72. $wpdb->get_var multiple queries in one database check
  73. List users with the most posts in the last 30 days
  74. Way to extract wordpress data from folder backup
  75. WordPress $wpdb no result
  76. Data is not constatntly loading from custom wordpress table
  77. Mysql Server keeps crashing
  78. edit_user_created_user hook – using to update Groups
  79. How to search usermeta table
  80. How to add virtual column in wpdb get_result statement
  81. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  82. I want to share local developement and staging DB — Is this very smart or very stupid?
  83. Extract all users along with yoast metadata description
  84. WordPress asks to install, but is already installed?
  85. Mysql Error in querying form entries in Gravity Form plugin
  86. Deleting a table row through query
  87. An SQL query to find orphaned image attachments and their meta
  88. Weird characters displayed when importing WordPress MySQL db
  89. Simple SQL Query in wordpress
  90. Saving custom term value to the database in new table
  91. MySQL errors after a WordPress clone
  92. optimise SQL wordpress call
  93. Complicated MySQL Query
  94. WP_Query with LIKE returns strange query
  95. remove wordpress post links
  96. SQL get last entry of a specific gravity form
  97. mysqldump to a tar.gz
  98. Postgres equivalent to MySQL’s \G?
  99. How to check what port mysql is running on
  100. Where is my mysql log on OS X?