Support » Plugins » special query (gengo wordpress) with inner join

  • Hello, I would like to make a special query in WordPress.

    I would like my function gengoGetAPost to find (if exists) the translated post of a given post_id.

    Posts are in the “$wpdb->posts” table.
    Posts with their post_id, language_id and translation_group are in “$gengo->post2lang_table”.

    If I have 2 posts :

        17        1               5
        23        2               5

    I would like that gengoGetAPost(17,2) returns me the row of the post #23 in the $wpdb->posts table.

    Could you help me ?
    Here’s my first draft (not working), but I don’t know what to do now…

    function gengoGetAPost($post,$lang) {
    	global $gengo, $wpdb;
    	$language_ids = 2;
    	$query = "SELECT p.* FROM $wpdb->posts AS p INNER JOIN $gengo->post2lang_table AS p2l ON p.ID = p2l.post_id WHERE p2l.translation_group=$lang AND p2l.post_id='".$post."' LIMIT 1";
    	echo $query;
    	return ($result = $wpdb->get_row($query)) ? $result : NULL;
Viewing 1 replies (of 1 total)
  • I have this

    function gengoGetAPost($post) {
    	global $gengo, $wpdb;
    	$language_ids = implode(',', $gengo->language_preference_id);
    	$query = "SELECT p . * FROM $wpdb->posts AS p INNER JOIN $gengo->post2lang_table AS p2l ON p.ID = p2l.post_id WHERE p2l.translation_group = (SELECT translation_group FROM $gengo->post2lang_table WHERE post_id = '".$post."' ) AND p2l.language_id IN ($language_ids) LIMIT 1";
    	$result = $wpdb->get_row($query)
    	return ($result = $wpdb->get_row($query)) ? $result : NULL;

    in phpmyadmin, it works, giving me the good (translated post). But once I call the function in wordpress, it’s not showing the good one… ?

Viewing 1 replies (of 1 total)
  • The topic ‘special query (gengo wordpress) with inner join’ is closed to new replies.