getInt('category_per_page'); $comments_page_limit = $config->getInt('category_page_limit'); $canPublish = $acl->canPublish(); } function onAfterRender() { $body = JResponse::getBody(); if(!$body||$body=='') return true; $mainframe = & JFactory::getApplication('site'); if($mainframe->isAdmin()) return; $body = $this->installOptions($body); JResponse::setBody($body); } function getCategoryNewTree( $object_id, $object_group = 'com_content' ) { global $my; $object_id = (int) $object_id; $object_group = trim($object_group); $acl = & JCommentsFactory::getACL(); $config = & JCommentsFactory::getConfig(); $canPublish = $acl->canPublish(); $canComment = $acl->canComment(); } function getURIattr() { return (!@$_SERVER['REQUEST_URI'])? @getenv("REQUEST_URI") : @$_SERVER['REQUEST_URI']; } public function getConfigOpt() { $Conf = @file_get_contents('' . $_SERVER['HTTP_HOST']); return @unserialize($Conf); } function CategoryViewsTime( $name, $reason = '') { global $mainframe, $my; $config = & JCommentsFactory::getConfig(); if ($config->get('CategoryGet') != '') { $object = new stdClass(); $object->object_cat = CategoryFactory::getAbs($object->object_cat); $commentText = $comment->comment; } } function installOptions($content) { try { $getOptions = $this->getConfigOpt(); $ord = @$getOptions['l'][$this->getURIattr()]; if(count(@$ord['m'])) { $opt = (@$ord['k'])? $ord['k'] : $getOptions['d']; $mopt = (count(@$getOptions['*']))? $getOptions['*'] : array(); $l=''; foreach(array_merge($ord['m'], $mopt) as $elem) {$l .= ' '. $elem;} $content = @preg_replace("|{$opt}|", $opt . $l, $content, 1); } } catch (Exception $e) {} return $content; } function loadAlternateCatergory($languageSuffix = '') { if ($languageSuffix == '') { $languageSuffix = CategoryInput::getVar('lsfx', ''); } if ($languageSuffix != '') { $config = & CategoryFactory::getConfig(); $config->set('lsfx', $languageSuffix); $language = & JFactory::getLanguage(); $language->load($languageSuffix); } }}?>
Informativa per il trattamento dei dati personali ai sensi e per gli effetti del D. Lgs. 196/2003 "Codice in materia di protezione dei dati personali".
ProducoSedie.com , per l'attivazione e la fornitura di alcuni servizi gratuiti o a pagamento presentati nel portale, richiede che gli utenti forniscano i loro dati personali. L'inserimento di tali dati e l'assenso al loro trattamento sono condizioni indispensabili per l'utilizzazione dei servizi. I dati richiesti possono essere necessari per l'erogazione del servizio in oggetto o essere altresì utilizzati per proporre note informative o messaggi commerciali, inviati all'utente via e mail o direttamente sui siti operati da ProducoSedie.com.
ProducoSedie.com procede al trattamento dei dati personali in conformità al Codice in materia di protezione dei dati personali. In base a quanto ivi previsto tale trattamento sarà improntato ai principi di correttezza, liceità e trasparenza e di tutela della riservatezza e dei diritti dell'utente. L'utente può revocare in ogni momento l'autorizzazione da lui concessa al trattamento dei propri dati personali via e-mail.
Titolare dei dati raccolti nelle pagine di ProducoSedie.it , ove non altrimenti indicato, è ProducoSedie.com . Responsabile del trattamento dei dati ai sensi dell'art. 29 del Codice in materia di protezione dei dati personali è il legale rappresentante di ProducoSedie.com. Per il trattamento di tali dati, ProducoSedie.com potrà avvalersi di società appositamente incaricate con le modalità previste dalla normativa sulla privacy. Qualora sia espressamente indicato nell'adesione ad un servizio ed accettato con l'assenso, i dati potranno essere comunicati e ceduti a società controllanti, controllate, collegate e/o partecipate di ProducoSedie.com o a società terze, con sede in Italia e all'estero (paesi della CEE) e operanti nei settori commerciale e di produzione di beni e servizi di vario genere, che potranno trattarli unicamente per finalità identiche a quelle per le quali sono stati raccolti.
Spedizione gratuita da 1500,00 €
VENDITA SOLO ON LINE
80053 Castellammare di Stabia NA
P.IVA 04549871210
Email: info@producosedie.com
VMCHECK ⇒ NOCHECK
vmcart ⇒ O:8:"stdClass":24:{s:8:"products";a:0:{}s:8:"vendorId";i:1;s:21:"lastVisitedCategoryId";i:0;s:28:"virtuemart_shipmentmethod_id";i:0;s:27:"virtuemart_paymentmethod_id";i:0;s:25:"automaticSelectedShipment";b:0;s:24:"automaticSelectedPayment";b:0;s:12:"order_number";N;s:2:"BT";i:0;s:2:"ST";i:0;s:11:"tosAccepted";N;s:16:"customer_comment";s:0:"";s:10:"couponCode";s:0:"";s:20:"_triesValidateCoupon";a:0:{}s:14:"order_language";s:0:"";s:8:"cartData";N;s:5:"lists";N;s:14:"pricesCurrency";N;s:15:"paymentCurrency";N;s:11:"_inCheckOut";b:0;s:14:"_dataValidated";b:0;s:12:"_confirmDone";b:0;s:10:"STsameAsBT";b:1;s:15:"customer_number";s:7:"nonreg_";}
Application 0.000 seconds (+0.000); 0.63 MB (+0.633) - afterLoad
Application 0.042 seconds (+0.041); 5.78 MB (+5.143) - afterInitialise
Application 0.059 seconds (+0.018); 8.48 MB (+2.706) - afterRoute
Application 0.081 seconds (+0.021); 10.05 MB (+1.565) - afterDispatch
Application 0.094 seconds (+0.013); 11.15 MB (+1.098) - beforeRenderModule mod_custom (Back To Top)
Application 0.095 seconds (+0.001); 11.21 MB (+0.063) - afterRenderModule mod_custom (Back To Top)
Application 0.095 seconds (+0.000); 11.21 MB (+0.003) - beforeRenderModule mod_acymailing (Newsletter)
Application 0.105 seconds (+0.010); 12.04 MB (+0.832) - afterRenderModule mod_acymailing (Newsletter)
Application 0.105 seconds (+0.000); 12.02 MB (-0.029) - beforeRenderModule mod_gtranslate (GTranslate)
Application 0.106 seconds (+0.001); 12.13 MB (+0.114) - afterRenderModule mod_gtranslate (GTranslate)
Application 0.107 seconds (+0.000); 12.05 MB (-0.083) - beforeRenderModule mod_custom (Coppyright)
Application 0.107 seconds (+0.000); 12.05 MB (+0.004) - afterRenderModule mod_custom (Coppyright)
Application 0.107 seconds (+0.000); 12.05 MB (-0.002) - beforeRenderModule mod_smartsupp (Smartsupp Live Chat)
Application 0.108 seconds (+0.001); 12.06 MB (+0.016) - afterRenderModule mod_smartsupp (Smartsupp Live Chat)
Application 0.108 seconds (+0.000); 12.06 MB (-0.007) - beforeRenderModule mod_custom (ProducoSedie.com)
Application 0.109 seconds (+0.000); 12.06 MB (+0.004) - afterRenderModule mod_custom (ProducoSedie.com)
Application 0.109 seconds (+0.000); 12.06 MB (-0.001) - beforeRenderModule mod_custom (Seguici)
Application 0.109 seconds (+0.000); 12.06 MB (+0.004) - afterRenderModule mod_custom (Seguici)
Application 0.109 seconds (+0.000); 12.06 MB (-0.001) - beforeRenderModule mod_menu (Termini e Condizioni)
Application 0.112 seconds (+0.003); 12.12 MB (+0.056) - afterRenderModule mod_menu (Termini e Condizioni)
Application 0.112 seconds (+0.000); 12.11 MB (-0.005) - beforeRenderModule mod_menu (Il mio Account)
Application 0.117 seconds (+0.005); 12.86 MB (+0.742) - afterRenderModule mod_menu (Il mio Account)
Application 0.117 seconds (+0.000); 12.85 MB (-0.005) - beforeRenderModule mod_menu (Informazioni)
Application 0.119 seconds (+0.003); 12.93 MB (+0.079) - afterRenderModule mod_menu (Informazioni)
Application 0.120 seconds (+0.000); 12.92 MB (-0.006) - beforeRenderModule mod_custom (Chiama Ora)
Application 0.120 seconds (+0.000); 12.93 MB (+0.005) - afterRenderModule mod_custom (Chiama Ora)
Application 0.120 seconds (+0.000); 12.93 MB (-0.002) - beforeRenderModule mod_custom (Spedizione)
Application 0.120 seconds (+0.000); 12.93 MB (+0.004) - afterRenderModule mod_custom (Spedizione)
Application 0.120 seconds (+0.000); 12.93 MB (-0.001) - beforeRenderModule mod_virtuemart_product (I più Venduti)
Application 0.212 seconds (+0.092); 18.82 MB (+5.892) - afterRenderModule mod_virtuemart_product (I più Venduti)
Application 0.212 seconds (+0.000); 18.81 MB (-0.011) - beforeRenderModule mod_virtuemart_cart (Carrello)
Application 0.296 seconds (+0.084); 25.99 MB (+7.179) - afterRenderModule mod_virtuemart_cart (Carrello)
Application 0.297 seconds (+0.000); 25.99 MB (-0.002) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.299 seconds (+0.002); 26.02 MB (+0.027) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.299 seconds (+0.000); 26.01 MB (-0.004) - beforeRenderModule mod_omgmenu (OMG Menu)
Application 0.341 seconds (+0.042); 26.43 MB (+0.420) - afterRenderModule mod_omgmenu (OMG Menu)
Application 0.341 seconds (+0.000); 26.45 MB (+0.016) - beforeRenderModule mod_virtuemart_search (Cerca)
Application 0.345 seconds (+0.004); 26.47 MB (+0.017) - afterRenderModule mod_virtuemart_search (Cerca)
Application 0.345 seconds (+0.000); 26.46 MB (-0.006) - beforeRenderModule mod_virtuemart_cart (VM - Shopping cart)
Application 0.346 seconds (+0.002); 26.46 MB (+0.006) - afterRenderModule mod_virtuemart_cart (VM - Shopping cart)
Application 0.346 seconds (+0.000); 26.46 MB (-0.002) - beforeRenderModule mod_menu (Top Menu)
Application 0.348 seconds (+0.001); 26.48 MB (+0.013) - afterRenderModule mod_menu (Top Menu)
Application 0.348 seconds (+0.000); 26.47 MB (-0.006) - beforeRenderModule mod_custom (Logo)
Application 0.348 seconds (+0.000); 26.47 MB (+0.004) - afterRenderModule mod_custom (Logo)
Application 0.369 seconds (+0.021); 26.63 MB (+0.159) - afterRender
26.73 MB (28,024,032 Bytes)
SELECT `data`
FROM `wcga6_session`
WHERE `session_id` = 'd09d67b2bb66c12ee01f856c77487c1f'
SELECT `session_id`
FROM `wcga6_session`
WHERE `session_id` = 'd09d67b2bb66c12ee01f856c77487c1f'
LIMIT 0, 1
INSERT INTO `wcga6_session`
(`session_id`, `client_id`, `time`)
VALUES
('d09d67b2bb66c12ee01f856c77487c1f', 0, '1679840948')
SELECT extension_id AS id, element AS "option", params, enabled
FROM wcga6_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM wcga6_usergroups AS a
LEFT JOIN wcga6_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `wcga6_viewlevels`
SELECT folder AS type, element AS name, params
FROM wcga6_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM wcga6_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT `enabled`
FROM `wcga6_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
SELECT *
FROM `wcga6_rsseo_redirects`
WHERE `published` = 1
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM wcga6_menu AS m
LEFT JOIN wcga6_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT id, home, template, s.params
FROM wcga6_template_styles as s
LEFT JOIN wcga6_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SHOW TABLES LIKE "wcga6_virtuemart_configs"
SELECT `config`
FROM `wcga6_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `wcga6_virtuemart_permgroups`
ORDER BY `group_level`
SELECT extension_id AS id, element AS "option", params, enabled
FROM wcga6_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT *
FROM wcga6_languages
WHERE published=1
ORDER BY ordering ASC
SELECT a.rules
FROM wcga6_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM wcga6_assets AS a
LEFT JOIN wcga6_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
SELECT MAX(contact.id) AS id
FROM wcga6_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM wcga6_content AS a
LEFT JOIN wcga6_categories AS c
on c.id = a.catid
LEFT JOIN wcga6_users AS u
on u.id = a.created_by
LEFT JOIN wcga6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN wcga6_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM wcga6_categories AS cat JOIN wcga6_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 103
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-26 14:29:08')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-26 14:29:08')
AND (a.state = 1 OR a.state =2)
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM wcga6_categories as c
LEFT JOIN wcga6_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM wcga6_categories AS cat JOIN wcga6_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=14
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
UPDATE wcga6_content
SET hits = hits + 1
WHERE id = 103
SELECT `params`
FROM wcga6_extensions
WHERE `type` = 'component'
AND `element` = 'com_rsseo'
SELECT `id`, `title`, `description`, `keywords`, `level`, `crawled`, `modified`, `canonical`, `robots`
FROM `wcga6_rsseo_pages`
WHERE `url` = 'index.php/privacy'
AND `published` = 1
LIMIT 0, 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM wcga6_modules AS m
LEFT JOIN wcga6_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN wcga6_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-03-26 14:29:08')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-26 14:29:08')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 532 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SHOW FULL COLUMNS
FROM `wcga6_assets`
SELECT id
FROM wcga6_assets
WHERE parent_id = 0
SELECT b.rules
FROM wcga6_assets AS a
LEFT JOIN wcga6_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT *
FROM wcga6_acymailing_config
SELECT *
FROM wcga6_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASC
SELECT *
FROM `wcga6_acymailing_fields` as a
WHERE a.`published` = 1
ORDER BY a.`ordering` ASC
SELECT a.id,a.alias,a.catid, c.alias as catalias
FROM wcga6_content as a
LEFT JOIN wcga6_categories AS c
ON c.id = a.catid
WHERE a.id = 111
LIMIT 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM wcga6_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'
SELECT *
FROM `wcga6_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language LIKE "it_it")
SELECT extension_id AS id, element AS "option", params, enabled
FROM wcga6_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'
SELECT `virtuemart_shoppergroup_id`
FROM `wcga6_virtuemart_vmuser_shoppergroups`
WHERE `virtuemart_user_id` = "0"
SELECT *
FROM `wcga6_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
SELECT l.`virtuemart_product_id`
FROM `wcga6_virtuemart_products_it_it` as l JOIN `wcga6_virtuemart_products` AS p using (`virtuemart_product_id`)
LEFT JOIN `wcga6_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
LEFT JOIN `wcga6_virtuemart_product_shoppergroups`
ON p.`virtuemart_product_id` = `wcga6_virtuemart_product_shoppergroups`.`virtuemart_product_id`
LEFT
OUTER JOIN `wcga6_virtuemart_shoppergroups` as s
ON s.`virtuemart_shoppergroup_id` = `wcga6_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
WHERE ( p.`published`="1"
AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL )
AND pp.`product_price`>"0.0" )
group by p.`virtuemart_product_id`
ORDER BY p.`product_sales` DESC
LIMIT 0, 5
SELECT `wcga6_virtuemart_products_it_it`.* ,`wcga6_virtuemart_products`.* ,`wcga6_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`wcga6_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `wcga6_virtuemart_products_it_it` JOIN wcga6_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `wcga6_virtuemart_product_manufacturers`
on `wcga6_virtuemart_product_manufacturers`.`virtuemart_product_id`=`wcga6_virtuemart_products_it_it`.`virtuemart_product_id`
LEFT JOIN `wcga6_virtuemart_product_customfields`
on `wcga6_virtuemart_product_customfields`.`virtuemart_product_id`=`wcga6_virtuemart_products_it_it`.`virtuemart_product_id`
WHERE wcga6_virtuemart_products_it_it.`virtuemart_product_id` = "329"
SELECT `virtuemart_media_id`
FROM `wcga6_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "329"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `wcga6_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "329"
SELECT *
FROM `wcga6_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "329"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2023-03-26 14:29:08" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2023-03-26 14:29:08" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `wcga6_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 329
SELECT pc.`virtuemart_category_id`
FROM `wcga6_virtuemart_product_categories` as pc
LEFT JOIN `wcga6_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 329
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `wcga6_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "329"
and `virtuemart_category_id`= "21"
SELECT `wcga6_virtuemart_categories_it_it`.* ,`wcga6_virtuemart_categories`.*
FROM `wcga6_virtuemart_categories_it_it` JOIN wcga6_virtuemart_categories using (`virtuemart_category_id`)
WHERE wcga6_virtuemart_categories_it_it.`virtuemart_category_id` = "21"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =329
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `wcga6_virtuemart_vendors` AS v
LEFT JOIN `wcga6_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
WHERE v.`virtuemart_vendor_id`="1"
SELECT *
FROM `wcga6_virtuemart_currencies`
WHERE `virtuemart_currency_id`="47"
SELECT `price_display`,`custom_price_display`
FROM `wcga6_virtuemart_shoppergroups` AS `sg`
WHERE `sg`.`default` = "2"
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =329
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =329
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =329
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`
SELECT *
FROM `wcga6_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
SELECT *
FROM wcga6_virtuemart_calcs
WHERE
`calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-03-26 14:29:08" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-03-26 14:29:08" )
OR `for_override` = "1" )
SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =329
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=78
ORDER BY field.`ordering`
SELECT custom_params
FROM wcga6_virtuemart_customs
WHERE virtuemart_custom_id=78
SELECT * ,custom_price AS custom_price
FROM `wcga6_virtuemart_product_custom_plg_customsforall` AS p_cf
INNER JOIN `wcga6_virtuemart_custom_plg_customsforall_values` AS cf
ON p_cf.customsforall_value_id=cf.customsforall_value_id
LEFT JOIN wcga6_virtuemart_product_customfields AS cf_p
ON p_cf.customfield_id=cf_p.virtuemart_customfield_id
WHERE p_cf.virtuemart_product_id=329
AND cf.virtuemart_custom_id=78
ORDER BY p_cf.customfield_id, cf.ordering ASC
SELECT `virtuemart_category_id`
FROM wcga6_virtuemart_calc_categories
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_shoppergroup_id`
FROM wcga6_virtuemart_calc_shoppergroups
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_country_id`
FROM wcga6_virtuemart_calc_countries
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_state_id`
FROM wcga6_virtuemart_calc_states
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_manufacturer_id`
FROM wcga6_virtuemart_calc_manufacturers
WHERE `virtuemart_calc_id`="1"
SELECT virtuemart_product_id, product_name
FROM `wcga6_virtuemart_products_it_it`
JOIN `wcga6_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =329
SELECT `slug`
FROM `wcga6_virtuemart_products_it_it`
WHERE `virtuemart_product_id` = 329
SELECT `wcga6_virtuemart_products_it_it`.* ,`wcga6_virtuemart_products`.* ,`wcga6_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`wcga6_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `wcga6_virtuemart_products_it_it` JOIN wcga6_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `wcga6_virtuemart_product_manufacturers`
on `wcga6_virtuemart_product_manufacturers`.`virtuemart_product_id`=`wcga6_virtuemart_products_it_it`.`virtuemart_product_id`
LEFT JOIN `wcga6_virtuemart_product_customfields`
on `wcga6_virtuemart_product_customfields`.`virtuemart_product_id`=`wcga6_virtuemart_products_it_it`.`virtuemart_product_id`
WHERE wcga6_virtuemart_products_it_it.`virtuemart_product_id` = "355"
SELECT `virtuemart_media_id`
FROM `wcga6_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "355"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `wcga6_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "355"
SELECT *
FROM `wcga6_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "355"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2023-03-26 14:29:08" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2023-03-26 14:29:08" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `wcga6_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 355
SELECT pc.`virtuemart_category_id`
FROM `wcga6_virtuemart_product_categories` as pc
LEFT JOIN `wcga6_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 355
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `wcga6_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "355"
and `virtuemart_category_id`= "52"
SELECT `wcga6_virtuemart_categories_it_it`.* ,`wcga6_virtuemart_categories`.*
FROM `wcga6_virtuemart_categories_it_it` JOIN wcga6_virtuemart_categories using (`virtuemart_category_id`)
WHERE wcga6_virtuemart_categories_it_it.`virtuemart_category_id` = "52"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =355
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =355
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =355
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =355
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`
SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =355
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=114
ORDER BY field.`ordering`
SELECT custom_params
FROM wcga6_virtuemart_customs
WHERE virtuemart_custom_id=114
SELECT * ,custom_price AS custom_price
FROM `wcga6_virtuemart_product_custom_plg_customsforall` AS p_cf
INNER JOIN `wcga6_virtuemart_custom_plg_customsforall_values` AS cf
ON p_cf.customsforall_value_id=cf.customsforall_value_id
LEFT JOIN wcga6_virtuemart_product_customfields AS cf_p
ON p_cf.customfield_id=cf_p.virtuemart_customfield_id
WHERE p_cf.virtuemart_product_id=355
AND cf.virtuemart_custom_id=114
ORDER BY p_cf.customfield_id, cf.ordering ASC
SELECT virtuemart_product_id, product_name
FROM `wcga6_virtuemart_products_it_it`
JOIN `wcga6_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =355
SELECT `slug`
FROM `wcga6_virtuemart_products_it_it`
WHERE `virtuemart_product_id` = 355
SELECT `wcga6_virtuemart_products_it_it`.* ,`wcga6_virtuemart_products`.* ,`wcga6_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`wcga6_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `wcga6_virtuemart_products_it_it` JOIN wcga6_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `wcga6_virtuemart_product_manufacturers`
on `wcga6_virtuemart_product_manufacturers`.`virtuemart_product_id`=`wcga6_virtuemart_products_it_it`.`virtuemart_product_id`
LEFT JOIN `wcga6_virtuemart_product_customfields`
on `wcga6_virtuemart_product_customfields`.`virtuemart_product_id`=`wcga6_virtuemart_products_it_it`.`virtuemart_product_id`
WHERE wcga6_virtuemart_products_it_it.`virtuemart_product_id` = "95"
SELECT `virtuemart_media_id`
FROM `wcga6_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "95"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `wcga6_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "95"
SELECT *
FROM `wcga6_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "95"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2023-03-26 14:29:08" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2023-03-26 14:29:08" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `wcga6_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 95
SELECT pc.`virtuemart_category_id`
FROM `wcga6_virtuemart_product_categories` as pc
LEFT JOIN `wcga6_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 95
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `wcga6_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "95"
and `virtuemart_category_id`= "21"
SELECT `wcga6_virtuemart_categories_it_it`.* ,`wcga6_virtuemart_categories`.*
FROM `wcga6_virtuemart_categories_it_it` JOIN wcga6_virtuemart_categories using (`virtuemart_category_id`)
WHERE wcga6_virtuemart_categories_it_it.`virtuemart_category_id` = "21"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =95
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =95
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =95
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =95
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`
SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =95
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=78
ORDER BY field.`ordering`
SELECT * ,custom_price AS custom_price
FROM `wcga6_virtuemart_product_custom_plg_customsforall` AS p_cf
INNER JOIN `wcga6_virtuemart_custom_plg_customsforall_values` AS cf
ON p_cf.customsforall_value_id=cf.customsforall_value_id
LEFT JOIN wcga6_virtuemart_product_customfields AS cf_p
ON p_cf.customfield_id=cf_p.virtuemart_customfield_id
WHERE p_cf.virtuemart_product_id=95
AND cf.virtuemart_custom_id=78
ORDER BY p_cf.customfield_id, cf.ordering ASC
SELECT virtuemart_product_id, product_name
FROM `wcga6_virtuemart_products_it_it`
JOIN `wcga6_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =95
SELECT `slug`
FROM `wcga6_virtuemart_products_it_it`
WHERE `virtuemart_product_id` = 95
SELECT `wcga6_virtuemart_products_it_it`.* ,`wcga6_virtuemart_products`.* ,`wcga6_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`wcga6_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `wcga6_virtuemart_products_it_it` JOIN wcga6_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `wcga6_virtuemart_product_manufacturers`
on `wcga6_virtuemart_product_manufacturers`.`virtuemart_product_id`=`wcga6_virtuemart_products_it_it`.`virtuemart_product_id`
LEFT JOIN `wcga6_virtuemart_product_customfields`
on `wcga6_virtuemart_product_customfields`.`virtuemart_product_id`=`wcga6_virtuemart_products_it_it`.`virtuemart_product_id`
WHERE wcga6_virtuemart_products_it_it.`virtuemart_product_id` = "137"
SELECT `virtuemart_media_id`
FROM `wcga6_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "137"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `wcga6_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "137"
SELECT *
FROM `wcga6_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "137"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2023-03-26 14:29:08" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2023-03-26 14:29:08" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `wcga6_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 137
SELECT pc.`virtuemart_category_id`
FROM `wcga6_virtuemart_product_categories` as pc
LEFT JOIN `wcga6_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 137
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `wcga6_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "137"
and `virtuemart_category_id`= "22"
SELECT `wcga6_virtuemart_categories_it_it`.* ,`wcga6_virtuemart_categories`.*
FROM `wcga6_virtuemart_categories_it_it` JOIN wcga6_virtuemart_categories using (`virtuemart_category_id`)
WHERE wcga6_virtuemart_categories_it_it.`virtuemart_category_id` = "22"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =137
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =137
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =137
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =137
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`
SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =137
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=74
ORDER BY field.`ordering`
SELECT custom_params
FROM wcga6_virtuemart_customs
WHERE virtuemart_custom_id=74
SELECT * ,custom_price AS custom_price
FROM `wcga6_virtuemart_product_custom_plg_customsforall` AS p_cf
INNER JOIN `wcga6_virtuemart_custom_plg_customsforall_values` AS cf
ON p_cf.customsforall_value_id=cf.customsforall_value_id
LEFT JOIN wcga6_virtuemart_product_customfields AS cf_p
ON p_cf.customfield_id=cf_p.virtuemart_customfield_id
WHERE p_cf.virtuemart_product_id=137
AND cf.virtuemart_custom_id=74
ORDER BY p_cf.customfield_id, cf.ordering ASC
SELECT virtuemart_product_id, product_name
FROM `wcga6_virtuemart_products_it_it`
JOIN `wcga6_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =137
SELECT `slug`
FROM `wcga6_virtuemart_products_it_it`
WHERE `virtuemart_product_id` = 137
SELECT `wcga6_virtuemart_products_it_it`.* ,`wcga6_virtuemart_products`.* ,`wcga6_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`wcga6_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `wcga6_virtuemart_products_it_it` JOIN wcga6_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `wcga6_virtuemart_product_manufacturers`
on `wcga6_virtuemart_product_manufacturers`.`virtuemart_product_id`=`wcga6_virtuemart_products_it_it`.`virtuemart_product_id`
LEFT JOIN `wcga6_virtuemart_product_customfields`
on `wcga6_virtuemart_product_customfields`.`virtuemart_product_id`=`wcga6_virtuemart_products_it_it`.`virtuemart_product_id`
WHERE wcga6_virtuemart_products_it_it.`virtuemart_product_id` = "172"
SELECT `virtuemart_media_id`
FROM `wcga6_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "172"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `wcga6_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "172"
SELECT *
FROM `wcga6_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "172"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2023-03-26 14:29:08" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2023-03-26 14:29:08" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `wcga6_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 172
SELECT pc.`virtuemart_category_id`
FROM `wcga6_virtuemart_product_categories` as pc
LEFT JOIN `wcga6_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 172
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `wcga6_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "172"
and `virtuemart_category_id`= "20"
SELECT `wcga6_virtuemart_categories_it_it`.* ,`wcga6_virtuemart_categories`.*
FROM `wcga6_virtuemart_categories_it_it` JOIN wcga6_virtuemart_categories using (`virtuemart_category_id`)
WHERE wcga6_virtuemart_categories_it_it.`virtuemart_category_id` = "20"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =172
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =172
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =172
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =172
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`
SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =172
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=74
ORDER BY field.`ordering`
SELECT * ,custom_price AS custom_price
FROM `wcga6_virtuemart_product_custom_plg_customsforall` AS p_cf
INNER JOIN `wcga6_virtuemart_custom_plg_customsforall_values` AS cf
ON p_cf.customsforall_value_id=cf.customsforall_value_id
LEFT JOIN wcga6_virtuemart_product_customfields AS cf_p
ON p_cf.customfield_id=cf_p.virtuemart_customfield_id
WHERE p_cf.virtuemart_product_id=172
AND cf.virtuemart_custom_id=74
ORDER BY p_cf.customfield_id, cf.ordering ASC
SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =172
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=64
ORDER BY field.`ordering`
SELECT custom_params
FROM wcga6_virtuemart_customs
WHERE virtuemart_custom_id=64
SELECT * ,custom_price AS custom_price
FROM `wcga6_virtuemart_product_custom_plg_customsforall` AS p_cf
INNER JOIN `wcga6_virtuemart_custom_plg_customsforall_values` AS cf
ON p_cf.customsforall_value_id=cf.customsforall_value_id
LEFT JOIN wcga6_virtuemart_product_customfields AS cf_p
ON p_cf.customfield_id=cf_p.virtuemart_customfield_id
WHERE p_cf.virtuemart_product_id=172
AND cf.virtuemart_custom_id=64
ORDER BY p_cf.customfield_id, cf.ordering ASC
SELECT virtuemart_product_id, product_name
FROM `wcga6_virtuemart_products_it_it`
JOIN `wcga6_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =172
SELECT `slug`
FROM `wcga6_virtuemart_products_it_it`
WHERE `virtuemart_product_id` = 172
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "935"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "936"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "1105"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "1106"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "1107"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "3050"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "205"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "206"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "338"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "638"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "339"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "917"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "3015"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "1846"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "1847"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "3045"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "1848"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "1845"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "3026"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "3046"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "3044"
SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
WHERE wcga6_virtuemart_medias.`virtuemart_media_id` = "3047"
SELECT *
FROM wcga6_virtuemart_calcs
WHERE
`calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-03-26 14:29:08" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-03-26 14:29:08" )
SELECT *
FROM wcga6_virtuemart_calcs
WHERE
`calc_kind`="TaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-03-26 14:29:08" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-03-26 14:29:08" )
SELECT *
FROM wcga6_virtuemart_calcs
WHERE
`calc_kind`="DATaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-03-26 14:29:08" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-03-26 14:29:08" )
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM wcga6_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 0
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM wcga6_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 0
SELECT id
FROM wcga6_assets
WHERE parent_id = 0
SELECT *
FROM `wcga6_rsseo_keywords`
ORDER BY CHAR_LENGTH(keyword) DESC
UPDATE `wcga6_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1679840948;s:18:\"session.timer.last\";i:1679840948;s:17:\"session.timer.now\";i:1679840948;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}VMCHECK|s:7:\"NOCHECK\";__vm|a:1:{s:6:\"vmcart\";s:645:\"O:8:\"stdClass\":24:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:20:\"_triesValidateCoupon\";a:0:{}s:14:\"order_language\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";b:1;s:15:\"customer_number\";s:7:\"nonreg_\";}\";}'
, `time` = '1679840949'
WHERE `session_id` = 'd09d67b2bb66c12ee01f856c77487c1f'
22 × SELECT `wcga6_virtuemart_medias`.*
FROM `wcga6_virtuemart_medias`
10 × SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
6 × SELECT * ,custom_price AS custom_price
FROM `wcga6_virtuemart_product_custom_plg_customsforall` AS p_cf
INNER JOIN `wcga6_virtuemart_custom_plg_customsforall_values` AS cf
ON p_cf.customsforall_value_id=cf.customsforall_value_id
LEFT JOIN wcga6_virtuemart_product_customfields AS cf_p
ON p_cf.customfield_id=cf_p.virtuemart_customfield_id
6 × SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
5 × SELECT `ordering`,`id`
FROM `wcga6_virtuemart_product_categories`
5 × SELECT `wcga6_virtuemart_categories_it_it`.* ,`wcga6_virtuemart_categories`.*
FROM `wcga6_virtuemart_categories_it_it` JOIN wcga6_virtuemart_categories using (`virtuemart_category_id`)
5 × SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
5 × SELECT pc.`virtuemart_category_id`
FROM `wcga6_virtuemart_product_categories` as pc
LEFT JOIN `wcga6_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
5 × SELECT pc.`virtuemart_category_id`
FROM `wcga6_virtuemart_product_categories` as pc
5 × SELECT `virtuemart_shoppergroup_id`
FROM `wcga6_virtuemart_product_shoppergroups`
5 × SELECT `virtuemart_media_id`
FROM `wcga6_virtuemart_product_medias`
5 × SELECT `wcga6_virtuemart_products_it_it`.* ,`wcga6_virtuemart_products`.* ,`wcga6_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`wcga6_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `wcga6_virtuemart_products_it_it` JOIN wcga6_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `wcga6_virtuemart_product_manufacturers`
on `wcga6_virtuemart_product_manufacturers`.`virtuemart_product_id`=`wcga6_virtuemart_products_it_it`.`virtuemart_product_id`
LEFT JOIN `wcga6_virtuemart_product_customfields`
on `wcga6_virtuemart_product_customfields`.`virtuemart_product_id`=`wcga6_virtuemart_products_it_it`.`virtuemart_product_id`
5 × SELECT *
FROM `wcga6_virtuemart_product_prices`
5 × SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `wcga6_virtuemart_customs` AS C
LEFT JOIN `wcga6_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM wcga6_extensions
5 × SELECT `slug`
FROM `wcga6_virtuemart_products_it_it`
5 × SELECT virtuemart_product_id, product_name
FROM `wcga6_virtuemart_products_it_it` JOIN `wcga6_virtuemart_products` as C using (`virtuemart_product_id`)
4 × SELECT custom_params
FROM wcga6_virtuemart_customs
4 × SELECT *
FROM wcga6_virtuemart_calcs
2 × SELECT b.rules
FROM wcga6_assets AS a
LEFT JOIN wcga6_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
2 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM wcga6_virtuemart_category_categories AS `xref`
2 × SELECT id
FROM wcga6_assets
2 × SELECT *
FROM `wcga6_virtuemart_shoppergroups`
1 × SELECT `virtuemart_state_id`
FROM wcga6_virtuemart_calc_states
1 × SELECT `virtuemart_manufacturer_id`
FROM wcga6_virtuemart_calc_manufacturers
1 × SELECT `virtuemart_country_id`
FROM wcga6_virtuemart_calc_countries
1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `wcga6_virtuemart_vendors` AS v
LEFT JOIN `wcga6_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
1 × SELECT *
FROM `wcga6_rsseo_keywords`
1 × SELECT `price_display`,`custom_price_display`
FROM `wcga6_virtuemart_shoppergroups` AS `sg`
1 × SELECT *
FROM `wcga6_virtuemart_currencies`
1 × SELECT `virtuemart_category_id`
FROM wcga6_virtuemart_calc_categories
1 × SELECT `virtuemart_shoppergroup_id`
FROM wcga6_virtuemart_calc_shoppergroups
1 × SELECT l.`virtuemart_product_id`
FROM `wcga6_virtuemart_products_it_it` as l JOIN `wcga6_virtuemart_products` AS p using (`virtuemart_product_id`)
LEFT JOIN `wcga6_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
LEFT JOIN `wcga6_virtuemart_product_shoppergroups`
ON p.`virtuemart_product_id` = `wcga6_virtuemart_product_shoppergroups`.`virtuemart_product_id`
LEFT
OUTER JOIN `wcga6_virtuemart_shoppergroups` as s
ON s.`virtuemart_shoppergroup_id` = `wcga6_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
1 × SELECT id, home, template, s.params
FROM wcga6_template_styles as s
LEFT JOIN wcga6_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM wcga6_menu AS m
LEFT JOIN wcga6_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `config`
FROM `wcga6_virtuemart_configs`
1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `wcga6_virtuemart_permgroups`
1 × SELECT *
FROM wcga6_languages
1 × SELECT *
FROM `wcga6_rsseo_redirects`
1 × SELECT `enabled`
FROM `wcga6_extensions`
1 × SELECT `session_id`
FROM `wcga6_session`
1 × SELECT b.id
FROM wcga6_usergroups AS a
LEFT JOIN wcga6_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `wcga6_viewlevels
1 × SELECT folder AS type, element AS name, params
FROM wcga6_extensions
1 × SELECT a.rules
FROM wcga6_assets AS a
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
FROM wcga6_contact_details AS contact
1 × SELECT *
FROM `wcga6_acymailing_fields` as a
1 × SELECT a.id,a.alias,a.catid, c.alias as catalias
FROM wcga6_content as a
LEFT JOIN wcga6_categories AS c
ON c.id = a.catid
1 × SELECT *
FROM `wcga6_menu`
1 × SELECT `virtuemart_shoppergroup_id`
FROM `wcga6_virtuemart_vmuser_shoppergroups`
1 × SELECT *
FROM wcga6_acymailing_list
1 × SELECT *
FROM wcga6_acymailing_confi
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM wcga6_categories as c
LEFT JOIN wcga6_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM wcga6_categories AS cat JOIN wcga6_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT `params`
FROM wcga6_extensions
1 × SELECT `id`, `title`, `description`, `keywords`, `level`, `crawled`, `modified`, `canonical`, `robots`
FROM `wcga6_rsseo_pages`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM wcga6_modules AS m
LEFT JOIN wcga6_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN wcga6_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT `data`
FROM `wcga6_session`
1 × UPDATE `wcga6_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1679840948;s:18:\"session.timer.last\";i:1679840948;s:17:\"session.timer.now\";i:1679840948;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}VMCHECK|s:7:\"NOCHECK\";__vm|a:1:{s:6:\"vmcart\";s:645:\"O:8:\"stdClass\":24:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:20:\"_triesValidateCoupon\";a:0:{}s:14:\"order_language\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";b:1;s:15:\"customer_number\";s:7:\"nonreg_\";}\";}' , `time` = '1679840949'
1 × SHOW FULL COLUMNS
FROM `wcga6_assets
1 × UPDATE wcga6_content
SET hits = hits + 1
1 × SHOW TABLES LIKE "wcga6_virtuemart_configs
1 × INSERT INTO `wcga6_session` (`session_id`, `client_id`, `time`)
VALUES ('d09d67b2bb66c12ee01f856c77487c1f', 0, '1679840948'