Warning: mysql_query(): MySQL server has gone away in /home/chnbgems/public_html/includes/functions/database.php on line 44

Warning: mysql_query(): Error reading result set's header in /home/chnbgems/public_html/includes/functions/database.php on line 44
2006 - MySQL server has gone away

select distinct p.products_id, pd.products_name, IF(pg.customers_group_price IS NOT NULL,pg.customers_group_price, p.products_price) as products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p left join products_groups pg on p.products_id = pg.products_id and pg.customers_group_id like '%G%', products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' and p.products_group_access like '%G%' order by rand(), s.specials_date_added desc limit 10

TEP_DB_ERRORR

 Advance Search
 
Enter search keywords or item here
 Beads Catalogs
Gemstone Beads (Jade)
  African Jade Beads
  Aventurine Jade Beads
  Black Jade Beads
  Burma Jade Beads
  Butter Jade Beads
  Canadian Jade Beads
Candy Jade beads
  Round Candy Jade
  Rondelle Candy Jade
  Rice Candy Jade
  Teardrop Candy Jade
  Coin Candy Jade
  Oval Candy Jade
Diamond Candy Jade
  Square Candy Jade
  Rectangle Candy Jade
  Heart Candy Jade
  Other Candy Jade
  China Jade Beads
  Flower Jade Beads
  Goldstone Jade Beads
  Honey Jade Beads
  Korean Jade Beads
  Lemon Jade Beads
  Lucky Jade Beads
  Malaysia Jade Beads
  New Jade Beads
  Olive Jade Beads
  Other Jade Beads
  Plum Blossom Jade Beads
  Qinghai Jade Beads
  Red Jade Beads
  Serpentine Jade Beads
  Transvaal Jade Beads
  White Jade Beads
  Yellow Jade Beads
 Decorations
 Gemstone Beads
 Gemstone Beads (Agate)
 Your Current Location
 Gemstone Beads (Jasper)
 Gemstone Beads (Quartz)
 Coral Beads
 Turquoise Beads
 Crystal Beads
 Glass Beads
 Lampwork Beads
 Pearl Beads
 Porcelain Beads
 Shell Beads
 Wood Beads
 Indonesia Beads
 Finished Jewelry
 Jewelry Supplies & Findings