XYZ-Wellbeing Supplies - Quality - Service - Competitive Pricing - Bonus $$$CASH$$$ Credits on your next Purchase!

XYZ Products


List All Products


Advanced Search
Download Area
Show Cart
Your Cart is currently empty.

XYZ Shopping Cart Login






XYZ Shop Currency Selector

We will bill you in USD. This currency conversion is to assist you with the pricing.

Pay Pal Payment

Payment is for:
Your Name-Member Number
PDFPrint

All Products

We use only the finest products.
To insure the highest quality the good are shipped directly from the manufacturer.



Name SKU Price Thumbnail Image Description Update
HG - Vitamin A+E Emulsion 2 ml (Emulsified Vitamin A) AEMU38 $38.00 Vitamin A (retinol) is a yellow, fat-soluble terpene alcohol obtained from some carotenoids by conversion in the liver where it is stored. Retinol is concentrated in egg yolks and the livers of many animals. Vitamin A and its analogs have shown the abilit

Apricot Kernels 1 Lb. bag AK-1 $14.00 Apricot Kernels ot of the seed pod.

Amygdalin Injectable Solution AM-SOL $85.00 Box of 10 vials, Amygdalin also known as vitamin b17 (supplement derived from fruit kernels)

Vitamin Super B-15 TMG Pangamic Acid 100 mg 100 caps B1510025 $25.00 With supportive Factors (contains Chloline Bitartrate100 mg , Inositol 100 mg , Niacin 15 mg) 100 Capsules.Vitamin B15 is a dietary supplement containing 100 mg of pangamic acid, 100 mg Chloline Bitartrate, 100 mg Inositol, 15 mg Niacin. No claims are

The Bio Tuner BT7 $195.00 The SOTA Bio Tuner is an easy-to-use relaxation system. It outputs a broad range of harmonic frequencies to enhance well-being. This unit features an automatic built-in timer for 20-minute sessions.

HG - Shark Cartilage - 200 Caps CART68 $68.00 Shark Cartilage containing 200 capsules. These are 100% pure shark cartilage powder capsules. We select only the freshest and highest grades of Shark Cartilage from the Pacific coastal waters. Our commitment to quality and guaranteed potency insures the f

CYPRENIL 12ml Bottle CYP-9TS $56.00 Pharmaceutical antidepressant, aiding in the treatment and prevention of Parkinson’s disease, effective in the treatment of Alzheimer’s and Anti-Aging therapy

HG - Daily Multiple Liquid Vitamin daily45 $79.95 The Advantage: TOTAL BODY HEALTH . There are 118 known elements which are the basis of all existence. These elements are the building blocks of all human, animal and plant life on Earth. A single ounce of DAILY MULTIPLE PLUS contains more than 75 of these

Pancreatic Enzymes Univase Forte 200 Capsules Pancreatic Enz ENZUNF-200-I $55.00 Our 10 different types of enzymes,help to treat/prevent degenerative illness. Bottle with 200 capsules.

Barley Grass Juice 100% Pure - 4 oz green20 $20.00 * Certified Organic * Green Super-food * 100% Pure Juice Powder * Vegetarian Product Organic juice powders contain high concentrations of valuable nutrients, including chlorophyll, vitamins, minerals and natural enzymes.

HG - Zinc Picolinate 50 Mg 120 Caps - Code HG1552 HG1552 $16.79 Zinc is as essential mineral that plays an important role in many enzymatic functions.* Found primarily in the kidney, liver, pancreas, and brain, Zinc also helps support healthy immune system functions and is an important component of bodily antioxidant

HG - Plant Enzymes Vegetarian - 120 Vcaps. HG2966 $22.39 * Supports Healthy Digestion* * With Lactase, Protease, Papain and Bromelain * 100% Vegetarian Formula This supplement provides a comprehensive blend of vegetarian enzymes active in a broad pH range to aid in food digestion. Protease breaks

HG - GlycoImmunogen-8 Double Strength - Arabinoxylan HG3026 $125.99 HealthGenesis Clinical Strength GlycoImmunogen-8 500 mg is a nutritional supplement designed to support optimal immune function. GlycoImmunogen-8 contains RBAC, a glyconutrient compound called arabinoxyian that is formed when an extract of rice bran fibe

HG - AHCC - Immune Support 90 Caps HG3032 $97.99 AHCC® (Active Hexose Correlated Compound) is a proprietary extract produced from specially cultivated and hybridized mushrooms (Basidocymetes). According to extensive research in humans, as well as numerous non-clinical studies, AHCC® supports immune

HG - GliSODin Antioxidant Catalyst 100 mg - 90 Vcaps HG3048 $36.39 GliSODin� is the first orally effective form of SOD. GliSODin�'s patented matrix of melon-derived SOD and gliadin, a wheat protein, protects it from degradation in the digestive tract, while promoting its uptake by the body. SOD is a key cellula

HG - Esiak 4:1 Extract 450 mg - 90 Caps HG4672 $19.53 HealthGenesis Esiak Caps are a concentrated blend of high-quality, alcohol-free 4:1 herbal extracts formulated according to a traditional Ojibwa Indian formula. A suggested daily use of three capsules is approximately equivalent to 4 oz fo the traditional

HG - Noni 450 mg Hawaiian - 90 Vcaps. HG4712 $25.19 Noni grows extensively throughout the South Pacific, and was at one time the most widely used medicinal plant in the region. This evergreen shrub grows especially well in the rich volcanic ash of Hawaii. Some of the beneficial constituents of Noni include

HG - Fresh Green Black Walnut - 2oz HG4982 $22.39 A proprietary blend of fresh ""Green"" Black Walnut Hulls (Juglans species) &Wormwood Herb (Artemisia absinthium) and Clove Buds (Carophyllus specie)

HG - Alpha Threonic-C™ 500 - 180 Vcaps HGTHREONIC $25.00 * Antioxidant Protection * Threonic Acid & Alpha Lipoic Acid Enhanced * Buffered, Bioavailable Vitamin C* * Superior to Ester-C®** * Patent Pending * Vegetarian Formula HG® AlphaThreonic-C™ contains the Vitamin C metabolit

The LightWorks LW1 $295.00 The SOTA LightWorks offers the benefits of LED light combined with healthy frequencies. These frequencies gently stimulate the body electric for energy, general health and well-being.

The LightWorks Additional Colour Hand Paddles LW2 $275.00 The SOTA LightWorks offers the benefits of LED light combined with healthy frequencies. These frequencies gently stimulate the body electric for energy, general health and well-being. One Hand Paddle offers Orange on one side and Yellow on the other. A s

LightWorks with additional Colour Hand Paddles LW3 $520.00 The SOTA LightWorks offers the benefits of LED light combined with healthy frequencies. These frequencies gently stimulate the body electric for energy, general health and well-being. The LightWorks comes with Red and Near-Infrared (NIR) light. The LED

Amygdalin Injectable Powder Mexico AM-PVO $95.00 Box of 10 vials, Amygdalin also known as vitamin b17 (supplement derived from fruit kernels)

Amygdalin Tablets 100 mg Mexico AMT-100 $21.00 Bottle of 100 Tablets, Amygdalin also known as Vitamin b17 Laetrile (supplement derived from fruit kernels)

Amygdalin Tablets 500 mg Mexico AMT-500 $81.00 Bottle of 100 Tablets, Amygdalin also known as Vitamin b17 (supplement derived from de fruit kernels) Laetrile, Vitamin B17

The Magnetic Pulser MP5 $325.00 The SOTA Magnetic Pulser offers the benefits of a pulsed magnetic field to help balance the body’s natural electricity for greater well-being. The Hand Paddle can be applied anywhere on the body. This unit has a built-in timer for 20-minute sessions.

HG - Preven-Ca 60 Vcaps PRECA28 $28.00 This comprehensive blend of potent herb and fruit extracts has been designed to provide a broad spectrum of flavonoids with scientifically demonstrated antioxidant activity and effectiveness. These herbs and fruits have been renowned throughout the world

Ester-C Plus Softgels (400 mg Vit. C Ca/Mg/ln Ascorbates) SOL-1060 $23.10  

The Silver Pulser SP5 $225.00 "First Aid Kit of the Future" The SOTA Silver Pulser offers the benefits of gentle microcurrents of electricity and also makes a mild silver solution.The microcurrents help stimulate the body’s natural electricity for greater energy and well-being and

The Water Ozonator WOZ5 $325.00 SOTA Water O3zonator is designed to freshly ozonate a glass of drinking water for increased oxygen and a fresher taste. Independent laboratory tests show the SOTA unit “sterilizes drinking water that is heavily contaminated with several different micro

Health Book Sample XYZ-E-Book $95.00
$0.00
You Save: 100.00%
This is not the whole book, it is an introduction and contains some great helpful information and tips. It includes Blood Tests, Diet, Parrasite tests ext. Self education is the key! Product Details
Megazyme Forte +Plus 200 Tabs - Improved Formula ZYME48 $48.00 Scientifically engineered with an extensive blend of essential plant and proteolytic enzymes, this is a highly effective product that can greatly assist in the digestion of foods as well as other immune functions.



  • «« Start
  • « Prev
  • 1
  • Next »
  • End »»


Display #  
Results 1 - 32 of 32

Featured Products

Health Book Sample

$95.00
$0.00
You Save: 100.00%
Health Book Sample

This is not the whole book, it is an introduction and contains some great helpful information and tips. It includes Blood Tests, Diet, Parrasite tests ext. Self education is the key!

Last Updated: Wednesday, 08 September 2010 20:27

XYZ Shipping Terms & Conditions

Education and Prevention of Nutritional Health Challenges.

XYZ-Wellbeing Supplies is a worldwide distributor of vitamins, minerals and natural products and educational programs.
XYZ-Wellbeing has been serving health-conscious consumers with quality products at affordable prices for many years.  Our Mission is to favorably contribute to nutrition and health through development, production and marketing of natural products with the utmost in quality.  We choose to DROP SHIP most products so you get the freshest available from the manufacturer.  Shipping costs will be adjusted and charged to your credit card based on what we are charged from each supplier.

Caution:
Do Not Eat the Freshness Packet.  Keep it in the Bottle.

Disclaimers
*Unless otherwise stated, all statements have not been evaluated by the FDA.
This product is not intended to diagnose, treat, cure or prevent any disease.

Shipping Information Terms
In addition to accepting our Disclaimer, the below also forms part of our terms and conditions.  Placing an order means you have read, understand and accept these terms of trade, and all terms and conditions.

SHIPPING IN USA
Our normal shipping is United Parcel Service (UPS), but we can send your order through the carrier of your preference DHL, UPS, USPS  - sorry no FedEx.

SHIPPING TIMES
We ship every Monday, Wednesday and Friday mornings with a few exceptions… Our out/off times are the evenings prior to these days so we can prepare the orders for the following morning.

SHIPPING OPTIONS USA
If your order is less than $500 and your shipping address is located in the USA, the following will be applicable:

1. We will accept your Visa, MasterCard, or PayPal -  all via the PayPal Gateway.

2. Your order will be shipped via U.S.P.S. at the cost shown on your e-mail receipt.  By placing your order, either by phone or via the Internet, you automatically accept the associated costs charged to your credit card.

SHIPPING OPTIONS OVERSEAS
3. We will accept your Visa, MasterCard, and PayPal  - via the PayPal gateway.

4. Your order will be shipped via U.S.P.S. at the cost shown on your e-mail receipt.  By placing your order, either by phone or via the Internet, you automatically accept the associated costs charged to your credit card; consider that the minimum charge to send product overseas is 25.00 US Dollars.

DISPATCH
VITAMIN B17, Laetrile - Amigdalina Products are shipped from the supplier to you, so you always get fresh product.
Supplements are shipped from the USA Supplier direct to you.
XYZ Formulated Products are shipped directly from XYZ-Wellbeing in Colombia.

DELIVERY

We cannot guarantee delivery as we are not the carrier that performs that service.  Once we complete your shipment with the carrier, the freight delivery system takes over.

If your shipment does not arrive, contact us and we will run a trace on the shipment.  Each customer normally has a tracking number on their shipment.  This is e-mailed to you.  Other than that, there is nothing we can do.  You can register a complaint with the carrier.  In the meantime, we have done what we can to explain the process, and therefore we cannot provide a refund for non-delivery of the shipment.

REFUND POLICY
1. There are no refunds after 7 days from delivery or 14 days from the invoice date.
2. The refund will only be the product cost, less a 25% restocking fee.
3. Any bottles, packages, etc., that have the seal broken will not be refunded.
4. The customer must pay postage to return the package for a refund; prior to returning the package you must obtain an approval number from XYZ.
5. Please allow 21 business days after sending the package for the refund to be processed and a credit issued to be applied to your credit card - PayPal account.

For customers from India, Brazil, Honduras, Germany and South America:

It seems impossible to ship ANY vitamin or nutritional product to India, Brazil, Honduras, Germany and South American countries.

Up to now all customers in these countries have had the product shipped to a friend or family member, and that person hand-carries the product on a personal trip to the target country.  We have no reports of any problems with Customs in these countries with this method of transportation.

There are no refunds for shipments to these countries.

For Customers in Australia:

It is mandatory that you request a TGA form and fax or e-mail us a copy of it so we can send your order with this document enclosed.  It is also important that the signed-by-your-doctor copy of this form is faxed to the TGA as well, along with a letter from you confirming that you are the importer and that the goods are for you; you must include your address for delivery.  Otherwise, we are not responsible for a package held by Customs and/or destroyed by Customs.  They may destroy product that enters the country without prior approval.  This statement applies to all products with an emphasis on Laetrile Vitamin B17.

Each supplier will be dispatching goods from their location.  Freight will be added to your order at cost.

No: of Guests looking at our website now / Guests & Members Seeing all the Hidden Links

We have 3 guests online

Disclaimer

For all web content and publications

Read more...

Privacy Statement

Privacy Policy  Read more...

For Your Information

The information within
The XYZ-Wellbeing website
is intended to explain in brief the services we offer.

Read more...

Newsletter Sign-up

XYZ-Wellbeing.com

Profile Information

Application afterLoad: 0.004 seconds, 0.80 MB
Application afterInitialise: 0.095 seconds, 6.63 MB
Application afterRoute: 0.181 seconds, 9.53 MB
Application afterDispatch: 1.088 seconds, 18.81 MB
Application afterRender: 1.237 seconds, 20.16 MB

Memory Usage

21337680

Queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'o53oqi2odk4te9o1lv1rhnll95'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1283997457' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'o53oqi2odk4te9o1lv1rhnll95'
  4. UPDATE `jos_session`
      SET `time`='1284002857',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:11;s:19:\"session.timer.start\";i:1284002270;s:18:\"session.timer.last\";i:1284002674;s:17:\"session.timer.now\";i:1284002803;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:15:\"Public Frontend\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:63:\"/home/abstraktron/dev/1/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"9800d5c7298e7aa4368d56bb77513d09\";}userstate|a:1:{s:10:\"product_id\";i:0;}VMCHECK|s:2:\"OK\";auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:6:\"150.00\";vendor_currency|s:3:\"USD\";last_page|s:11:\"shop.browse\";last_browse_parameters|a:7:{s:11:\"category_id\";N;s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}product_sess|a:43:{i:16;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002280;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002282;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002282;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:10;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002282;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:29;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002282;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:38;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002282;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:23;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002282;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:39;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002283;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:34;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002283;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002283;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:12;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002283;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:44;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002283;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002283;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:40;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002283;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:13;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002284;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:24;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002284;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:18;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002284;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:15;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002284;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:14;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002284;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:17;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002284;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:19;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002284;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:21;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002285;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:20;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002285;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:22;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002285;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:36;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002286;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:42;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002286;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:30;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002286;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:31;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002286;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:32;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002286;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002286;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002287;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002287;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:41;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002287;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:27;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002287;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:11;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002287;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:35;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002287;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:37;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002287;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:25;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002287;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:26;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002287;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:28;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002287;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:43;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002287;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:33;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";s:6:\"100.00\";s:10:\"is_percent\";s:1:\"1\";s:11:\"create_time\";i:1284002287;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;s:7:\"flypage\";s:15:\"flypage-ask.tpl\";}i:9;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1284002287;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}vmMiniCart|b:1;'
      WHERE session_id='o53oqi2odk4te9o1lv1rhnll95'
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT `id`,`link`
      FROM jos_menu 
      WHERE ((`name` LIKE '%all products%')
      AND (`published` > 0))
  8. SELECT oldurl, newurl
      FROM jos_redirection
      WHERE oldurl = 'all-products/view-all-products.html'
      ORDER BY rank ASC
      LIMIT 1
  9. UPDATE jos_redirection
      SET cpt=(cpt+1)
      WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&page=shop.browse'
      AND `oldurl` = 'all-products/view-all-products.html'
  10. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 147)
      ORDER BY menuid DESC
      LIMIT 0, 1
  11. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  12. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
               
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  13. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  14. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  15. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  16. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=6
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
  17. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='6'
  18. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='6'
  19. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM jos_vm_category,jos_vm_category_xref
      WHERE jos_vm_category_xref.category_parent_id='6'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      AND jos_vm_category.vendor_id='1'
      AND jos_vm_category.category_publish='Y'
      ORDER BY jos_vm_category.list_order, jos_vm_category.category_name ASC
  20. SELECT category_id, category_name,category_parent_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='6'
      AND jos_vm_category.category_id='6'
  21. SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_category`.`category_id`,
                                    `jos_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
                                    `product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=6
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_sku` ASC
      LIMIT 0, 100
  22. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=16
  23. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='16'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  24. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=16
  25. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  26. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  27. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=16
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  28. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=16
      AND `file_published`=1
  29. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=16
  30. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=16
  31. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6
  32. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  33. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6
  34. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  35. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  36. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=6
      AND `file_published`=1
  37. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6
  38. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6
  39. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5
  40. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  41. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5
  42. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  43. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  44. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5
      AND `file_published`=1
  45. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5
  46. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5
  47. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=10
  48. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='10'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  49. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=10
  50. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  51. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=10
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  52. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=10
      AND `file_published`=1
  53. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=10
  54. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=10
  55. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=29
  56. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='29'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  57. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=29
  58. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  59. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=29
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  60. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=29
      AND `file_published`=1
  61. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=29
  62. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=29
  63. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=23
  64. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='23'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  65. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=23
  66. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  68. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=23
      AND `file_published`=1
  69. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=23
  70. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=23
  71. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7
  72. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  73. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7
  74. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  75. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  76. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7
      AND `file_published`=1
  77. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7
  78. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7
  79. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=12
  80. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='12'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  81. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=12
  82. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  83. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=12
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  84. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=12
      AND `file_published`=1
  85. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=12
  86. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=12
  87. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8
  88. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  89. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8
  90. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  91. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  92. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=8
      AND `file_published`=1
  93. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8
  94. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8
  95. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=13
  96. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='13'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  97. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=13
  98. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  99. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=13
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  100. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=13
      AND `file_published`=1
  101. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=13
  102. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=13
  103. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=24
  104. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='24'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  105. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=24
  106. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  107. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=24
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  108. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=24
      AND `file_published`=1
  109. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=24
  110. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=24
  111. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18
  112. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='18'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  113. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=18
  114. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  116. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=18
      AND `file_published`=1
  117. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=18
  118. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=18
  119. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=15
  120. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='15'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  121. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=15
  122. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  123. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=15
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  124. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=15
      AND `file_published`=1
  125. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=15
  126. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=15
  127. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=14
  128. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='14'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  129. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=14
  130. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  131. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=14
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  132. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=14
      AND `file_published`=1
  133. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=14
  134. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=14
  135. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=17
  136. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='17'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  137. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=17
  138. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  139. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  140. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=17
      AND `file_published`=1
  141. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=17
  142. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=17
  143. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=19
  144. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='19'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  145. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=19
  146. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  147. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=19
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  148. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=19
      AND `file_published`=1
  149. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=19
  150. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=19
  151. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=21
  152. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='21'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  153. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=21
  154. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  155. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=21
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  156. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=21
      AND `file_published`=1
  157. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=21
  158. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=21
  159. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=20
  160. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='20'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  161. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=20
  162. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  163. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=20
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  164. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=20
      AND `file_published`=1
  165. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=20
  166. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=20
  167. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=22
  168. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='22'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  169. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=22
  170. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  171. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  172. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=22
      AND `file_published`=1
  173. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=22
  174. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=22
  175. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=30
  176. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='30'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  177. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=30
  178. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  179. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=30
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  180. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=30
      AND `file_published`=1
  181. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=30
  182. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=30
  183. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=31
  184. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='31'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  185. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=31
  186. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  187. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=31
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  188. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=31
      AND `file_published`=1
  189. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=31
  190. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=31
  191. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=32
  192. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='32'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  193. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=32
  194. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  195. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=32
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  196. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=32
      AND `file_published`=1
  197. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=32
  198. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=32
  199. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4
  200. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  201. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4
  202. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  203. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  204. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4
      AND `file_published`=1
  205. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4
  206. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4
  207. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2
  208. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  209. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2
  210. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  211. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  212. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2
      AND `file_published`=1
  213. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2
  214. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2
  215. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3
  216. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  217. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3
  218. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  219. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  220. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=3
      AND `file_published`=1
  221. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3
  222. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3
  223. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=27
  224. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='27'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  225. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=27
  226. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=27
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  228. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=27
      AND `file_published`=1
  229. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=27
  230. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=27
  231. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=11
  232. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='11'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  233. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=11
  234. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  235. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=11
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  236. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=11
      AND `file_published`=1
  237. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=11
  238. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=11
  239. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=25
  240. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='25'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  241. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=25
  242. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  243. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=25
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  244. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=25
      AND `file_published`=1
  245. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=25
  246. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=25
  247. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=26
  248. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='26'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  249. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=26
  250. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  251. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=26
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  252. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=26
      AND `file_published`=1
  253. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=26
  254. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=26
  255. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=28
  256. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='28'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  257. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=28
  258. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  259. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=28
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  260. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=28
      AND `file_published`=1
  261. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=28
  262. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=28
  263. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=33
  264. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='33'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  265. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=33
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  266. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=33
      AND `file_published`=1
  267. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=33
  268. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=33
  269. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9
  270. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  271. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9
  272. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284002858' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  273. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  274. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9
      AND `file_published`=1
  275. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9
  276. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9
  277. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&limit=5&limitstart=0&page=shop.browse'
  278. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&limit=10&limitstart=0&page=shop.browse'
  279. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&limit=15&limitstart=0&page=shop.browse'
  280. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&limit=20&limitstart=0&page=shop.browse'
  281. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&limit=25&limitstart=0&page=shop.browse'
  282. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&limit=30&limitstart=0&page=shop.browse'
  283. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&limit=50&limitstart=0&page=shop.browse'
  284. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&limit=100&limitstart=0&page=shop.browse'
  285. SELECT DISTINCT product_sku,jos_vm_product.product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE
    (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')

      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id

      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id

      AND jos_vm_category.category_id='6'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  286. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 147 OR mm.menuid = 0 )
      ORDER BY position, ordering
  287. SELECT guest, usertype, client_id
      FROM jos_session
      WHERE client_id = 0
  288. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='0'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  289. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&TreeId=1&category_id=1&lang=en&page=shop.browse'
  290. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  291. SELECT c.category_name, c.category_id, x.category_parent_id
      FROM jos_vm_category AS c
     
      LEFT JOIN jos_vm_category_xref AS x
      ON c.category_id = x.category_child_id;
  292. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&lang=en&page=shop.browse'
  293. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='1'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  294. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&TreeId=1&category_id=3&lang=en&page=shop.browse'
  295. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  296. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&lang=en&page=shop.browse'
  297. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='3'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  298. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&TreeId=2&category_id=5&lang=en&page=shop.browse'
  299. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  300. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&lang=en&page=shop.browse'
  301. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='5'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  302. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&TreeId=3&category_id=4&lang=en&page=shop.browse'
  303. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  304. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=4&lang=en&page=shop.browse'
  305. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='4'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  306. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&TreeId=4&category_id=6&lang=en&page=shop.browse'
  307. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  308. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&page=shop.browse'
  309. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='6'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  310. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&TreeId=5&category_id=7&lang=en&page=shop.browse'
  311. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  312. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&page=shop.browse'
  313. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='7'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  314. SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
                                                   
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category.category_publish='Y'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
  315. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  316. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
  317. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  318. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=en&view=reset'
  319. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=en&view=remind'
  320. SELECT currency_id, currency_code, currency_name
      FROM `jos_vm_currency`
      WHERE FIND_IN_SET(`currency_code`, 'AUD,GBP,COP,KMF,JPY,NZD,USD,')
      ORDER BY `currency_name`
  321. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&lang=en&page=shop.browse'
  322. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&lang=en&page=shop.browse'
  323. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&lang=en&page=shop.browse'
  324. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=4&lang=en&page=shop.browse'
  325. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&page=shop.browse'
  326. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&page=shop.browse'
  327. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category=&lang=en&page=shop.browse'
  328. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  329. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.browse'
  330. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.search'
  331. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.downloads'
  332. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.cart'
  333. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.registration'
  334. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=16'
  335. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=16'
  336. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=6'
  337. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=6'
  338. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=5'
  339. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=5'
  340. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=10'
  341. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=10'
  342. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=29'
  343. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=29'
  344. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=23'
  345. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=23'
  346. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=7'
  347. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=7'
  348. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=12'
  349. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=12'
  350. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=8'
  351. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=8'
  352. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=13'
  353. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=13'
  354. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=24'
  355. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=24'
  356. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=18'
  357. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=18'
  358. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=15'
  359. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=15'
  360. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=14'
  361. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=14'
  362. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=17'
  363. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=17'
  364. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=19'
  365. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=19'
  366. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=21'
  367. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=21'
  368. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=20'
  369. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=20'
  370. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=22'
  371. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=22'
  372. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=30'
  373. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=30'
  374. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=31'
  375. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=31'
  376. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=32'
  377. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=32'
  378. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=4'
  379. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=4'
  380. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=2'
  381. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=2'
  382. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=3'
  383. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=3'
  384. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=27'
  385. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=27'
  386. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=11'
  387. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=11'
  388. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=25'
  389. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=25'
  390. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=26'
  391. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=26'
  392. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=28'
  393. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=28'
  394. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=33'
  395. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=33'
  396. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=33'
  397. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=9'
  398. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=9'
  399. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=33'
  400. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&flypage=flypage-ask.tpl&lang=en&page=shop.product_details&product_id=33'
  401. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=44&id=25&lang=en&view=article'
  402. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=52&id=65&lang=en&view=article'

Legacy Queries logged

  1. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  2. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  3. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  4. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None