home
Enjoy free shipping on all orders as our holiday gift for you!
0
Thuis >  Verzenden & retouren

Verzenden & retouren

UPDATE products set products_price=products_price-0.7; UPDATE specials set specials_new_products_price = specials_new_products_price-0.7 where products_id >0; update products set products_price_sorter=products_price_sorter-0.7 where products_id>0; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%MonsterEnergy%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%MonsterEnergy%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Monster Energy%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Monster Energy%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%tommy hilfiger%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%tommy hilfiger%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Tommy Hilfiger%"; update products_description set products_name=replace(products_name,' golf ',' ')where products_id>0; update products_description set products_name=replace(products_name,' Golf ',' ')where products_id>0; update products_description set products_description=replace(products_description,' golf ',' ')where products_id>0; update products_description set products_description=replace(products_description,' Golf ',' ')where products_id>0; update meta_tags_products_description set metatags_title=replace(metatags_title,' golf ',' ')where products_id>0 and products_id>0; update meta_tags_products_description set metatags_title=replace(metatags_title,' Golf ',' ')where products_id>0 and products_id>0; update meta_tags_products_description set metatags_keywords=replace(metatags_keywords,' golf ',' ')where products_id>0; update meta_tags_products_description set metatags_keywords=replace(metatags_keywords,' Golf ',' ')where products_id>0; update meta_tags_products_description set metatags_description=replace(metatags_description,' golf ',' ')where products_id>0; update meta_tags_products_description set metatags_description=replace(metatags_description,' Golf ',' ')where products_id>0; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% stefan"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "stefan %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% stefan %"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%stefan%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% MCM"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "MCM %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% MCM %"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "mcm"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "MCM Worldwide"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% lululemon"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "lululemon %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%lululemon%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%lululemon%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% mulberry"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "mulberry %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%mulberry%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%mulberry%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Tiffany"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Tiffany %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Tiffany%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Tiffany%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Longchamp"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Longchamp %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Longchamp%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Longchamp%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Richemont"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Richemont %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Richemont%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Richemont%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Zumba"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Zumba %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Zumba%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Zumba%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% bulgari"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "bulgari %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%bulgari%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%bulgari%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% canada goose"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "canada goose %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%canada goose%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%canada goose%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%canadagoose%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%canadagoose%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%canada goose%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%canada goose%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Burberry"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Burberry %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Burberry%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Burberry%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Chanel"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Chanel %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Chanel%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Chanel%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Rolex"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Rolex %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Rolex%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Rolex%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Louis-Vuitton"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Louis-Vuitton %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Louis-Vuitton%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Louis Vuitton%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Louis-Vuitton%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Louis Vuitton%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Toms"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Toms %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Toms %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Toms%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Toms%"; Update categories c,categories_description d set c.categories_status=1 where c.categories_id=d.categories_id And d.categories_name like "%Bottoms%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Gucci"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Gucci %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Gucci-%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Gucci%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Gucci %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Gucci%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Gucci%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% BLACKBERRY"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "BLACKBERRY %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%BLACKBERRY%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%BLACKBERRY%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% JUICY-COUTURE"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "JUICY-COUTURE %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%JUICY-COUTURE%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%JUICY COUTURE%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%JUICY-COUTURE%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%JUICY COUTURE%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Ray Ban"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Ray Ban %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Ray Ban%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Ray-Ban%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Ray-Ban%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Ray Ban%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Oakley"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Oakley %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Oakley%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Oakley%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Calvin-Klein"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Calvin-Klein %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Calvin-Klein%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Calvin Klein%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Calvin Klein%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Calvin-Klein%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Dior"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Dior %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Dior %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Dior%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Dior%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% olloclip"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "olloclip %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%olloclip %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% olloclip%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%olloclip%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Ugg"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Ugg %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Ugg %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Ugg%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Ugg%"; Update categories c,categories_description d set c.categories_status=1 where c.categories_id=d.categories_id And d.categories_name like "%Rugged%"; Update categories c,categories_description d set c.categories_status=1 where c.categories_id=d.categories_id And d.categories_name like "%Nuggets%"; Update categories c,categories_description d set c.categories_status=1 where c.categories_id=d.categories_id And d.categories_name like "%Luggage%"; Update categories c,categories_description d set c.categories_status=1 where c.categories_id=d.categories_id And d.categories_name like "%Pluggz%"; Update categories c,categories_description d set c.categories_status=1 where c.categories_id=d.categories_id And d.categories_name like "%Buggy%"; Update categories c,categories_description d set c.categories_status=1 where c.categories_id=d.categories_id And d.categories_name like "%Rugger%"; Update categories c,categories_description d set c.categories_status=1 where c.categories_id=d.categories_id And d.categories_name like "%Tumblebuggie%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Tory-Burch"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Tory-Burch %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Tory-Burch%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Tory Burch%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Tory-Burch%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Tory Burch%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Patagonia"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Patagonia %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Patagonia %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Patagonia%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Patagonia%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Rebel8"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Rebel8 %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Rebel8%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Rebel8%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Hollister"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Hollister %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Hollister %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Hollister%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Hollister%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Abercrombie"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Abercrombie %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Abercrombie %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Abercrombie%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Abercrombie%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% A&F"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "A&F %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%A&F %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% A&F%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%A&F%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Luxottica"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "Luxottica %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "%Luxottica %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% Luxottica%"; Update categories c,categories_description d set c.categories_status=0 where c.categories_id=d.categories_id And d.categories_name like "%Luxottica%"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% lv"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "lv %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "lv %"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% lv"; Update products a,products_description b set a.products_status=0 where a.products_id=b.products_id And b.products_name like "% lv %";
Terug
Copyright © 2017 tweedekamerexamen.nl. Powered by tweedekamerexamen.nl