Natural Spring

SET NAMES 'utf8'

SELECT * FROM sg.users WHERE uid='4b0eaf1085b7d'

REPLACE DELAYED INTO sg.users_lastvisit (uid,last_visit,ip) VALUES ('4b0eaf1085b7d',NOW(),'38.107.191.102')

SELECT * FROM sg.store

SELECT short_name FROM store WHERE id=3

INSERT INTO search_history (search,uid,`when`) VALUES ('natural%20spring','4b0eaf1085b7d',NOW()) ON DUPLICATE KEY UPDATE `when`=NOW()

SELECT * FROM product_query WHERE id=3134

SELECT * FROM product_query_filter WHERE query_id=3134 ORDER BY id

SELECT short_name FROM store WHERE id=3

SELECT name,value FROM sg._users_settings WHERE uid='4b0eaf1085b7d'

SELECT _permissions.id,_permissions.name,_users_permissions.enabled,UNIX_TIMESTAMP(_users_permissions.expires) expires,UNIX_TIMESTAMP(_users_permissions.date_start) date_start FROM sg._permissions, sg._users_permissions WHERE _permissions.id=_users_permissions.permission_id AND _users_permissions.uid='4b0eaf1085b7d'

SELECT * FROM store_folders_landing WHERE folder_id=-1010 AND sid=3

SELECT * FROM store_folders_landing WHERE folder_id=-1011 AND sid=3

SELECT products.pid,products.description,sub_name,mybasket.qty,store_folders_company.name company_name,store_folders_line.name line_name FROM mybasket JOIN products ON (mybasket.item=products.pid) LEFT JOIN current_inventory ON (mybasket.item=current_inventory.pid) LEFT JOIN store_folders store_folders_company ON (store_folders_company.id=products.company) LEFT JOIN store_folders store_folders_line ON (store_folders_line.id=products.line) WHERE mybasket.uid='4b0eaf1085b7d' AND mybasket.sid=0 AND mybasket.bid=0 AND (current_inventory.count-current_inventory.pending > 0 OR (onpreorder-count_preordered>0 AND preorder_fee>0)) AND mybasket.qty>0 AND hide=0 ORDER BY mybasket.stamp DESC LIMIT 20

SELECT sum(if(preorder_fee>0,preorder_fee,if(products.currentsaleprice>0,products.currentsaleprice,products.sellingprice))*mybasket.qty) FROM mybasket JOIN current_inventory ON (mybasket.item=current_inventory.pid) JOIN products ON (mybasket.item=products.pid) WHERE mybasket.uid='4b0eaf1085b7d' AND mybasket.sid=0 AND mybasket.bid=0 AND (current_inventory.count-current_inventory.pending > 0 OR (onpreorder-count_preordered>0 AND preorder_fee>0)) AND products.hide=0

SELECT products.*,products.priv_notes,products.itemnumber,IF(currentsaleprice>0 AND currentsaleprice<sellingprice,currentsaleprice,sellingprice) AS real_price, floor(weight/16) AS weight_lbs,weight-(floor(weight/16)*16) AS weight_oz, concat_ws('-',products.aisle,products.rack) location, UNIX_TIMESTAMP(products.imagein) as imagein_stamp, products.company as companyid, products.line as lineid,products.subline as sublineid, products.type as typeid, products.subtype as subtypeid, products.artist as artistid, current_inventory.count, current_inventory.pending, current_inventory.onorder, current_inventory.onpreorder, current_inventory.available, current_inventory.infinite,current_inventory.lastsolddate,current_inventory.avg_cost, datediff(NOW(),date_ol) AS age, store_folders_company.name AS company_name, store_folders_line.name AS line_name, store_folders_subline.name AS subline_name, store_folders_artist.name AS artist_name, supplier_index.supplieritemnumber FROM products LEFT JOIN current_inventory ON (products.pid=current_inventory.pid) LEFT JOIN store_folders AS store_folders_company ON (store_folders_company.id=company) LEFT JOIN store_folders AS store_folders_line ON (store_folders_line.id=line) LEFT JOIN store_folders AS store_folders_subline ON (store_folders_subline.id=subline) LEFT JOIN store_folders AS store_folders_artist ON (store_folders_artist.id=artist) LEFT JOIN supplier_index ON (products.pid=supplier_index.pid)WHERE products.pid=9004722

SELECT cur.id,cur.name,sub_level,cat_type FROM store_folders AS cur JOIN product_cats USING (id) LEFT JOIN store_folders AS mast ON (cur.master=mast.id) LEFT JOIN store_folders AS mastmast ON (mast.master=mastmast.id) WHERE pid=9004722 ORDER BY IF(sub_level=1,cur.name,IF(sub_level=2,CONCAT(mast.name,'-',cur.name),CONCAT(mastmast.name,'-',mast.name,'-',cur.name)))

SELECT * FROM product_inventory WHERE pid=9004722

SELECT count(cid) as basket_count FROM mybasket WHERE item=9004722 AND stamp BETWEEN NOW()-INTERVAL 60 DAY AND NOW()

SELECT products.*,products.priv_notes,products.itemnumber,IF(currentsaleprice>0 AND currentsaleprice<sellingprice,currentsaleprice,sellingprice) AS real_price, floor(weight/16) AS weight_lbs,weight-(floor(weight/16)*16) AS weight_oz, concat_ws('-',products.aisle,products.rack) location, UNIX_TIMESTAMP(products.imagein) as imagein_stamp, products.company as companyid, products.line as lineid,products.subline as sublineid, products.type as typeid, products.subtype as subtypeid, products.artist as artistid, current_inventory.count, current_inventory.pending, current_inventory.onorder, current_inventory.onpreorder, current_inventory.available, current_inventory.infinite,current_inventory.lastsolddate,current_inventory.avg_cost, datediff(NOW(),date_ol) AS age, store_folders_company.name AS company_name, store_folders_line.name AS line_name, store_folders_subline.name AS subline_name, store_folders_artist.name AS artist_name, supplier_index.supplieritemnumber FROM products LEFT JOIN current_inventory ON (products.pid=current_inventory.pid) LEFT JOIN store_folders AS store_folders_company ON (store_folders_company.id=company) LEFT JOIN store_folders AS store_folders_line ON (store_folders_line.id=line) LEFT JOIN store_folders AS store_folders_subline ON (store_folders_subline.id=subline) LEFT JOIN store_folders AS store_folders_artist ON (store_folders_artist.id=artist) LEFT JOIN supplier_index ON (products.pid=supplier_index.pid)WHERE parent_pid=9004722 ORDER BY real_price

SELECT short_name FROM store WHERE id=3

SELECT * FROM product_query WHERE id=3134

SELECT * FROM product_query_filter WHERE query_id=3134 ORDER BY id

SELECT COUNT(*) ct FROM products JOIN product_related ON (product_related.to_pid=products.pid) JOIN current_inventory ON (current_inventory.pid=products.pid) WHERE (products.store & 8=8) AND (product_related.pid=9004722) AND (product_related.type=0) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) LIMIT 32

SELECT COUNT(*) ct FROM products JOIN product_related ON (product_related.to_pid=products.pid) JOIN current_inventory ON (current_inventory.pid=products.pid) WHERE (products.store & 8=8) AND (product_related.pid=9004722) AND (product_related.type=0) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) LIMIT 32

SELECT * FROM product_query WHERE id=3134

SELECT * FROM product_query_filter WHERE query_id=3134 ORDER BY id

SELECT products.pid,products.itemnumber,products.description,products.sellingprice,products.currentsaleprice,products.sale,products.score,products.aisle,products.rack,products.hook,current_inventory.available,current_inventory.onorder,current_inventory.onpreorder,datediff(NOW(),date_ol) age,products.downloadable FROM products JOIN product_related ON (product_related.to_pid=products.pid) JOIN current_inventory ON (current_inventory.pid=products.pid) WHERE (product_related.pid=9004722) AND (product_related.type=1) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) ORDER BY products.score ASC LIMIT 18

SELECT products.pid,products.itemnumber,products.description,products.sellingprice,products.currentsaleprice,products.sale,products.score,products.aisle,products.rack,products.hook,current_inventory.available,current_inventory.onorder,current_inventory.onpreorder,datediff(NOW(),date_ol) age,products.downloadable FROM products JOIN product_related ON (product_related.to_pid=products.pid) JOIN current_inventory ON (current_inventory.pid=products.pid) WHERE (product_related.pid=9004722) AND (product_related.type=1) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) ORDER BY products.score ASC LIMIT 18

select user_images.id,user_images.image_type,gallery_index.gallery_id,gallery.title FROM gallery JOIN gallery_index ON (gallery.id=gallery_index.gallery_id) JOIN user_images ON (gallery_index.gallery_id=user_images.gallery_id) WHERE index_type=3 and category_id=9004722 AND gallery.datecreated <= NOW() GROUP BY gallery_index.gallery_id DESC LIMIT 16

select user_images.id,user_images.image_type,gallery_index.gallery_id,gallery.title FROM gallery JOIN gallery_index ON (gallery.id=gallery_index.gallery_id) JOIN user_images ON (gallery_index.gallery_id=user_images.gallery_id) WHERE index_type=3 and category_id=9004722 AND gallery.datecreated <= NOW() GROUP BY gallery_index.gallery_id DESC LIMIT 16

SELECT * FROM hunt_what WHERE NOW()>=date_start AND enabled=1 ORDER BY date_start DESC LIMIT 1

SELECT match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*') as rank,store_folders.name AS artist, 0 AS the_sub_level,store_folders.id,store_folders.name,COUNT(*) ct FROM products JOIN current_inventory ON (current_inventory.pid=products.pid) JOIN store_folders ON (store_folders.id=products.artist) WHERE (products.store & 8=8) AND ((match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*' IN BOOLEAN MODE))) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) GROUP BY products.artist ORDER BY store_folders.name

SELECT match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*') as rank,store_folders.id,store_folders.name,COUNT(*) ct FROM products JOIN current_inventory ON (current_inventory.pid=products.pid) JOIN product_cats AS gb_product_cats ON (products.pid=gb_product_cats.pid) JOIN store_folders ON (store_folders.id=gb_product_cats.id AND gb_product_cats.cat_type=1 AND gb_product_cats.sub_level=1) WHERE (products.store & 8=8) AND ((match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*' IN BOOLEAN MODE))) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) GROUP BY gb_product_cats.id ORDER BY store_folders.name

SELECT match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*') as rank,store_folders.id,store_folders.name,COUNT(*) ct FROM products JOIN current_inventory ON (current_inventory.pid=products.pid) JOIN product_cats AS gb_product_cats ON (products.pid=gb_product_cats.pid) JOIN store_folders ON (store_folders.id=gb_product_cats.id AND gb_product_cats.cat_type=1 AND gb_product_cats.sub_level=1) WHERE (products.store & 8=8) AND ((match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*' IN BOOLEAN MODE))) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) GROUP BY gb_product_cats.id ORDER BY store_folders.name

SELECT match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*') as rank,store_folders.id,store_folders.name,COUNT(*) ct FROM products JOIN current_inventory ON (current_inventory.pid=products.pid) JOIN product_cats AS gb_product_cats ON (products.pid=gb_product_cats.pid) JOIN store_folders ON (store_folders.id=gb_product_cats.id AND gb_product_cats.cat_type=2 AND gb_product_cats.sub_level=0) WHERE (products.store & 8=8) AND ((match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*' IN BOOLEAN MODE))) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) GROUP BY gb_product_cats.id ORDER BY store_folders.name

SELECT match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*') as rank,store_folders.id,store_folders.name,COUNT(*) ct FROM products JOIN current_inventory ON (current_inventory.pid=products.pid) JOIN product_cats AS gb_product_cats ON (products.pid=gb_product_cats.pid) JOIN store_folders ON (store_folders.id=gb_product_cats.id AND gb_product_cats.cat_type=2 AND gb_product_cats.sub_level=0) WHERE (products.store & 8=8) AND ((match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*' IN BOOLEAN MODE))) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) GROUP BY gb_product_cats.id ORDER BY store_folders.name

SELECT products.*,products.priv_notes,products.itemnumber,IF(currentsaleprice>0 AND currentsaleprice<sellingprice,currentsaleprice,sellingprice) AS real_price, floor(weight/16) AS weight_lbs,weight-(floor(weight/16)*16) AS weight_oz, concat_ws('-',products.aisle,products.rack) location, UNIX_TIMESTAMP(products.imagein) as imagein_stamp, products.company as companyid, products.line as lineid,products.subline as sublineid, products.type as typeid, products.subtype as subtypeid, products.artist as artistid, current_inventory.count, current_inventory.pending, current_inventory.onorder, current_inventory.onpreorder, current_inventory.available, current_inventory.infinite,current_inventory.lastsolddate,current_inventory.avg_cost, datediff(NOW(),date_ol) AS age, store_folders_company.name AS company_name, store_folders_line.name AS line_name, store_folders_subline.name AS subline_name, store_folders_artist.name AS artist_name, supplier_index.supplieritemnumber FROM products LEFT JOIN current_inventory ON (products.pid=current_inventory.pid) LEFT JOIN store_folders AS store_folders_company ON (store_folders_company.id=company) LEFT JOIN store_folders AS store_folders_line ON (store_folders_line.id=line) LEFT JOIN store_folders AS store_folders_subline ON (store_folders_subline.id=subline) LEFT JOIN store_folders AS store_folders_artist ON (store_folders_artist.id=artist) LEFT JOIN supplier_index ON (products.pid=supplier_index.pid)WHERE parent_pid=9004722 ORDER BY real_price

SELECT products.*,products.priv_notes,products.itemnumber,IF(currentsaleprice>0 AND currentsaleprice<sellingprice,currentsaleprice,sellingprice) AS real_price, floor(weight/16) AS weight_lbs,weight-(floor(weight/16)*16) AS weight_oz, concat_ws('-',products.aisle,products.rack) location, UNIX_TIMESTAMP(products.imagein) as imagein_stamp, products.company as companyid, products.line as lineid,products.subline as sublineid, products.type as typeid, products.subtype as subtypeid, products.artist as artistid, current_inventory.count, current_inventory.pending, current_inventory.onorder, current_inventory.onpreorder, current_inventory.available, current_inventory.infinite,current_inventory.lastsolddate,current_inventory.avg_cost, datediff(NOW(),date_ol) AS age, store_folders_company.name AS company_name, store_folders_line.name AS line_name, store_folders_subline.name AS subline_name, store_folders_artist.name AS artist_name, supplier_index.supplieritemnumber FROM products LEFT JOIN current_inventory ON (products.pid=current_inventory.pid) LEFT JOIN store_folders AS store_folders_company ON (store_folders_company.id=company) LEFT JOIN store_folders AS store_folders_line ON (store_folders_line.id=line) LEFT JOIN store_folders AS store_folders_subline ON (store_folders_subline.id=subline) LEFT JOIN store_folders AS store_folders_artist ON (store_folders_artist.id=artist) LEFT JOIN supplier_index ON (products.pid=supplier_index.pid)WHERE parent_pid=9004722 ORDER BY real_price