Home Home Contact Us News Links   Show Cart Your Cart is currently empty. Main Menu Home Our Online-Shop History Contact Us Information Shipping & Returns Privacy Terms of Use Office Locations Online-Shop Books (12) Tools (6) Satellite Software (2) Videos (8) Username Password Lost Password? No account yet? Register Show Cart Your Cart is currently empty. Name E-mail Subscribe Unsubscribe Featured Products 1998/2000 WORLD SATELLITE YEARLY $90.00 Earth Station Technology $595.00 Random Products WIRELESS CABLE and SMATV $50.00 Satellite Spacecraft $595.00 Welcome to Baylin Publications. Written by Frank Baylin    Friday, 27 January 2006 Welcome to the newly redesigned Baylin Publications website. "If we stock it - it's worth buying." Baylin Publications, a subsidiary of ConSol Network, Inc., was founded by Dr. Frank Baylin in 1981. His company is dedicated to publishing books, videos and software that make the technologies of satellite TV, private cable TV and wireless cable TV (MMDS) clear and understandable to technicians and laymen. Last Updated ( Wednesday, 15 March 2006 )   Effective Internet Searching Written by Frank Baylin    Friday, 27 January 2006 Our customers tell us that no one is doing a very good job with search right now. Our own internal data indicates 50 percent of search questions go unanswered. - Lisa Gurry, MSN director, March 22, 2004. This new book from Baylin Publications addresses will help you better use the web most popular search engines to quickly get the data you want. Last Updated ( Sunday, 29 January 2006 ) Read more...   Software Revolution Written by Frank Baylin    Friday, 27 January 2006 Baylin publications has sponsored a new book outlining the social, political and business implications of the Open Source software movement. There is a Revolution! happening at Bayli publications. Check back soon for more information on this one-of-a-kind book. Last Updated ( Thursday, 23 March 2006 )   Product Scroller HOME SATELLITE TV INSTALLATION & TROUBLESHOOTING MANUAL $30.00 Add to Cart THE MMDS (Wireless Cable) INSTALLATION MANUAL $40.00 Add to Cart SATELLITE TOOLBOX SOFTWARE $95.00 Add to Cart Effective Internet Searching $40.00 Add to Cart SILVA Compass/Inclinometer MC-1D $65.00 Add to Cart Latest products Effective Internet Searching $40.00 Add to Cart 2006 INTERNATIONAL SATELLITE DIRECTORY $495.00 Add to Cart

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering LIMIT 1
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
 LIMIT 1
4
DELETE FROM jos_session
 WHERE ( time < '1210374649' )
 AND guest = 0 
 AND gid > 0
5
DELETE FROM jos_session
 WHERE ( time < '1210374649' )
 AND guest = 1 
 AND userid = 0
6
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
7
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
10
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
11
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
12
SELECT access
 FROM jos_menu
 WHERE id = 1
13
SELECT *
 FROM jos_menu
 WHERE id = '1'
14
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,
 ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2008-05-09 16:25:49'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2008-05-09 16:25:49' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY  f.ordering
15
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
16
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
17
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
18
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
19
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, 
			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 (`jos_vm_vendor`, `jos_vm_country`)
		WHERE `vendor_id`=1
		AND (vendor_country=country_2_code OR vendor_country=country_3_code);
20
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'
21
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 13
22
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_categories AS cc ON i.catid = cc.id
 LEFT JOIN jos_menu AS m ON m.componentid = cc.id 
 WHERE m.type = 'content_category'
 AND m.published = 1
 AND i.id = 13
23
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 15
24
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_categories AS cc ON i.catid = cc.id
 LEFT JOIN jos_menu AS m ON m.componentid = cc.id 
 WHERE m.type = 'content_category'
 AND m.published = 1
 AND i.id = 15
25
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 14
26
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_categories AS cc ON i.catid = cc.id
 LEFT JOIN jos_menu AS m ON m.componentid = cc.id 
 WHERE m.type = 'content_category'
 AND m.published = 1
 AND i.id = 14
27
SELECT a.*
 FROM jos_components AS a
 WHERE a.name = 'Syndicate'
28
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_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 = '1' OR mm.menuid = 0 )
 ORDER BY ordering
29
SELECT id, name, link, parent, type, menutype
 FROM jos_menu
 WHERE published = 1
 ORDER BY menutype, parent, ordering
30
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
31
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
32
SELECT id, user_id from jos_users, jos_vm_user_info WHERE id='0' AND id=user_id AND address_type='BT' AND first_name != '' AND last_name != '' AND city != ''
33
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published='1'
34
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
35
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Information'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
36
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
37
SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='14' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  AND product_publish='Y'
38
SELECT category_child_id FROM jos_vm_category_xref WHERE category_parent_id='14'
39
SELECT category_child_id FROM jos_vm_category_xref WHERE category_parent_id='14'
40
SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='15' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  AND product_publish='Y'
41
SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='16' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  AND product_publish='Y'
42
SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='8' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  AND product_publish='Y'
43
SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='9' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  AND product_publish='Y'
44
SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='13' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  AND product_publish='Y'
45
SELECT category_child_id FROM jos_vm_category_xref WHERE category_parent_id='13'
46
SELECT category_child_id FROM jos_vm_category_xref WHERE category_parent_id='13'
47
SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='10' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  AND product_publish='Y'
48
SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='11' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  AND product_publish='Y'
49
SELECT id, user_id from jos_users, jos_vm_user_info WHERE id='0' AND id=user_id AND address_type='BT' AND first_name != '' AND last_name != '' AND city != ''
50
SELECT *
 FROM jos_users
 WHERE id = '0'
51
SELECT DISTINCT product_sku FROM jos_vm_product WHERE product_parent_id='' AND vendor_id='1' AND jos_vm_product.product_publish='Y' AND jos_vm_product.product_special='Y' ORDER BY product_name ASC LIMIT 0, 2
52
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='0-917893-32-8'
53
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='41' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
54
SELECT jos_vm_category.category_flypage FROM jos_vm_category, jos_vm_product_category_xref, jos_vm_product WHERE jos_vm_product.product_id='41' AND 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
55
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='41'
56
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='41' AND (start_date<='1210375549' OR start_date=0) AND (end_date>='1210314960' OR end_date=0) AND product_discount_id=discount_id
57
SELECT vendor_id FROM jos_vm_product WHERE product_id='41'
58
SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
59
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='41'
60
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='41' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
61
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='41'
62
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
63
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Design - 2'
64
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='39' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
65
SELECT jos_vm_category.category_flypage FROM jos_vm_category, jos_vm_product_category_xref, jos_vm_product WHERE jos_vm_product.product_id='39' AND 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
66
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='39'
67
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='39' AND (start_date<='1210375549' OR start_date=0) AND (end_date>='1210314960' OR end_date=0) AND product_discount_id=discount_id
68
SELECT vendor_id FROM jos_vm_product WHERE product_id='39'
69
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='39'
70
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='39' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
71
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='39'
72
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
73
SELECT DISTINCT product_sku FROM jos_vm_product WHERE product_parent_id='' AND vendor_id='1' AND jos_vm_product.product_publish='Y' ORDER BY product_name DESC
74
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='0-917893-17-4'
75
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='20' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
76
SELECT jos_vm_category.category_flypage FROM jos_vm_category, jos_vm_product_category_xref, jos_vm_product WHERE jos_vm_product.product_id='20' AND 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
77
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='20'
78
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='20' AND (start_date<='1210375549' OR start_date=0) AND (end_date>='1210314960' OR end_date=0) AND product_discount_id=discount_id
79
SELECT vendor_id FROM jos_vm_product WHERE product_id='20'
80
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='20'
81
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='20' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
82
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='20'
83
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='20' AND shopper_group_id='5'  ORDER BY price_quantity_start
84
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Design - 6'
85
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='38' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
86
SELECT jos_vm_category.category_flypage FROM jos_vm_category, jos_vm_product_category_xref, jos_vm_product WHERE jos_vm_product.product_id='38' AND 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
87
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='38'
88
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='38' AND (start_date<='1210375549' OR start_date=0) AND (end_date>='1210314960' OR end_date=0) AND product_discount_id=discount_id
89
SELECT vendor_id FROM jos_vm_product WHERE product_id='38'
90
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='38'
91
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='38' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
92
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='38'
93
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
94
SELECT p.product_sku FROM jos_vm_product AS p
 WHERE p.product_publish = 'Y' AND product_parent_id=0 
 ORDER BY RAND() LIMIT 5
95
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='0-917893-31-X'
96
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='43' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
97
SELECT jos_vm_category.category_flypage FROM jos_vm_category, jos_vm_product_category_xref, jos_vm_product WHERE jos_vm_product.product_id='43' AND 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
98
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='43'
99
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='43' AND (start_date<='1210375549' OR start_date=0) AND (end_date>='1210314960' OR end_date=0) AND product_discount_id=discount_id
100
SELECT vendor_id FROM jos_vm_product WHERE product_id='43'
101
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='43'
102
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='43' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
103
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='43'
104
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
105
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='0-917893-28-X'
106
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='45' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
107
SELECT jos_vm_category.category_flypage FROM jos_vm_category, jos_vm_product_category_xref, jos_vm_product WHERE jos_vm_product.product_id='45' AND 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
108
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='45'
109
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='45' AND (start_date<='1210375549' OR start_date=0) AND (end_date>='1210314960' OR end_date=0) AND product_discount_id=discount_id
110
SELECT vendor_id FROM jos_vm_product WHERE product_id='45'
111
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='45'
112
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='45' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
113
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='45'
114
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='45' AND shopper_group_id='5'  ORDER BY price_quantity_start
115
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Win-Aim'
116
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='31' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
117
SELECT jos_vm_category.category_flypage FROM jos_vm_category, jos_vm_product_category_xref, jos_vm_product WHERE jos_vm_product.product_id='31' AND 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
118
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='31'
119
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='31' AND (start_date<='1210375549' OR start_date=0) AND (end_date>='1210314960' OR end_date=0) AND product_discount_id=discount_id
120
SELECT vendor_id FROM jos_vm_product WHERE product_id='31'
121
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='31'
122
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='31' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
123
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='31'
124
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='31' AND shopper_group_id='5'  ORDER BY price_quantity_start
125
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Baylin Systems'
126
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='47' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
127
SELECT jos_vm_category.category_flypage FROM jos_vm_category, jos_vm_product_category_xref, jos_vm_product WHERE jos_vm_product.product_id='47' AND 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
128
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='47'
129
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='47' AND (start_date<='1210375549' OR start_date=0) AND (end_date>='1210314960' OR end_date=0) AND product_discount_id=discount_id
130
SELECT vendor_id FROM jos_vm_product WHERE product_id='47'
131
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='47'
132
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='47' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
133
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='47'
134
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='47' AND shopper_group_id='5'  ORDER BY price_quantity_start
135
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='BAY - 005'
136
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='25' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
137
SELECT jos_vm_category.category_flypage FROM jos_vm_category, jos_vm_product_category_xref, jos_vm_product WHERE jos_vm_product.product_id='25' AND 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
138
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='25'
139
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='25' AND (start_date<='1210375549' OR start_date=0) AND (end_date>='1210314960' OR end_date=0) AND product_discount_id=discount_id
140
SELECT vendor_id FROM jos_vm_product WHERE product_id='25'
141
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='25'
142
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='25' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
143
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='25'
144
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='25' AND shopper_group_id='5'  ORDER BY price_quantity_start
145
SELECT DISTINCT product_sku FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category WHERE product_parent_id=''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_product.product_publish='Y' ORDER BY jos_vm_product.product_id DESC LIMIT 0, 2
146
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Baylin Systems'
147
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='47' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
148
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='47'
149
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='47' AND shopper_group_id='5'  ORDER BY price_quantity_start
150
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Design Publishers'
151
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='46' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
152
SELECT jos_vm_category.category_flypage FROM jos_vm_category, jos_vm_product_category_xref, jos_vm_product WHERE jos_vm_product.product_id='46' AND 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
153
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='46'
154
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='46' AND (start_date<='1210375549' OR start_date=0) AND (end_date>='1210314960' OR end_date=0) AND product_discount_id=discount_id
155
SELECT vendor_id FROM jos_vm_product WHERE product_id='46'
156
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='46'
157
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='46' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
158
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='46'
159
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='46' AND shopper_group_id='5'  ORDER BY price_quantity_start