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