eon01

DELETE p FROM wp_posts p WHERE p.post_type = 'product';  

DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;  

DELETE tr FROM wp_term_relationships tr INNER JOIN wp_term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id) WHERE tt.taxonomy != 'link_category' AND tr.object_id NOT IN ( SELECT ID FROM wp_posts );

eon01

deb http://mirror.cse.iitk.ac.in/debian/ jessie main
deb-src http://mirror.cse.iitk.ac.in/debian/ jessie main

deb http://security.debian.org/ jessie/updates main contrib
deb-src http://security.debian.org/ jessie/updates main contrib

# wheezy-updates, previously known as 'volatile'
deb http://mirror.cse.iitk.ac.in/debian/ jessie-updates main contrib
deb-src http://mirror.cse.iitk.ac.in/debian/ jessie-updates main contrib

eon01

[ 
{"name": "Afghanistan", "code": "AF"}, 
{"name": "Åland Islands", "code": "AX"}, 
{"name": "Albania", "code": "AL"}, 
{"name": "Algeria", "code": "DZ"}, 
{"name": "American Samoa", "code": "AS"}, 
{"name": "AndorrA", "code": "AD"}, 
{"name": "Angola", "code": "AO"}, 
{"name": "Anguilla", "code": "AI"}, 
{"name": "Antarctica", "code": "AQ"}, 

eon01

<?xml version="1.0" encoding="UTF-8"?>
<root>
   <element>
      <code>AF</code>
      <name>Afghanistan</name>
   </element>
   <element>
      <code>AX</code>
      <name>Åland Islands</name>
   </element>

eon01

#!/usr/bin/python
# -*- coding: utf-8 -*-

from bs4 import BeautifulSoup
import urllib2

__author__ = "Aymen Amri"
__email__ = "[email protected]"