Profile cover photo
Profile photo
Dinesh Kumar Krishna
75 followers
75 followers
About
Dinesh Kumar's posts

Post has attachment

Post has attachment

Post has attachment

Post has attachment

Hi,

I need to access all wordpress menus and categories with their links using sql query. I am able to get menu name, ter_id,order but how to get their links and categories. I am posting query . Please hep me out.

"SELECT p.ID, p.post_title, p.post_name, p.menu_order, n.post_name as n_name, n.post_title as n_title, m.meta_value, pp.meta_value as menu_parent,pt.meta_value as type
FROM wp_term_relationships as txr 
INNER JOIN wp_posts as p ON txr.object_id = p.ID 
LEFT JOIN wp_postmeta as m ON p.ID = m.post_id 
LEFT JOIN wp_postmeta as pl ON p.ID = pl.post_id AND pl.meta_key = '_menu_item_object_id' 
LEFT JOIN wp_postmeta as pp ON p.ID = pp.post_id AND pp.meta_key = '_menu_item_menu_item_parent'
LEFT JOIN wp_postmeta as pt ON p.ID = pt.post_id AND pt.meta_key = '_menu_item_object'
LEFT JOIN wp_posts as n ON pl.meta_value = n.ID 
WHERE p.post_status='publish' 
    AND p.post_type = 'nav_menu_item' AND m.meta_key = '_menu_item_url' 
ORDER BY p.menu_order"

Post has attachment
Download PDF

Post has attachment

Post has attachment
Pope Francis stresses 'right to environment' in UN speech
Pope Francis has urged a large gathering of world leaders at the United Nations in New York to respect humanity's "right to the environment". He also called on financial agencies not to subject countries to "oppressive lending systems" that worsen poverty. ...

Post has attachment
Run multiple skype account on Ubuntu same time.

Post has attachment
Canada ranks #2 for most LEED buildings
Though LEED is not the world’s only green building rating system, it is the most widely used and recognized. Thus it is no small thing that, for the second year in a row, Canada is #2 for LEED building in the World. Most Certified Projects Canada has the hi...
Wait while more posts are being loaded