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

X+Y=Z High PH Minerals

Manufactured exclusively for XYZ Wellbeing Supplies, our minerals are in glass amber bottles to ensure the very highest of quality manufactured by specialist chemists to the highest USA manufacturing requirements and independently tested for quality, consistency and potency.

Minerals are the building blocks of life and are involved in all processes of the body. Dietary minerals are the chemical elements required by living organisms. A mineral deficiency often results in an illness or deficiency disease. There are two kinds of minerals: macrominerals and trace minerals. Macrominerals are minerals your body needs in larger amounts. Trace minerals are those only needed in small amounts.

Dietary mineral supplements are available in a multitude of forms, including capsules, pills, tablets, powders and liquids. For many reasons, liquid minerals are the preferred format for dietary supplements. Liquid minerals are the most accessible form for the body, as they are more quickly and easily absorbed and used. Liquid minerals do not need to be dissolved and digested like supplements in a pill form. Liquid minerals do not contain the fillers and binder ingredients that pills need to maintain their pill format. Liquid minerals are easier to swallow than large pills, or large quantities of pills. Liquid minerals are easily mixed with fruit and vegetable juices for added nutrition when supplementing.



Name SKU Price Thumbnail Image Description Update
CALCIUM 500ml Ca $45.00 Calcium performs numerous vital functions in the body. It combines with phosphorus to strengthen bones and is crucial for nerve conduction, muscle contraction and heartbeat. Calcium also helps prevent cramps brought on by exercise by avoiding lactic acid

CHROMIUM 500ml Cr $90.00 Chromium is an essential mineral that is not made by the body and must be obtained from the diet. It is essential to the metabolism of lipids, glucose and insulin. It promotes healthy glucose tolerance and helps regulate sugar levels in the body. Chromium

CESIUM 1000ml CS $222.00 Cesium is one of the most alkaline elements. When taken up by cancer cells, it raises the pH of the cell. A pH range of 8.0 is a deadly environment for cancer cells. The cells die and are absorbed and eliminated by the body.

DMSO 1000ml DMSO Call for Pricing DMSO Liquid / Dimethylsulfoxide, 99.9% Pure Concentrate 8 fl. oz. Pharmaceutical grade DMSO. The best grade DMSO, sold at the lowest price that you will find. Pure DMSO freezes at room temperature (65 degrees F). This does not affect product qualit Product Details
GERMANIUM 500ml Ge $195.00 One of the main functions of germanium is to increase the use of oxygen by your body's tissues, which stimulates your cells to produce energy

Potasium 1000ml K $60.00 Potassium helps maintain blood pressure, heart and kidney function, muscle contraction, and digestion. Major studies on people with confirmed hypertension saw significant drops in their blood pressure after eating a potassium-rich diet. Nutritional therap

LITHIUM 500ml Li $60.00 Lithium is an essential mineral that protects brain cells against excess glutamate and calcium, and low levels cause abnormal brain cell balance and neurological disturbances. Lithium also is important in Vit-B12 transport and distribution. Studies have

MAGNESIUM 500ml Mg $45.00 Magnesium is essential for every major biological process. It is necessary for 300+ enzymatic reactions and is vital for calcium metabolism. Magnesium is not a trace mineral, but a major entity in our bodies.

ROBIDIUM 1000ml Rb $96.00 Rubidium is an alkaline trace mineral related with cesium and potassium chemically. In cancer cells, only water, sugar, potassium, cesium and rubidium are able to enter the cells, therefore rubidium is one on the minerals used in high pH therapy. In studi

SILICA 500ml Si $105.00 Silica is an element required for the proper functioning of the enzyme prolyhydroxylase. This enzyme functions in the formation of collagen in bone, cartilage, and connective tissue. Essense-of-Life's Silica is derived from the Horsetail plant. The Horset

XYZ MULI MINERAL MIX 1000ml XYZ Muli $240.00 Contains, 87,9mg of zinc.6,1mg of Manganese.3,2mg of Sodium Selenite.552mcg of Ammonium Molybdale.1,5mg of Chromium.4,7mg of Copper.1,06 mg of Vanadyl Sulfate.250mcg of Strontium.250mcg of Boron. 250mcg of Iodine.250mcg of Silica.150mcg of Vanadium.150cmg



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


Display #  
Results 1 - 11 of 11
Last Updated: Wednesday, 08 September 2010 20:48

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 6 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.008 seconds, 0.80 MB
Application afterInitialise: 0.140 seconds, 6.64 MB
Application afterRoute: 0.212 seconds, 9.54 MB
Application afterDispatch: 0.674 seconds, 18.37 MB
Application afterRender: 0.918 seconds, 19.67 MB

Memory Usage

20834208

Queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'o53oqi2odk4te9o1lv1rhnll95'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1283998726' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'o53oqi2odk4te9o1lv1rhnll95'
  4. UPDATE `jos_session`
      SET `time`='1284004126',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:36;s:19:\"session.timer.start\";i:1284002270;s:18:\"session.timer.last\";i:1284004040;s:17:\"session.timer.now\";i:1284004088;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\";i:4;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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284002858;}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:1284003857;}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:1284002858;}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 '%x+y=z high ph minerals%')
      AND (`published` > 0))
  8. SELECT oldurl, newurl
      FROM jos_redirection
      WHERE oldurl = 'x+y=z-high-ph-minerals/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=7&lang=en&page=shop.browse'
      AND `oldurl` = 'x+y=z-high-ph-minerals/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`=7
     
      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='7'
  18. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='7'
  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='7'
      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='7'
      AND jos_vm_category.category_id='7'
  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`=7
     
      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`=38
  23. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='38'
      AND (start_date<='1284004127' 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=38
  25. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284004127' 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=38
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  28. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=38
      AND `file_published`=1
  29. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=38
  30. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=38
  31. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=39
  32. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='39'
      AND (start_date<='1284004127' 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=39
  34. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284004127' 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=39
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  36. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=39
      AND `file_published`=1
  37. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=39
  38. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=39
  39. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=34
  40. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='34'
      AND (start_date<='1284004127' 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=34
  42. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284004127' 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=34
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  44. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=34
      AND `file_published`=1
  45. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=34
  46. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=34
  47. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=44
  48. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='44'
      AND (start_date<='1284004127' 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=44
  50. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284004127' 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=44
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  52. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=44
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  53. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=44
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  54. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=44
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  55. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=44
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  56. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=44
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  57. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=44
      AND `file_published`=1
  58. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=40
  59. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='40'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=40
  61. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  62. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=40
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  63. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=40
      AND `file_published`=1
  64. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=40
  65. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=40
  66. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=36
  67. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='36'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  68. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=36
  69. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  70. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=36
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  71. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=36
      AND `file_published`=1
  72. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=36
  73. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=36
  74. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=42
  75. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='42'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  76. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=42
  77. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  78. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=42
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  79. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=42
      AND `file_published`=1
  80. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=42
  81. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=42
  82. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41
  83. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='41'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  84. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=41
  85. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  86. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=41
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  87. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41
      AND `file_published`=1
  88. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=41
  89. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=41
  90. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=35
  91. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='35'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  92. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=35
  93. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  94. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=35
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  95. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=35
      AND `file_published`=1
  96. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=35
  97. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=35
  98. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=37
  99. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='37'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  100. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=37
  101. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  102. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=37
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  103. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=37
      AND `file_published`=1
  104. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=37
  105. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=37
  106. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=43
  107. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='43'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  108. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=43
  109. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1284004127' OR start_date=0)
      AND (end_date>='1283927760' OR end_date=0)
      AND product_discount_id=discount_id
  110. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=43
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  111. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=43
      AND `file_published`=1
  112. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=43
  113. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=43
  114. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&limit=5&limitstart=0&page=shop.browse'
  115. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&limit=10&limitstart=0&page=shop.browse'
  116. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&limit=15&limitstart=0&page=shop.browse'
  117. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&limit=20&limitstart=0&page=shop.browse'
  118. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&limit=25&limitstart=0&page=shop.browse'
  119. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&limit=30&limitstart=0&page=shop.browse'
  120. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&limit=50&limitstart=0&page=shop.browse'
  121. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&limit=100&limitstart=0&page=shop.browse'
  122. 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='7'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  123. 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
  124. SELECT guest, usertype, client_id
      FROM jos_session
      WHERE client_id = 0
  125. 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
  126. 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'
  127. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  128. 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;
  129. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&lang=en&page=shop.browse'
  130. 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
  131. 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'
  132. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  133. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&lang=en&page=shop.browse'
  134. 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
  135. 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'
  136. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  137. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&lang=en&page=shop.browse'
  138. 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
  139. 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'
  140. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  141. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=4&lang=en&page=shop.browse'
  142. 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
  143. 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'
  144. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  145. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&page=shop.browse'
  146. 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
  147. 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'
  148. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  149. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&page=shop.browse'
  150. 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
  151. 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
  152. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  153. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
  154. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  155. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=en&view=reset'
  156. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=en&view=remind'
  157. 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`
  158. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=1&lang=en&page=shop.browse'
  159. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=3&lang=en&page=shop.browse'
  160. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=5&lang=en&page=shop.browse'
  161. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=4&lang=en&page=shop.browse'
  162. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=6&lang=en&page=shop.browse'
  163. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&lang=en&page=shop.browse'
  164. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category=&lang=en&page=shop.browse'
  165. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  166. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.browse'
  167. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.search'
  168. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.downloads'
  169. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.cart'
  170. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.registration'
  171. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=38'
  172. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=38'
  173. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=39'
  174. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=39'
  175. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=34'
  176. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=34'
  177. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=44'
  178. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&lang=en&page=shop.ask&product_id=44&subject=Call for Pricing: DMSO 1000ml'
  179. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  180. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=44'
  181. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=44'
  182. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=40'
  183. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=40'
  184. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=36'
  185. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=36'
  186. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=42'
  187. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=42'
  188. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=41'
  189. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=41'
  190. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=35'
  191. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=35'
  192. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=37'
  193. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=37'
  194. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=43'
  195. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=147&category_id=7&flypage=flypage_images.tpl&lang=en&page=shop.product_details&product_id=43'
  196. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=44&id=25&lang=en&view=article'
  197. 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