• Accueil
• Rechercher
• BOUTIQUE
• Infos
  • Conditions de vente
  • Modalités paiement
• Contact

Bienvenue Lire la suite...   Nouveautés TELECOMMANDE RVB 19.00 € Ajouter au panier spherique leds e14 22.00 € Ajouter au panier Projecteur Solaire jardin 25.80 € Ajouter au panier POTELET INOX 24.00 € Ajouter au panier PLAFONIER HALOGENE 25.40 € Ajouter au panier MR16 12V ECO 1.85 € Ajouter au panier LUMINAIRE SECOURS 18W 34.90 € Ajouter au panier LUMINAIRE ALUMINIUM 59.00 € Ajouter au panier LOT de 100 SPHERIQUES COULEUR 19.00 € Ajouter au panier LOT 4 DETECT INCENDIE 59.00 € Ajouter au panier Lampe mr16 leds 12v 4.98 € Ajouter au panier LAMPE DICHRO 12V HALOG GE 4.50 € Ajouter au panier Lampe de Parasol led 16.80 € Ajouter au panier LAMPE CREE 3W 12V 29.00 € Ajouter au panier LAMPE 4 LEDS 47.80 € Ajouter au panier KIT 3SPOTS ENCASTRE 21.50 € Ajouter au panier IODURE METALLIQUE G12 49.00 € Ajouter au panier HUBLOT INOX 29.30 € Ajouter au panier Flexled adhésive 29.00 € Ajouter au panier Embout robinet a leds ABS 19.00 € Ajouter au panier ECOR7S 11.00 € Ajouter au panier CAMERA N/B SURVEILANCE 46.00 € Ajouter au panier BOITIER DMX 69.00 € Ajouter au panier Bande Leds 3 leds etanche 3.90 € Ajouter au panier BANDE DE LEDS 5 METRES 210.00 € Ajouter au panier APPLIQUE TORCHE INOX 29.00 € Ajouter au panier APPLIQUE INOX 39.00 € Ajouter au panier APPLIQUE HALOGENE 2SPOTS 29.90 € Ajouter au panier APPLIQUE 3 SPOTS 33.00 € Ajouter au panier Alarme pour enfants 95.00 € Ajouter au panier

Promotions SPOT HALOG ECO 24W 49.90 € Ajouter au panier ROBINET LUMINEUX 39.90 € Ajouter au panier Lampe rvb télécommandée 59.00 € Ajouter au panier PAR 38 ALED 1.8W 34.00 € Ajouter au panier APPLIQUE INOX MURALE 29.00 € Ajouter au panier APPLIQUE 3 SPOTS 33.00 € Ajouter au panier repulseur rats souris PRO ! 39.47 € Ajouter au panier LAMPE LED 1W 16.80 € Ajouter au panier ECOR7S 11.00 € Ajouter au panier LOT de 100 SPHERIQUES COULEUR 19.00 € Ajouter au panier DETECTEUR NARCOTIQUES 79.00 € Ajouter au panier ALARME SANS FILS HA804U 320.00 € Ajouter au panier BANDE LEDS COULEUR RVB 289.00 € Ajouter au panier Panneau solaire 13w 130.00 € Ajouter au panier APPLIQUE 2 SPOTS 31.00 € Ajouter au panier Disque dur 500GO 159.00 € Ajouter au panier APPLIQUE TORCHE INOX 29.00 € Ajouter au panier KIT ALARME 196.00 € Ajouter au panier convertisseur 12/220/300w 100.46 € Ajouter au panier BOITIER DMX 69.00 € Ajouter au panier IODURE METALLIQUE R7S 28.00 € Ajouter au panier ALARME SANS FILS HA51 269.00 € Ajouter au panier DETECTEUR CARBONE incendie 39.00 € Ajouter au panier MR16 12V ECO 1.85 € Ajouter au panier POTELET ALU 29.00 € Ajouter au panier PLAFONIER ECO E27 29.90 € Ajouter au panier ADARA V2 3W 24.90 € Ajouter au panier APPLIQUE 1 SPOT 19.00 € Ajouter au panier LUMINAIRE ALUMINIUM 59.00 € Ajouter au panier Embout robinet a leds ABS 19.00 € Ajouter au panier Multimetre numerique 29.00 € Ajouter au panier ALIMENTATION 12V-1000MA 7.00 € Ajouter au panier Bande Leds 3 leds etanche 3.90 € Ajouter au panier KIT ADAPTAT USB 19.00 € Ajouter au panier APPLIQUE MURALE ALU 29.00 € Ajouter au panier Disque Dur EXTERNE 250GO 99.00 € 0.00 € Remise: 99.00 € Ajouter au panier Bande Leds 48 leds Rigide plastique 39.00 € Ajouter au panier Lampe mr16 leds 12v 4.98 € Ajouter au panier Projecteur Solaire jardin 25.80 € Ajouter au panier MR11 LED 1.8W 7.90 € Ajouter au panier lampe eco fluo B22 8.90 € Ajouter au panier Alarme pour enfants 95.00 € Ajouter au panier lampe eco fluo E27 8.50 € Ajouter au panier KIT 3SPOTS ENCASTRE 21.50 € Ajouter au panier TRANSFO ELECTRONIQUE 60VA 19.00 € Ajouter au panier Rouleau flexled 5m 149.00 € 0.00 € Remise: 149.00 € Ajouter au panier LUMINAIRE SECOURS 18W 34.90 € Ajouter au panier inter differentiel 40 a 30ma 46.64 € Ajouter au panier Lampe de Parasol led 16.80 € Ajouter au panier IODURE METALLIQUE G12 49.00 € Ajouter au panier Clé USB 2GO 26.00 € Ajouter au panier Repulseur de cafards PRO 34.68 € Ajouter au panier LAMPE GU10 50W 6.00 € Ajouter au panier LAMPE CREE 3W 12V 29.00 € Ajouter au panier IODURE METALLIQUE fc2 40.00 € Ajouter au panier Flexled adhésive 29.00 € Ajouter au panier LAMPE 4 LEDS 47.80 € Ajouter au panier Clé USB 4GO 49.00 € Ajouter au panier APPLIQUE MURALE INOX 29.00 € Ajouter au panier HUBLOT INOX 29.30 € Ajouter au panier adara 220V 5W 34.90 € Ajouter au panier LAMPE DICHRO 12V HALOG GE 4.50 € Ajouter au panier Transfo 12v 49.00 € Ajouter au panier PLAFONIER HALOGENE 25.40 € Ajouter au panier APPLIQUE HALOGENE 2SPOTS 29.90 € Ajouter au panier APPLIQUE MURALE INOX 35.00 € Ajouter au panier LOT 4 DETECT INCENDIE 59.00 € Ajouter au panier TELECOMMANDE RVB 19.00 € Ajouter au panier APPLIQUE INOX 39.00 € Ajouter au panier Rouleau flexled 5m rgb étanche ! 290.00 € Ajouter au panier spherique leds e14 22.00 € Ajouter au panier PORTIER VIDEO N/B 94.00 € Ajouter au panier Projecteur Solaire 89.00 € Ajouter au panier CAMERA SURVEILLANCE N/B 49.90 € Ajouter au panier LOT 3 RADARS 47.00 € Ajouter au panier Lanterne Solaire 29.00 € Ajouter au panier lampe torsadée fluo e27 8.90 € Ajouter au panier multimetre numerique eco 6.00 € Ajouter au panier leds cree 3w GU10 29.00 € Ajouter au panier LAMPE LED GU10 220V 6.50 € Ajouter au panier ALARME MAISON 40.00 € Ajouter au panier POTELET INOX 24.00 € Ajouter au panier Emballage fourreau 120 3.50 € Ajouter au panier projecteur leds 55w 460.00 € Ajouter au panier LAMPE LED 22 LEDS 1W 17.80 € Ajouter au panier Bande Leds 50 leds etanche 55.00 € Ajouter au panier BANDE DE LEDS 5 METRES 210.00 € Ajouter au panier APPLIQUE INOX MURALE 34.90 € Ajouter au panier Flamme E14 fluo 9.50 € Ajouter au panier embout robinet leds abs 19.00 € Ajouter au panier transfo 1600ma multitension 29.00 € Ajouter au panier LAMPE PISCINE A LEDS 297.80 € Ajouter au panier DETECTEUR PASSAGE PORTE 27.00 € Ajouter au panier DETECTEUR INCENDIE 13.00 € Ajouter au panier ALARME AUTONOME 39.00 € Ajouter au panier LAMPE 22 LEDS+DETECTEUR 23.00 € Ajouter au panier CAMERA N/B SURVEILANCE 46.00 € Ajouter au panier TUBE FLUO 60CM LEDS 49.90 € Ajouter au panier Identification Nom d'utilisateur Mot de passe Se souvenir de moi Mot de passe oublié ? Pas encore de compte ? Enregistrez-vous P a n i e r Voir le panier Votre panier est actuellement vide. Nos Réalisations PHOTOS MAGASINS En Ligne

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 menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
4
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM jos_session
 WHERE (
 ( time < '1227256072' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1227256072' )
 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 *
 FROM jos_menu
 WHERE id = 1
13
SELECT COUNT(a.id)
 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_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-11-21 09:42' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-11-21 09:42' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
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, 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 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_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-11-21 09:42' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-11-21 09:42' )
 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
15
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
16
SELECT params
 FROM jos_mambots
 WHERE element = 'mosimage'
 AND folder = 'content'
17
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 (`jos_vm_vendor`, `jos_vm_country`)
		WHERE `vendor_id`=1
		AND (vendor_country=country_2_code OR vendor_country=country_3_code);
18
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'
19
SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
20
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
21
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
22
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
23
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
24
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'
25
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 = 1 )
 ORDER BY ordering
26
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
27
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
28
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
29
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='TELRVB'
30
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='30' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
31
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='30'
32
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
33
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='30'
34
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='30' AND (start_date<='1227256973' OR start_date=0) AND (end_date>='1227220560' OR end_date=0) AND product_discount_id=discount_id
35
SELECT vendor_id FROM jos_vm_product WHERE product_id='30'
36
SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
37
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='30'
38
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='30' 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
39
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='30'
40
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='30' AND shopper_group_id='5'  ORDER BY price_quantity_start
41
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='30'
42
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='spherled'
43
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='96' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
44
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='96'
45
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='96'
46
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='96' AND (start_date<='1227256973' OR start_date=0) AND (end_date>='1227220560' OR end_date=0) AND product_discount_id=discount_id
47
SELECT vendor_id FROM jos_vm_product WHERE product_id='96'
48
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='96'
49
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='96' 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
50
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='96'
51
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='96' AND shopper_group_id='5'  ORDER BY price_quantity_start
52
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='96'
53
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sol90'
54
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='27' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
55
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='27'
56
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='27'
57
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='27' AND (start_date<='1227256974' OR start_date=0) AND (end_date>='1227220560' OR end_date=0) AND product_discount_id=discount_id
58
SELECT vendor_id FROM jos_vm_product WHERE product_id='27'
59
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='27'
60
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='27' 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='27'
62
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='27' AND shopper_group_id='5'  ORDER BY price_quantity_start
63
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='27'
64
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='RX101045'
65
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='98' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
66
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='98'
67
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='98'
68
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='98' AND (start_date<='1227256974' OR start_date=0) AND (end_date>='1227220560' OR end_date=0) AND product_discount_id=discount_id
69
SELECT vendor_id FROM jos_vm_product WHERE product_id='98'
70
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='98'
71
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='98' 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
72
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='98'
73
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='98' AND shopper_group_id='5'  ORDER BY price_quantity_start
74
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='98'
75
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='3000044'
76
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='109' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
77
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='109'
78
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='109'
79
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='109' AND (start_date<='1227256974' OR start_date=0) AND (end_date>='1227220560' OR end_date=0) AND product_discount_id=discount_id
80
SELECT vendor_id FROM jos_vm_product WHERE product_id='109'
81
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='109'
82
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='109' 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
83
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='109'
84
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='109' AND shopper_group_id='5'  ORDER BY price_quantity_start
85
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='109'
86
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='HOUSMR1612'
87
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='92' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
88
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='92'
89
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='92'
90
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='92' AND (start_date<='1227256974' OR start_date=0) AND (end_date>='1227220560' OR end_date=0) AND product_discount_id=discount_id
91
SELECT vendor_id FROM jos_vm_product WHERE product_id='92'
92
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='92'
93
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='92' 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
94
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='92'
95
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='92' AND shopper_group_id='5'  ORDER BY price_quantity_start
96
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='92'
97
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='RX2670'
98
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='112' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
99
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='112'
100
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='112'
101
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='112' AND (start_date<='1227256974' OR start_date=0) AND (end_date>='1227220560' OR end_date=0) AND product_discount_id=discount_id
102
SELECT vendor_id FROM jos_vm_product WHERE product_id='112'
103
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='112'
104
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='112' 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
105
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='112'
106
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='112' AND shopper_group_id='5'  ORDER BY price_quantity_start
107
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='112'
108
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='5000035'
109
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='101' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
110
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='101'
111
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='101'
112
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='101' AND (start_date<='1227256974' OR start_date=0) AND (end_date>='1227220560' OR end_date=0) AND product_discount_id=discount_id
113
SELECT vendor_id FROM jos_vm_product WHERE product_id='101'
114
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='101'
115
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='101' 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
116
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='101'
117
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='101' AND shopper_group_id='5'  ORDER BY price_quantity_start
118
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='101'
119
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='LOTSPHER'
120
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='59' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
121
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='59'
122
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='59'
123
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='59' AND (start_date<='1227256974' OR start_date=0) AND (end_date>='1227220560' OR end_date=0) AND product_discount_id=discount_id
124
SELECT vendor_id FROM jos_vm_product WHERE product_id='59'
125
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='59'
126
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='59' 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
127
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='59'
128
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='59' AND shopper_group_id='5'  ORDER BY price_quantity_start
129
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='59'
130
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='RM120C4'
131
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='125' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
132
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='125'
133
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='125'
134
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='125' AND (start_date<='1227256975' OR start_date=0) AND (end_date>='1227220560' OR end_date=0) AND product_discount_id=discount_id
135
SELECT vendor_id FROM jos_vm_product WHERE product_id='125'
136
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='125'
137
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='125' 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
138
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='125'
139
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='125' AND shopper_group_id='5'  ORDER BY price_quantity_start
140
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='125'
141
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='HOUledmr16'
142
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='64' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
143
SELECT
                                `jos_vm_product`.