Reply To: Trying to stop JS to add in-line CSS for the .orig class

Home Forums Product Support Forums Ajax Search Pro for WordPress Support Trying to stop JS to add in-line CSS for the .orig class Reply To: Trying to stop JS to add in-line CSS for the .orig class

#4449

Pavelescu Razvan
Participant

Hello again, – I was not able to open another ticket

I want to modify the results query in order to receive also custom fields from custom post types.

I identified the search query: http://screencast.com/t/2pYWz5Y0Z24

I want to modify the query to also receive a “clx_event_city” postmeta information for the resulsts. How can I achieve that?

So this is the DB table: http://screencast.com/t/Neisgn8cGz

I know a bit of MySQL syntax, but I do not know how to get this information as the clx_event_city field is not in the default wp_post table.
As you might already know, the custom meta posts are saved in the wp_postmeta, and I would have make a join to get the ids for the resulsts.

How can I achieve this in terms of MySql query? Could you give me an example of a join?

I know you are not here to cover our customization but I am having a hard time understanding your query syntax as it's quite large and intimidating: http://screencast.com/t/0FeX9axHn

thanks a lot,
Razvan