Thursday, 28 August 2008

• Sitemap
• Jewellery Forum
• GETi History
• Privacy Policy

Lost Password?

No account yet? Register

• Titanium Rings Home
• Contact
• GETi Rings
• Information

• Search For A Stockist
• GETi Special Offers
• Directory
• Jewellery Forum
• Recommend A Friend

Latest GETi Designs

4017RBSE  Call for Pricing

4067RBRN  Call for Pricing

Z127GRBMC  Call for Pricing

T091-RED  Call for Pricing

T036MC  Call for Pricing

Syndicate

Search Engine Results

Latest News

• Red Diamonds
• Be a GETi rep. for the day.
• Beat the GETi score
• Pebbles Jewellery
• Questions to ask a potential Titanium ring supplier.

Search For Products

Search

What's New?

GETi Point of Sale Display

GETi Titanium point of sale display bars now available to new and existing customers.

Read more...

 

Who's Online

Titanium Rings Home

GETi - Turning Titanium Into Profit   Tension set Cultured Red Diamond Need a date? We have one going spare for you! Check out this latest offering for finding the perfect partner from GETi    Could this tension set ring be the most technologically advanced item of jewellery on the planet? more>> :: Why Are GETi The UK's Leading Manufacturer of High Quality Black Zirconium and Titanium Rings? Titanium Rings The latest technology combined with hand craftsmanship and high quality materials guarantees your rings will stand the test of time and retain customer confidence. Standard and bespoke designs ensure that your customers are never stuck for choice. No minimum trade orders allows you to top up your shop stock without breaking the bank.    Regular design updates keep your display looking fresh and exciting. If you are interested in our products and would like to become a stockist - call us now on +44(0)121 507 0994 or email This e-mail address is being protected from spam bots, you need JavaScript enabled to view it New Initiative!! ARE YOU having trouble finding a local stockist of GETi Titanium and Black Zirconium rings - this may help.   more>>  Morse Code Rings NEW! LOVE is in the air. Valentines day has come and gone -but still, seize the moment. Don't tell the object of your desire that you love him (or her for that matter), let them work it out for themselves with a morse code ring by GETi. Got an ex-partner? Send them a parting gift of a GETi morse code ring with the cleverly encrypted swear word of your choice and let them work out for themselves what you think of them! Register here on the site. Looking for Titanium rings? Questions to ask a potential Titanium ring supplier. More >> The truth about GETi Titanium rings.     Mens rings - Established for over 40 years, Birmingham custom Black Zirconium and Titanium ring manufacturers, GETi, are at the forefront of modern, unique, contemporary jewellery design. Delivering a high quality product combined with innovative designs and excellent service makes GETi the UKs leading brand of quality Titanium and Black Zirconium mens rings. Rings in Palladium, Gold, Silver and Platinum also made.          Search the GETi stockists directory by county, town or directly by name. Highlight the 'Exact Phrase' radio button to get more precise results.    What's happening at GETi? Find out about new products, holiday periods, and new services etc. Check out our new laser engraver.  |  Latest Designs Hot Off The Press!!  |  Write a Story with GETi | The GETi Community Forum. New! | Check out the first new design for March 2008     Check out our featured stockist - this month: Claire Troughton Contemporary Jewellery And Gifts, Handbridge, Chester.   Special offer on website building from GETi - order your e-commerce site and get a second content magagement system website worth £2500 for £500 Why every small business needs a content management system website.   Are you in need of a few stocking fillers for Christmas? Check out our amazing special offers and promotions while they last! I know Christmas has gone, but I like this little cartoon fella so I'm leaving him on - the special offers are still running anyway! Read more...

The GETi Website At A Glance  Click on the quick links below or visit our sitemap for a more indepth look. Titanium and Black Zirconium Rings all categories Information and Articles Contact GETi Titanium Forum Search for a stockist News Special Offers Latest Designs Gallery Best Sellers Galleries Frequently Asked Questions Locate GETi on a map of the Birmingham Jewellery Quarter.   Andrew Geoghegan                    GETi Titanium Rings “A private customer requested a platinum wedding ring with a black zirconium inlay. As my workshops are unable to work with zirconium I contacted GETi and gave them the details of the piece. Within a short time I had a ring which was exactly as I had requested and my customer was delighted with the results. The team at GETi are professional and work to high standards which is essential for my business to operate effectively.”   Andrew Geoghegan. 2005 and 2007 Designer of the Year Finalist. Ring details: Flat top Platinum Band with inside comfort fit and a 3mm central Black Zirconium inlay - Pure luxury by GETi. Satin or polished. (Heavyweight)   Read more...

More... Precious Metal And Passionate People

<< Start < Prev 1 2 Next > End >>

Results 1 - 4 of 7

1
SELECT folder, element, published, params
 FROM stockists_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT folder, element, published, params
 FROM stockists_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'sefpatch'
 ORDER BY ordering
3
SELECT `id`,`link` FROM stockists_menu WHERE `menutype` = 'mainmenu' AND `published` > 0 AND `link` LIKE '%com_frontpage%' LIMIT 1
4
SELECT id FROM stockists_mambots WHERE element = 'joomsef_metabot' AND folder = 'system' AND published = 1
5
SELECT * FROM stockists_redirection WHERE oldurl = '' OR oldurl = 'index.php' LIMIT 1
6
SELECT template
 FROM stockists_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM stockists_session
 WHERE (
 ( time < '1219961969' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1219961969' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT id FROM stockists_mambots WHERE element = 'joomsef_metabot' AND folder = 'system'
9
SELECT *
 FROM stockists_mambots
 WHERE id = '29'
10
SELECT template
 FROM stockists_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
11
SELECT COUNT(*)
 FROM stockists_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
12
UPDATE stockists_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
13
SELECT COUNT(*)
 FROM stockists_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
14
UPDATE stockists_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
15
SELECT COUNT(*)
 FROM stockists_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
16
UPDATE stockists_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
17
SELECT *
 FROM stockists_menu
 WHERE id = 1
18
SELECT COUNT(a.id)
 FROM stockists_content AS a
 INNER JOIN stockists_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN stockists_categories AS cc ON cc.id = a.catid
 INNER JOIN stockists_sections AS s ON s.id = a.sectionid
 LEFT JOIN stockists_users AS u ON u.id = a.created_by
 LEFT JOIN stockists_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-08-28 23:34' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-08-28 23:34' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
19
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 FROM stockists_content AS a
 INNER JOIN stockists_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN stockists_categories AS cc ON cc.id = a.catid
 INNER JOIN stockists_sections AS s ON s.id = a.sectionid
 LEFT JOIN stockists_users AS u ON u.id = a.created_by
 LEFT JOIN stockists_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-08-28 23:34' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-08-28 23:34' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  f.ordering
LIMIT 4
20
SELECT *
 FROM stockists_sefexts
 WHERE file = 'com_content.xml'
21
SELECT folder, element, published, params
 FROM stockists_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
22
SELECT params
 FROM stockists_mambots
 WHERE element = 'mosimage'
 AND folder = 'content'
23
SELECT params
 FROM stockists_mambots
 WHERE element = 'socialbookmarkerbot'
 AND folder = 'content'
24
SELECT id 
 FROM `stockists_menu` 
 WHERE `menutype`='mainmenu'
 AND `published` =1
 ORDER BY `ordering` ASC 
 LIMIT 0, 1
25
SELECT id FROM stockists_mambots WHERE element = 'plugin_jw_sig' AND folder = 'content'
26
SELECT *
 FROM stockists_mambots
 WHERE id = '22'
27
SELECT id
 FROM stockists_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
28
SELECT *
 FROM stockists_mambots
 WHERE id = '20'
29
SELECT params
 FROM stockists_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
30
SELECT params
 FROM stockists_mambots
 WHERE element = 'socialbookmarkerbot'
 AND folder = 'content'
31
SELECT id 
 FROM `stockists_menu` 
 WHERE `menutype`='mainmenu'
 AND `published` =1
 ORDER BY `ordering` ASC 
 LIMIT 0, 1
32
SELECT id FROM stockists_mambots WHERE element = 'plugin_jw_sig' AND folder = 'content'
33
SELECT *
 FROM stockists_mambots
 WHERE id = '22'
34
SELECT id
 FROM stockists_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
35
SELECT *
 FROM stockists_mambots
 WHERE id = '20'
36
SELECT params
 FROM stockists_mambots
 WHERE element = 'socialbookmarkerbot'
 AND folder = 'content'
37
SELECT id 
 FROM `stockists_menu` 
 WHERE `menutype`='mainmenu'
 AND `published` =1
 ORDER BY `ordering` ASC 
 LIMIT 0, 1
38
SELECT id FROM stockists_mambots WHERE element = 'plugin_jw_sig' AND folder = 'content'
39
SELECT *
 FROM stockists_mambots
 WHERE id = '22'
40
SELECT id
 FROM stockists_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
41
SELECT *
 FROM stockists_mambots
 WHERE id = '20'
42
SELECT *
 FROM stockists_sefexts
 WHERE file = 'com_frontpage.xml'
43
SELECT m.* FROM stockists_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
44
SELECT m.* FROM stockists_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
45
SELECT m.* FROM stockists_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
46
SELECT m.* FROM stockists_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
47
SELECT id, title, module, position, content, showtitle, params
 FROM stockists_modules AS m
 INNER JOIN stockists_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 1 )
 ORDER BY ordering
48
SELECT a.*
 FROM stockists_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
49
SELECT *
 FROM stockists_sefexts
 WHERE file = 'com_joomap.xml'
50
SELECT id
 FROM stockists_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
51
SELECT *
 FROM stockists_sefexts
 WHERE file = 'com_registration.xml'
52
SELECT oldurl FROM stockists_redirection WHERE newurl = 'index.php?option=com_frontpage' AND Itemid = '1'
53
SELECT oldurl FROM stockists_redirection WHERE newurl = 'index.php?option=com_frontpage' AND Itemid = '1'
54
SELECT newurl, Itemid FROM stockists_redirection WHERE oldurl = ''
55
SELECT oldurl FROM stockists_redirection WHERE newurl = 'index.php?option=com_frontpage' AND Itemid = '1'
56
SELECT oldurl FROM stockists_redirection WHERE newurl = 'index.php?option=com_frontpage' AND Itemid = '1'
57
SELECT newurl, Itemid FROM stockists_redirection WHERE oldurl = ''
58
SELECT *
 FROM stockists_sefexts
 WHERE file = 'com_contact.xml'
59
SELECT *
 FROM stockists_sefexts
 WHERE file = 'com_virtuemart.xml'
60
SELECT *
 FROM stockists_banner
 WHERE showBanner=1 
 AND ( cid=26 )
61
UPDATE stockists_banner
 SET impmade = impmade + 1
 WHERE bid = 26
62
SELECT *
 FROM stockists_sefexts
 WHERE file = 'com_banners.xml'
63
SELECT *
 FROM stockists_sefexts
 WHERE file = 'com_search.xml'
64
SELECT *
 FROM stockists_banner
 WHERE showBanner=1 
 AND ( cid=1 )
65
UPDATE stockists_banner
 SET impmade = impmade + 1
 WHERE bid = 25
66
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
			vendor_address_1, 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
		FROM (`stockists_vm_vendor`, `stockists_vm_country`)
		WHERE `vendor_id`=1
		AND (vendor_country=country_2_code OR vendor_country=country_3_code);
67
SELECT stockists_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount 
    		FROM `stockists_vm_shopper_group` WHERE stockists_vm_shopper_group.vendor_id='1' AND `default`='1'
68
SELECT `name` FROM `stockists_core_acl_aro_groups` WHERE `group_id` =29
69
SELECT `lft`, `rgt` FROM `stockists_core_acl_aro_groups` WHERE `name`='Author'
70
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM stockists_core_acl_aro_groups AS g1
INNER JOIN stockists_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 5 AND 10
GROUP BY g1.name
ORDER BY g1.lft
71
SELECT `lft`, `rgt` FROM `stockists_core_acl_aro_groups` WHERE `name`='Public Backend'
72
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM stockists_core_acl_aro_groups AS g1
INNER JOIN stockists_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
73
SELECT DISTINCT product_sku FROM stockists_vm_product, stockists_vm_product_category_xref, stockists_vm_category WHERE product_parent_id=''AND stockists_vm_product.product_id=stockists_vm_product_category_xref.product_id AND stockists_vm_category.category_id=stockists_vm_product_category_xref.category_id AND stockists_vm_product.product_publish='Y' ORDER BY stockists_vm_product.product_id DESC LIMIT 0, 5
74
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM stockists_vm_product WHERE product_sku='4017RBSE'
75
SELECT stockists_vm_category.category_id FROM stockists_vm_category,stockists_vm_product_category_xref WHERE product_id='198' AND stockists_vm_category.category_id = stockists_vm_product_category_xref.category_id
76
SELECT
                                `stockists_vm_product`.`product_parent_id` AS product_parent_id,
                                `stockists_vm_category`.`category_flypage`
                        FROM
                                `stockists_vm_product`

                        LEFT JOIN `stockists_vm_product_category_xref` ON `stockists_vm_product_category_xref`.`product_id` = `stockists_vm_product`.`product_id`
                        LEFT JOIN `stockists_vm_category` ON `stockists_vm_product_category_xref`.`category_id` = `stockists_vm_category`.`category_id`

                        WHERE `stockists_vm_product`.`product_id`='198'
77
SELECT id FROM stockists_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
78
SELECT  product_id, `product_name` FROM stockists_vm_product WHERE product_id='198'
79
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM stockists_vm_product WHERE product_sku='4067RBRN'
80
SELECT stockists_vm_category.category_id FROM stockists_vm_category,stockists_vm_product_category_xref WHERE product_id='197' AND stockists_vm_category.category_id = stockists_vm_product_category_xref.category_id
81
SELECT
                                `stockists_vm_product`.`product_parent_id` AS product_parent_id,
                                `stockists_vm_category`.`category_flypage`
                        FROM
                                `stockists_vm_product`

                        LEFT JOIN `stockists_vm_product_category_xref` ON `stockists_vm_product_category_xref`.`product_id` = `stockists_vm_product`.`product_id`
                        LEFT JOIN `stockists_vm_category` ON `stockists_vm_product_category_xref`.`category_id` = `stockists_vm_category`.`category_id`

                        WHERE `stockists_vm_product`.`product_id`='197'
82
SELECT  product_id, `product_name` FROM stockists_vm_product WHERE product_id='197'
83
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM stockists_vm_product WHERE product_sku='Z127GRBMC'
84
SELECT stockists_vm_category.category_id FROM stockists_vm_category,stockists_vm_product_category_xref WHERE product_id='196' AND stockists_vm_category.category_id = stockists_vm_product_category_xref.category_id
85
SELECT
                                `stockists_vm_product`.`product_parent_id` AS product_parent_id,
                                `stockists_vm_category`.`category_flypage`
                        FROM
                                `stockists_vm_product`

                        LEFT JOIN `stockists_vm_product_category_xref` ON `stockists_vm_product_category_xref`.`product_id` = `stockists_vm_product`.`product_id`
                        LEFT JOIN `stockists_vm_category` ON `stockists_vm_product_category_xref`.`category_id` = `stockists_vm_category`.`category_id`

                        WHERE `stockists_vm_product`.`product_id`='196'
86
SELECT  product_id, `product_name` FROM stockists_vm_product WHERE product_id='196'
87
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM stockists_vm_product WHERE product_sku='T091-RED'
88
SELECT stockists_vm_category.category_id FROM stockists_vm_category,stockists_vm_product_category_xref WHERE product_id='195' AND stockists_vm_category.category_id = stockists_vm_product_category_xref.category_id
89
SELECT
                                `stockists_vm_product`.`product_parent_id` AS product_parent_id,
                                `stockists_vm_category`.`category_flypage`
                        FROM
                                `stockists_vm_product`

                        LEFT JOIN `stockists_vm_product_category_xref` ON `stockists_vm_product_category_xref`.`product_id` = `stockists_vm_product`.`product_id`
                        LEFT JOIN `stockists_vm_category` ON `stockists_vm_product_category_xref`.`category_id` = `stockists_vm_category`.`category_id`

                        WHERE `stockists_vm_product`.`product_id`='195'
90
SELECT  product_id, `product_name` FROM stockists_vm_product WHERE product_id='195'
91
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM stockists_vm_product WHERE product_sku='T036MC'
92
SELECT stockists_vm_category.category_id FROM stockists_vm_category,stockists_vm_product_category_xref WHERE product_id='194' AND stockists_vm_category.category_id = stockists_vm_product_category_xref.category_id
93
SELECT
                                `stockists_vm_product`.`product_parent_id` AS product_parent_id,
                                `stockists_vm_category`.`category_flypage`
                        FROM
                                `stockists_vm_product`

                        LEFT JOIN `stockists_vm_product_category_xref` ON `stockists_vm_product_category_xref`.`product_id` = `stockists_vm_product`.`product_id`
                        LEFT JOIN `stockists_vm_category` ON `stockists_vm_product_category_xref`.`category_id` = `stockists_vm_category`.`category_id`

                        WHERE `stockists_vm_product`.`product_id`='194'
94
SELECT  product_id, `product_name` FROM stockists_vm_product WHERE product_id='194'
95
SELECT *
 FROM stockists_sefexts
 WHERE file = 'com_rss.xml'
96
SELECT a.id, a.title, a.sectionid, a.catid
 FROM stockists_content AS a
 LEFT JOIN stockists_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN stockists_categories AS cc ON cc.id = a.catid
 INNER JOIN stockists_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-08-28 23:34' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-08-28 23:34' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 5
97
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM stockists_content AS i
 LEFT JOIN stockists_sections AS s ON i.sectionid = s.id
 LEFT JOIN stockists_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN stockists_categories AS c ON i.catid = c.id
 LEFT JOIN stockists_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 266
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
98
SELECT id 
 FROM stockists_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
99
SELECT id 
 FROM stockists_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
100
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM stockists_content AS i
 LEFT JOIN stockists_sections AS s ON i.sectionid = s.id
 LEFT JOIN stockists_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN stockists_categories AS c ON i.catid = c.id
 LEFT JOIN stockists_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 265
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
101
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM stockists_content AS i
 LEFT JOIN stockists_sections AS s ON i.sectionid = s.id
 LEFT JOIN stockists_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN stockists_categories AS c ON i.catid = c.id
 LEFT JOIN stockists_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 264
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
102
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM stockists_content AS i
 LEFT JOIN stockists_sections AS s ON i.sectionid = s.id
 LEFT JOIN stockists_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN stockists_categories AS c ON i.catid = c.id
 LEFT JOIN stockists_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 263
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
103
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM stockists_content AS i
 LEFT JOIN stockists_sections AS s ON i.sectionid = s.id
 LEFT JOIN stockists_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN stockists_categories AS c ON i.catid = c.id
 LEFT JOIN stockists_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 262
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
104
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM stockists_content AS a
 INNER JOIN stockists_categories AS cc ON cc.id = a.catid
 INNER JOIN stockists_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-08-28 23:34' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-08-28 23:34' )
 AND a.catid = 7
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
LIMIT 10
105
SELECT id FROM stockists_mambots WHERE element = 'plugin_jw_sig' AND folder = 'content'
106
SELECT *
 FROM stockists_mambots
 WHERE id = '22'
107
SELECT id
 FROM stockists_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
108
SELECT *
 FROM stockists_mambots
 WHERE id = '20'
109
SELECT guest, usertype
 FROM stockists_session
110
SELECT id, name, link, parent, type, menutype, access
 FROM stockists_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
111
SELECT *
 FROM stockists_banner
 WHERE showBanner=1
112
UPDATE stockists_banner
 SET impmade = impmade + 1
 WHERE bid = 10