Home arrow Dress Shirts arrow Dress Shirts
Info: Your browser does not accept cookies. To put products into your cart and purchase them you need to enable cookies.
Print

Dress Shirts

All shirts are not created equal. Our high quality fabrics are carefully selected and matched with durable color fast thread and high density buttons. Expert craftsmanship is the final step in producing a superior garment. We make every effort to insure that our shirts look amazing out of the box and after the dry cleaner as well.


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

Results 1 - 13 of 13

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


Display #  
Results 1 - 13 of 13
 
172 queries executed
1
SET sql_mode = 'MYSQL40'
2 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering
3 SELECT `id`,`link` FROM jos_menu WHERE ((`name` LIKE '%dress shirts%') AND (`published` > 0))
4 SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'dress-shirts/vmchk.html' ORDER BY rank ASC LIMIT 1
5 UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=66&lang=en&vmcchk=1' AND `oldurl` = 'dress-shirts/vmchk.html'
6 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 66 ) ORDER BY menuid DESC LIMIT 1
7 DELETE FROM jos_session WHERE ( ( time < '1455070677' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1455070677' ) AND guest = 1 AND userid = 0 )
8 SELECT * FROM jos_menu WHERE id = 66
9 SELECT group_id,group_name,group_level FROM `jos_vm_auth_group` ORDER BY group_level
10 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'
11 SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
12 SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
13 SELECT g1.group_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
14 SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
15 SELECT g1.group_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
16 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, vendor_accepted_currencies, vendor_address_format, vendor_date_format FROM (`jos_vm_vendor`, `jos_vm_country`) WHERE `vendor_id`=1 AND (vendor_country=country_2_code OR vendor_country=country_3_code);
17 SELECT params FROM jos_menu WHERE id='66'
18 SELECT module_perms FROM jos_vm_module where module_name='shop'
19 SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1
20 SELECT COUNT(user_id) as num_rows FROM `jos_vm_user_info` WHERE jos_vm_user_info.user_id='0' AND jos_vm_user_info.address_type='BT'
21 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`=1 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') OR (`product_parent_id`='')) AND `product_publish`='Y' AND `category_publish`='Y'
22 SELECT category_id, category_name FROM jos_vm_category WHERE category_id='1'
23 SELECT category_id, category_description FROM jos_vm_category WHERE category_id='1'
24 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='1' 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
25 SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
26 SELECT category_id, category_name,category_parent_id FROM jos_vm_category, jos_vm_category_xref WHERE jos_vm_category_xref.category_child_id='1' AND jos_vm_category.category_id='1'
27 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`=1 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') OR (`product_parent_id`='')) AND `product_publish`='Y' AND `category_publish`='Y' GROUP BY `jos_vm_product`.`product_sku` ORDER BY `jos_vm_product`.`product_name` ASC LIMIT 0, 30
28 SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=23
29 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='23' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
30 SELECT product_parent_id FROM jos_vm_product WHERE product_id=23
31 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
32 SELECT vendor_id FROM jos_vm_product WHERE product_id='23'
33 SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
34 SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=23 AND shopper_group_id=5 ORDER BY price_quantity_start
35 SELECT * FROM `jos_vm_product_files` WHERE `file_product_id`=23 AND `file_published`=1
36 SELECT votes, allvotes, rating FROM jos_vm_product_votes WHERE product_id='23'
37 SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=23
38 SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=23
39 SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=8
40 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='8' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
41 SELECT product_parent_id FROM jos_vm_product WHERE product_id=8
42 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
43 SELECT vendor_id FROM jos_vm_product WHERE product_id='8'
44 SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=8 AND shopper_group_id=5 ORDER BY price_quantity_start
45 SELECT * FROM `jos_vm_product_files` WHERE `file_product_id`=8 AND `file_published`=1
46 SELECT votes, allvotes, rating FROM jos_vm_product_votes WHERE product_id='8'
47 SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=8
48 SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=8
49 SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=11
50 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='11' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
51 SELECT product_parent_id FROM jos_vm_product WHERE product_id=11
52 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
53 SELECT vendor_id FROM jos_vm_product WHERE product_id='11'
54 SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=11 AND shopper_group_id=5 ORDER BY price_quantity_start
55 SELECT * FROM `jos_vm_product_files` WHERE `file_product_id`=11 AND `file_published`=1
56 SELECT votes, allvotes, rating FROM jos_vm_product_votes WHERE product_id='11'
57 SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=11
58 SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=11
59 SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=13
60 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='13' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
61 SELECT product_parent_id FROM jos_vm_product WHERE product_id=13
62 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
63 SELECT vendor_id FROM jos_vm_product WHERE product_id='13'
64 SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=13 AND shopper_group_id=5 ORDER BY price_quantity_start
65 SELECT * FROM `jos_vm_product_files` WHERE `file_product_id`=13 AND `file_published`=1
66 SELECT votes, allvotes, rating FROM jos_vm_product_votes WHERE product_id='13'
67 SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=13
68 SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=13
69 SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=9
70 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='9' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
71 SELECT product_parent_id FROM jos_vm_product WHERE product_id=9
72 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
73 SELECT vendor_id FROM jos_vm_product WHERE product_id='9'
74 SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=9 AND shopper_group_id=5 ORDER BY price_quantity_start
75 SELECT * FROM `jos_vm_product_files` WHERE `file_product_id`=9 AND `file_published`=1
76 SELECT votes, allvotes, rating FROM jos_vm_product_votes WHERE product_id='9'
77 SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=9
78 SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=9
79 SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=12
80 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
81 SELECT product_parent_id FROM jos_vm_product WHERE product_id=12
82 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
83 SELECT vendor_id FROM jos_vm_product WHERE product_id='12'
84 SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=12 AND shopper_group_id=5 ORDER BY price_quantity_start
85 SELECT * FROM `jos_vm_product_files` WHERE `file_product_id`=12 AND `file_published`=1
86 SELECT votes, allvotes, rating FROM jos_vm_product_votes WHERE product_id='12'
87 SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=12
88 SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=12
89 SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=2
90 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='2' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
91 SELECT product_parent_id FROM jos_vm_product WHERE product_id=2
92 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
93 SELECT vendor_id FROM jos_vm_product WHERE product_id='2'
94 SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=2 AND shopper_group_id=5 ORDER BY price_quantity_start
95 SELECT * FROM `jos_vm_product_files` WHERE `file_product_id`=2 AND `file_published`=1
96 SELECT votes, allvotes, rating FROM jos_vm_product_votes WHERE product_id='2'
97 SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=2
98 SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=2
99 SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=3
100 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='3' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
101 SELECT product_parent_id FROM jos_vm_product WHERE product_id=3
102 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
103 SELECT vendor_id FROM jos_vm_product WHERE product_id='3'
104 SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=3 AND shopper_group_id=5 ORDER BY price_quantity_start
105 SELECT * FROM `jos_vm_product_files` WHERE `file_product_id`=3 AND `file_published`=1
106 SELECT votes, allvotes, rating FROM jos_vm_product_votes WHERE product_id='3'
107 SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=3
108 SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=3
109 SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=5
110 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='5' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
111 SELECT product_parent_id FROM jos_vm_product WHERE product_id=5
112 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
113 SELECT vendor_id FROM jos_vm_product WHERE product_id='5'
114 SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=5 AND shopper_group_id=5 ORDER BY price_quantity_start
115 SELECT * FROM `jos_vm_product_files` WHERE `file_product_id`=5 AND `file_published`=1
116 SELECT votes, allvotes, rating FROM jos_vm_product_votes WHERE product_id='5'
117 SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=5
118 SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=5
119 SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=10
120 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='10' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
121 SELECT product_parent_id FROM jos_vm_product WHERE product_id=10
122 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
123 SELECT vendor_id FROM jos_vm_product WHERE product_id='10'
124 SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=10 AND shopper_group_id=5 ORDER BY price_quantity_start
125 SELECT * FROM `jos_vm_product_files` WHERE `file_product_id`=10 AND `file_published`=1
126 SELECT votes, allvotes, rating FROM jos_vm_product_votes WHERE product_id='10'
127 SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=10
128 SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=10
129 SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=7
130 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='7' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
131 SELECT product_parent_id FROM jos_vm_product WHERE product_id=7
132 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
133 SELECT vendor_id FROM jos_vm_product WHERE product_id='7'
134 SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=7 AND shopper_group_id=5 ORDER BY price_quantity_start
135 SELECT * FROM `jos_vm_product_files` WHERE `file_product_id`=7 AND `file_published`=1
136 SELECT votes, allvotes, rating FROM jos_vm_product_votes WHERE product_id='7'
137 SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=7
138 SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=7
139 SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=4
140 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='4' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
141 SELECT product_parent_id FROM jos_vm_product WHERE product_id=4
142 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
143 SELECT vendor_id FROM jos_vm_product WHERE product_id='4'
144 SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=4 AND shopper_group_id=5 ORDER BY price_quantity_start
145 SELECT * FROM `jos_vm_product_files` WHERE `file_product_id`=4 AND `file_published`=1
146 SELECT votes, allvotes, rating FROM jos_vm_product_votes WHERE product_id='4'
147 SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=4
148 SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=4
149 SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=6
150 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='6' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
151 SELECT product_parent_id FROM jos_vm_product WHERE product_id=6
152 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1455071577' OR start_date=0) AND (end_date>='1455060960' OR end_date=0) AND product_discount_id=discount_id
153 SELECT vendor_id FROM jos_vm_product WHERE product_id='6'
154 SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=6 AND shopper_group_id=5 ORDER BY price_quantity_start
155 SELECT * FROM `jos_vm_product_files` WHERE `file_product_id`=6 AND `file_published`=1
156 SELECT votes, allvotes, rating FROM jos_vm_product_votes WHERE product_id='6'
157 SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=6
158 SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=6
159 SELECT DISTINCT product_sku,jos_vm_product.product_id,product_name,product_s_desc,product_thumb_image 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='1' AND jos_vm_product.product_publish='Y' AND jos_vm_product.product_special='Y' ORDER BY RAND() LIMIT 0, 10
160 SELECT a.* FROM jos_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'
161 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 = 0 OR mm.menuid = 66 ) ORDER BY ordering
162 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=login&lang=en'
163 SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt FROM jos_menu AS m LEFT JOIN jos_menu AS p ON p.parent = m.id WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= '0' GROUP BY m.id ORDER BY m.parent, m.ordering
164 SELECT m.* FROM jos_menu AS m WHERE menutype='mainmenu' AND m.published='1'
165 SELECT DISTINCT b.* FROM jos_bannersmanager_banner as b LEFT JOIN jos_bannersmanager_extension as e ON b.id = e.bannerid WHERE b.published=1 AND b.groupid = 2 AND (( b.menuid LIKE '%,66,%' OR b.menuid LIKE '%,0,%' ) OR (e.name ='com_virtuemart' AND ( e.value LIKE '%,1,%' OR e.value LIKE '%,0,%' ))) ORDER BY b.ordering ASC LIMIT 1
166 SELECT id, name, link, parent, type, menutype, access FROM jos_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering
167 SELECT DISTINCT b.* FROM jos_bannersmanager_banner as b LEFT JOIN jos_bannersmanager_extension as e ON b.id = e.bannerid WHERE b.published=1 AND b.groupid = 1 AND (( b.menuid LIKE '%,66,%' OR b.menuid LIKE '%,0,%' ) OR (e.name ='com_virtuemart' AND ( e.value LIKE '%,1,%' OR e.value LIKE '%,0,%' ))) ORDER BY b.ordering ASC LIMIT 1
168 UPDATE jos_bannersmanager_banner SET impmade = impmade + 1 WHERE id = 4
169 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_bannersmanager&bid=4&lang=en&task=click'
170 SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc FROM jos_vm_vendor
171 SELECT c.category_name, c.category_id, c.category_description, 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 WHERE c.category_publish = 'Y';
172 SELECT id, metadesc, metakey, metatitle, metalang, metarobots FROM jos_sh404SEF_meta WHERE newurl = 'index.php?option=com_virtuemart&Itemid=66&lang=en&vmcchk=1'