/home/wwwroot/lnmp01/domain/easy_zdata/package/deploy/en07/10_1.kickgame.com0/sessions/e/cart SELECT count(1) as counts,* FROM sqlite_master where sql=:sql /home/wwwroot/lnmp01/domain/easy_zdata/package/deploy/en07/10_1.kickgame.com0/sessions/e/cart SELECT count(1) as counts,* FROM sqlite_master where sql=:sql /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_id/product4 SELECT * FROM mtl_product p,mtl_product_model pm,mtl_product_title pt,mtl_product_quantity pq,mtl_product_to_category ptc,mtl_product_to_product ptp,mtl_product_points ppo where p.show=1 and p.product_id= pm.product_id and p.product_id= pq.product_id and p.product_id= ppo.product_id and p.product_id= ptp.product_id and p.product_id= pt.product_id and p.product_id= ptc.product_id and p.product_id=901 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_price SELECT * FROM mtl_product_price pp,mtl_product_special_offer pso where pp.product_id= pso.product_id and pp.product_id=210 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_descpription SELECT * FROM mtl_product_description where product_id=210 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_meta SELECT * FROM mtl_product_meta where product_id=210 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT * FROM mtl_product_link where product_id=210 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/category SELECT * FROM mtl_category c,mtl_category_title ct where c.category_id=ct.category_id and c.category_id= 6 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/category SELECT * FROM mtl_category c,mtl_category_title ct where c.category_id=ct.category_id and c.category_id= 1 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/category_description SELECT * FROM mtl_category_description where category_id= 1 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/category_description SELECT * FROM mtl_category_description where category_id= 6 /home/wwwroot/lnmp01/domain/easy_zdata/fake_key/shoe_default select * from mtl_mainword where name=? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? /home/wwwroot/lnmp01/domain/easy_zdata/fake_key/shoe_default select name from mtl_keyword where id=16083 /home/wwwroot/lnmp01/domain/easy_zdata/fake_key/shoe_default select * from mtl_mainword where name=? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? /home/wwwroot/lnmp01/domain/easy_zdata/fake_key/shoe_default select name from mtl_keyword where id=16083 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 901 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_attribute SELECT *,pa.option_id as options_id FROM mtl_product_attribute pa, mtl_product_option po, mtl_product_option_value pov where pa.option_id=po.option_id and pa.option_value_id=pov.option_value_id and pa.product_id=210 /home/wwwroot/lnmp01/domain/easy_zdata/package/deploy/en07/10_1.kickgame.com0/sessions/e/cart SELECT sum(quantity)as quantity,SUM(quantity*price) AS total_price FROM mtl_shopping_cart where session_name=:session_name /home/wwwroot/lnmp01/domain/easy_zdata/package/deploy/en07/10_1.kickgame.com0/sessions/e/cart select * FROM mtl_shopping_method where session_name=:session_name /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/category SELECT data_count FROM mtl_category where category_id=6 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/rate/6/rate_id select * from mtl_rate_id where product_id=210 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/rate/6/rate SELECT * from mtl_rate where top_id=0 and product_id=210 order by add_time desc Limit 5 Offset 0 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/ask/6/rate_id select * from mtl_rate_id where product_id=210 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/ask/6/rate SELECT * from mtl_rate where top_id=0 and product_id=210 order by add_time desc Limit 5 Offset 0 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_nature SELECT count(*) as count from mtl_product_nature pa, mtl_product_option po, mtl_product_option_value pov where pa.option_id=po.option_id and pa.option_value_id=pov.option_value_id and pa.product_id =210 and po.types =2 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_nature SELECT * from mtl_product_nature pa, mtl_product_option po, mtl_product_option_value pov where pa.option_id=po.option_id and pa.option_value_id=pov.option_value_id and pa.product_id =210 and po.types =2 order by attribute_id asc /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_nature SELECT count(*) as count from mtl_product_nature pa, mtl_product_option po, mtl_product_option_value pov where pa.option_id=po.option_id and pa.option_value_id=pov.option_value_id and pa.product_id =210 and po.types =1 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_nature SELECT * from mtl_product_nature pa, mtl_product_option po, mtl_product_option_value pov where pa.option_id=po.option_id and pa.option_value_id=pov.option_value_id and pa.product_id =210 and po.types =1 order by attribute_id asc /home/wwwroot/lnmp01/domain/easy_zdata/package/deploy/en07/10_1.kickgame.com0/sessions/e/product_record select page_id from mtl_recent_products where session_name=:session_name order by id desc limit 8 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_id/product4 SELECT p.product_id,name,product_oid,change_time FROM mtl_product p,mtl_product_model pm,mtl_product_title pt,mtl_product_to_product ptp,mtl_product_to_category ptc where p.show=1 and p.product_id= pm.product_id and p.product_id= ptp.product_id and p.product_id= pt.product_id and p.product_id= ptc.product_id and p.product_id in () /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_id/product4 SELECT p.product_id,name,product_oid,change_time FROM mtl_product p,mtl_product_model pm,mtl_product_title pt,mtl_product_to_product ptp,mtl_product_to_category ptc,mtl_product_points ppo,mtl_product_soft_price psp where p.show=1 and p.product_id= pm.product_id and p.product_id= ptp.product_id and p.product_id= psp.product_id and p.product_id= pt.product_id and p.product_id= ptc.product_id and p.product_id= ppo.product_id and p.product_id in (130,286,372,467,504,564,580,675,951,1110) limit 10 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_price SELECT pp.product_id,price,special_offer FROM mtl_product_price pp,mtl_product_special_offer pso where pp.product_id= pso.product_id and pp.product_id in (222,391,893,303,433,683,652,250,255,128) /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_descpription SELECT product_id,image FROM mtl_product_description where product_id in (222,391,893,303,433,683,652,250,255,128) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_id select * from mtl_rate_id /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate SELECT * from mtl_rate where top_id=0 and rate_id in (149,298,447,596,745,894,52,201,350,499) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate SELECT * from mtl_rate where top_id in (52,149,201,298,350,447,499,596,745,894) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_user SELECT * FROM mtl_rate_user where rate_user_id in (52,149,201,298,350,447,499,596,745,894) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_product SELECT * FROM mtl_rate_product where rate_product_id in (48,125,166,237,37,6,373,272,516,289) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_title SELECT * FROM mtl_rate_title where rate_title_id in (52,149,201,298,350,447,499,596,745,894) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_content SELECT * FROM mtl_rate_content where rate_content_id in (52,149,201,298,350,447,499,596,745,894) /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 901 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 901 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 901 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 901 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 901 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 901 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 901 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 901 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 901 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 901 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 901 /home/wwwroot/lnmp01/domain/easy_zdata/word/en07/10_1.kickgame.com0/en_10/10_1.kickgame.com0/en/ad_word select max(ad_word_ip) as maxid FROM mtl_ad_word 123123
1999 Air Jordan 4 Bred Retro GS 'Lightning' 2021 DCCFA0901
The 2021 edition of the Air Jordan 4 Retro GS ‘Lightning’ brings back a sought-after 2006 colorway in grade school sizing. Like the original, the mid-top makes use of a bright yellow nubuck upper with black molded eyelets and matching black netting on the quarter panel and throat. Dark grey accents settle on the wings, interior tongue, and molded Jumpman logo on the heel overlay. A second Jumpman icon decorates the woven tongue tag. The sneaker is mounted on a white foam midsole with visible Air-sole cushioning in the heel. A grey rubber outsole features a grippy herringbone traction pattern underfoot.
Thank you for visiting and shopping at airsshoes.shop. Following are the terms and conditions that constitute our Shipping Policy.
Shipment processing time
All orders made before 2:00PM are processed within 2-3 business days. Orders are not shipped or delivered on weekends or holidays.
If we are experiencing a high volume of orders, shipments may be delayed by a few days. Please allow additional days in transit for delivery. If there will be a significant delay in shipment of your order, we will contact you via email or telephone.
Shipping rates ### delivery estimates
Shipping charges for your order will be calculated and displayed at checkout.The shipping time is about 7-10 business days via USPS.Delivery delays can occasionally occur.
Shipment confirmation ### Order tracking
You will receive a Shipment Confirmation email once your order has shipped containing your tracking number(s). The tracking number will be active within 24 hours.
Customs, Duties and Taxes
airsshoes.shop is not responsible for any customs and taxes applied to your order. All fees imposed during or after shipping are the responsibility of the customer (tariffs, taxes, etc.).
Reviewer S Jean Erdman
These shoes are very comfortable! I ordered 2 more pair in different colors!
Reviewer Robert C Lyons
Look good. A bit stiff at first but they’re broken in now and very comfortable.
Reviewer M Littrell
I was worried when these arrived because they were pretty stiff, but after about a week of wearing them, they broke in very nicely and are awesome! They look great with casual outfits and are fairly comfortable. I do have somewhat wide feet and after several hours of wearing, my dogs are barking, but that's nothing new.
Reviewer Joseph J Kenny
I wear them all day at work. They work pretty good for me.
Reviewer J Valdmanis
Excellent product. Excellent service.
Reviewer Tara Luke
The soles are great for all terrains. The memory foam helps to keep my feet from hurting after a long walk. I'm very pleased!
Reviewer BKD
Seem to be made well. Nice looking shoes.
Reviewer Michigan Mommy
Love these sturdy, wonderful shoes! Will keep buying these.
Reviewer I Kleiner
I have the black swede shoes. They could easily be mistaken for canvas, but they are indeed black swede. Very classic look. Plain and simple, which I quite like. They have really nice arch support inside, which often is not the case. Some padding around the ankle, as well as the footbed, though not a ton. They are still quite comfortable. A little bit heavy as the sole is rubber. Not a lot of tread on the bottom, but some. These shoes are Made in China, so kind of pricey at seventy-five bucks, but nice, casual shoes overall.
Reviewer Thomas F Urrutia
Great shoe, very comfortable, great support for my husband's arthritic ankle.