Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #pastikan membuat category front dahulu
- #buat post yang memiliki kategory front (tolong di ingat 1 post 1 category jangan sampai 2)
- #nirwana adalah contoh TABLE saja
- 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.name='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
- #untuk menarik gambar2 thumbs dari category front
- #gambarnya .. berada di wp-content\uploads\
- #nama bisa langsung namanya atau menambahkan -150x150?!?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement