//$rows = $wpdb->get_results("SELECT a . * , b.meta_key, b.meta_value FROM bl_posts a RIGHT OUTER JOIN bl_postmeta b ON a.id = b.post_id WHERE a.post_type = 'jobman_job' ORDER BY a.post_date DESC");
$rows = $wpdb->get_results("SELECT a . * , (SELECT meta_value FROM bl_postmeta WHERE meta_key = 'data5' AND bl_postmeta.post_id = a.id) 'description', (SELECT STR_TO_DATE( meta_value, '%c-%d-%Y' ) FROM bl_postmeta WHERE meta_key = 'data2' AND bl_postmeta.post_id = a.id ) 'poston', ( SELECT meta_value FROM bl_postmeta WHERE meta_key = 'data4' AND bl_postmeta.post_id = a.id ) 'location' FROM bl_posts a WHERE a.post_type = 'jobman_job' ORDER BY a.post_date DESC ");
$ct = 0;
Choose a job you love and you'll never have to work a day in your life.
Passion will move men beyond themselves, beyond their shortcomings, beyond their failures.
The belief that you can have a meaningful career is the first step to finding one.
Success is liking yourself, liking what you do, and liking how you do it.
Set me a task in which I can put something of my very self, and it is a task no longer; it is joy; it is art.
You want the best. You need the best. Ivesia is here to help.