Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql="SELECT ID,p.post_title, pm2.meta_value image,p.post_date tanggal,slug
- FROM
- `nirwana_terms` t, nirwana_term_relationships tr,nirwana_posts p,nirwana_postmeta pm2,
- nirwana_postmeta pm1,nirwana_term_taxonomy tt
- WHERE
- t.slug='kerjaan-front'
- and tr.term_taxonomy_id=tt.term_taxonomy_id
- and p.ID=object_id
- and tt.term_id=t.term_id
- and pm1.post_id=p.ID
- and pm1.meta_key='_thumbnail_id'
- and pm2.post_id=pm1.meta_value
- and pm2.meta_key='_wp_attached_file'
- order by p.post_date asc";
- /*
- Prosesnya adalah menarik yang memiliki slug "kerjaan-front"
- kenapa ngak ID saja? ternyata ini agar menghemat kalau tiba-tiba ada kerjaan lain dengan prefix berbeda.. apalagi ada penamaan prefix/category yang mirip
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement