fas.khan

were you able to find a solution for this ?

Having this same problem.

Were you manage to find a solution for it ?

Thanks a lot.

I was missing . I did some changes in the plugin and had a bug.

I did. It just doesn’t show anything ??

Hi vtxyzzy …

it shows me a query something like this
SELECT aqoposts.* FROM aqoposts JOIN aqoicl_translations t ON aqoposts.ID = t.element_id AND t.element_type IN ('post_post','post_page') JOIN aqoicl_languages l ON t.language_code=l.code AND l.active=1 WHERE 1=1 AND (aqoposts.ID = '20') AND aqoposts.post_type = 'page' AND t.language_code='en' ORDER BY aqoposts.post_date DESC

I was hoping it will show me the query of the posts with multiple custom fields sorting as I am using this in my code :-
$queryObject = get_posts('category_name=campaigns'.$querystring);

where $querystring contains list of variables selected by the user (e.g. meta_key=’ddd’&meta_value=’yyy’&meta_key=’dtt’&meta_value=’yyre’&meta_key=’xxd’&meta_value=’eee’) ….

I just want that it shows the code, it generates for “get_posts(…)”

Any Idea please?

Thanks a lot for your reply …

But after I put it in get_header(), I am still unable to see the query …
any other suggestion ?

One question please.

the expression print_r($wp_query->request); gives the query we make through WP_Query.

Is there any way I can see the query made by wordpress through get_posts or query_posts?

Many Thanks,

But Adiant, that SQL query is not that easy to make, and I don’t know how they are doing it.

Simply, for example, this is what I am doing.

$querystr = "SELECT DISTINCT (ID), wposts . * , wpostmeta . * 

FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta, $wpdb->postmeta wpostmeta2, $wpdb->postmeta wpostmeta3, $wpdb->postmeta wpostmeta4, $wpdb->postmeta wpostmeta5, $wpdb->postmeta wpostmeta6

WHERE wposts.ID = wpostmeta.post_id

AND wpostmeta3.meta_key =  'focusarea'

AND wpostmeta3.meta_value LIKE  '%".$topic."%'

AND wpostmeta4.meta_key =  'activity'

AND wpostmeta4.meta_value =  '".$activity."'

AND wpostmeta5.meta_key =  'status'

AND wpostmeta5.meta_value = '".$status."'

AND wpostmeta6.meta_key =  'audience'

AND wpostmeta6.meta_value LIKE '%".$audience."%'

AND wposts.post_status =  'publish'

AND wposts.post_type =  'post'

GROUP BY wposts.post_title";

But then I have to add the same table instances multiple times and the result is not efficient. It shows me multiple records, or some records which i dont expect to see …

Where am I going wrong?

Many Thanks.

So it means, there is no way, I can achieve this ??

lipsk,

were you able to fix your issue?
I am having the same issue on WP 3.01 and it definitely is an issue with the new release

wow! thanks vtxyzzy

I was just looking at the string and found a pattern of its appearence …

so i did this…

$adf= (explode('"',$post->options));

        		    $i=0;
        		    $len = strlen($adf);

        		    for ($i = 0; $i < count($adf); $i++)
                            {
                                       if ( $i %2 != 0)
        			       	echo $adf[$i]."<br />";
        			   }

It just gave me the values.

Many Thanks again.

hi anmari,

thank you very much for the reply. I am actually working on it and will post my workarounds for it here. ??

Many thanks again.

and then I found Faster Image Insert.

https://www.ads-software.com/extend/plugins/faster-image-insert/

It’s strange that I never figured that finding such a straightforward plugin would require so much search. Nonetheless, hopefully it helps someone.

Any advice please ?

Any assistance please?