Welcome to HAIHUY
Giấy phép số: (Giấy chứng nhận DKKD): 1800493740
Do Sở KH&ĐT Thành Phố Cần Thơ cấp ngày 12/12/2002
Người đại diện pháp luật: (Bà) Võ Trần Phương Thanh
Đ/c: 71A, CMT8, P.An Hòa, Q.Ninh Kiều, TP.Cần Thơ
Điện thoại: +84-292-3825 455 | Fax: +84-292-3827 455 |
Website: https://haihuy.net
|
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
link ⇒ https://cameravn.net/2019-05-16-09-54-32/gioi-thieu.html
Application 0.000 seconds (+0.000); 0.61 MB (+0.613) - afterLoad
Application 0.056 seconds (+0.056); 5.02 MB (+4.403) - afterInitialise
Application 0.108 seconds (+0.052); 8.51 MB (+3.496) - afterRoute
Application 0.172 seconds (+0.064); 10.83 MB (+2.317) - afterDispatch
Application 0.199 seconds (+0.027); 12.82 MB (+1.989) - beforeRenderModule mod_custom (img zoom)
Application 0.202 seconds (+0.002); 12.89 MB (+0.074) - afterRenderModule mod_custom (img zoom)
Application 0.202 seconds (+0.000); 12.89 MB (-0.004) - beforeRenderModule mod_custom (code)
Application 0.202 seconds (+0.000); 12.89 MB (+0.005) - afterRenderModule mod_custom (code)
Application 0.202 seconds (+0.000); 12.89 MB (-0.004) - beforeRenderModule mod_custom (code)
Application 0.203 seconds (+0.000); 12.89 MB (+0.005) - afterRenderModule mod_custom (code)
Application 0.203 seconds (+0.001); 12.90 MB (+0.002) - beforeRenderModule mod_menu (Menu footer)
Application 0.213 seconds (+0.009); 13.01 MB (+0.111) - afterRenderModule mod_menu (Menu footer)
Application 0.213 seconds (+0.000); 13.00 MB (-0.008) - beforeRenderModule mod_custom (Kết nối với chúng tôi)
Application 0.213 seconds (+0.001); 13.01 MB (+0.010) - afterRenderModule mod_custom (Kết nối với chúng tôi)
Application 0.213 seconds (+0.000); 13.01 MB (-0.003) - beforeRenderModule mod_custom (Bản đồ)
Application 0.214 seconds (+0.000); 13.01 MB (+0.005) - afterRenderModule mod_custom (Bản đồ)
Application 0.214 seconds (+0.000); 13.01 MB (-0.003) - beforeRenderModule mod_custom (CÔNG TY CỔ PHẦN ĐIỆN - ĐIỆN TỬ HẢI HUY)
Application 0.214 seconds (+0.000); 13.01 MB (+0.005) - afterRenderModule mod_custom (CÔNG TY CỔ PHẦN ĐIỆN - ĐIỆN TỬ HẢI HUY)
Application 0.215 seconds (+0.001); 13.02 MB (+0.007) - beforeRenderModule mod_menu (Danh mục sản phẩm)
Application 0.263 seconds (+0.049); 13.27 MB (+0.250) - afterRenderModule mod_menu (Danh mục sản phẩm)
Application 0.264 seconds (+0.000); 13.26 MB (-0.010) - beforeRenderModule mod_menu (Thông tin)
Application 0.271 seconds (+0.007); 13.31 MB (+0.047) - afterRenderModule mod_menu (Thông tin)
Application 0.271 seconds (+0.000); 13.30 MB (-0.006) - beforeRenderModule mod_mt_visitcounter (Thống kê truy cập)
Application 1.741 seconds (+1.470); 178.52 MB (+165.222) - afterRenderModule mod_mt_visitcounter (Thống kê truy cập)
Application 1.792 seconds (+0.051); 29.25 MB (-149.275) - beforeRenderModule mod_custom (Demo xem camera)
Application 1.793 seconds (+0.001); 29.25 MB (+0.005) - afterRenderModule mod_custom (Demo xem camera)
Application 1.793 seconds (+0.000); 29.25 MB (-0.004) - beforeRenderModule mod_custom (Hỗ trợ online)
Application 1.793 seconds (+0.000); 29.25 MB (+0.005) - afterRenderModule mod_custom (Hỗ trợ online)
Application 1.795 seconds (+0.002); 29.31 MB (+0.056) - beforeRenderModule mod_menu (Menu ngang)
Application 1.799 seconds (+0.004); 29.33 MB (+0.022) - afterRenderModule mod_menu (Menu ngang)
Application 1.799 seconds (+0.000); 29.32 MB (-0.007) - beforeRenderModule mod_custom (Welcome to Haihuy Moblie)
Application 1.799 seconds (+0.000); 29.33 MB (+0.005) - afterRenderModule mod_custom (Welcome to Haihuy Moblie)
Application 1.799 seconds (+0.000); 29.33 MB (-0.003) - beforeRenderModule mod_virtuemart_search (Tìm kiếm)
Application 1.847 seconds (+0.047); 30.51 MB (+1.185) - afterRenderModule mod_virtuemart_search (Tìm kiếm)
Application 1.848 seconds (+0.002); 30.52 MB (+0.005) - beforeRenderModule mod_custom (Tên công ty)
Application 1.849 seconds (+0.001); 30.52 MB (+0.005) - afterRenderModule mod_custom (Tên công ty)
Application 1.849 seconds (+0.000); 30.52 MB (-0.003) - beforeRenderModule mod_custom (Hotlines)
Application 1.850 seconds (+0.001); 30.52 MB (+0.005) - afterRenderModule mod_custom (Hotlines)
Application 1.850 seconds (+0.000); 30.52 MB (-0.000) - beforeRenderModule mod_custom (Welcome to HAIHUY)
Application 1.851 seconds (+0.001); 30.53 MB (+0.005) - afterRenderModule mod_custom (Welcome to HAIHUY)
Application 1.851 seconds (+0.000); 30.52 MB (-0.003) - beforeRenderModule mod_custom (Logo)
Application 1.852 seconds (+0.001); 30.53 MB (+0.005) - afterRenderModule mod_custom (Logo)
Application 1.989 seconds (+0.137); 30.76 MB (+0.230) - afterRender
30.81 MB (32,304,408 Bytes)
SELECT `data`
FROM `z0djb_session`
WHERE `session_id` = 'ckrip0huq8154nvqvhs6e90ka3'
DELETE
FROM `z0djb_session`
WHERE `time` < '1611097617'
SELECT `session_id`
FROM `z0djb_session`
WHERE `session_id` = 'ckrip0huq8154nvqvhs6e90ka3'
LIMIT 0, 1
INSERT INTO `z0djb_session`
(`session_id`, `client_id`, `time`)
VALUES
('ckrip0huq8154nvqvhs6e90ka3', 0, '1611101217')
SELECT extension_id AS id, element AS "option", params, enabled
FROM z0djb_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM z0djb_usergroups AS a
LEFT JOIN z0djb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `z0djb_viewlevels`
SELECT folder AS type, element AS name, params
FROM z0djb_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1)
ORDER BY ordering
SELECT *
FROM z0djb_languages
WHERE published=1
ORDER BY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled
FROM z0djb_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT COUNT(*)
FROM `z0djb_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
SELECT extension_id AS id, element AS "option", params, enabled
FROM z0djb_extensions
WHERE `type` = 'component'
AND `element` = 'com_k2'
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 z0djb_menu AS m
LEFT JOIN z0djb_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 z0djb_template_styles as s
LEFT JOIN z0djb_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
SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM z0djb_modules AS m
LEFT JOIN z0djb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN z0djb_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 <= '2021-01-20 00:06:57')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-20 00:06:57')
AND m.access IN (1)
AND m.client_id = 0
AND (mm.menuid = 1092 OR mm.menuid <= 0)
AND m.language IN ('vi-VN','*')
ORDER BY m.position, m.ordering
SELECT a.rules
FROM z0djb_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM z0djb_assets AS a
LEFT JOIN z0djb_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_k2')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT id
FROM z0djb_k2_categories
WHERE published=1
AND trash=0
AND access IN(1)
SELECT *
FROM z0djb_k2_items
WHERE id=69
AND language IN ('vi-VN','*')
LIMIT 0, 1
SHOW FULL COLUMNS
FROM `z0djb_k2_categories`
SELECT *
FROM z0djb_k2_categories
WHERE id = '24'
SELECT id, name, parent
FROM z0djb_k2_categories
WHERE published=1
AND trash=0
AND access IN(1)
AND language IN('vi-VN', '*')
ORDER BY parent
SELECT COUNT(*)
FROM z0djb_k2_comments
WHERE itemID=69
AND published=1
SHOW FULL COLUMNS
FROM `z0djb_k2_items`
UPDATE z0djb_k2_items
SET `hits` = (`hits` + 1)
WHERE id = '69'
SHOW TABLES LIKE "z0djb_virtuemart_configs"
SELECT `config`
FROM `z0djb_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `z0djb_virtuemart_permgroups`
ORDER BY `group_level`
SELECT extension_id AS id, element AS "option", params, enabled
FROM z0djb_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'
SELECT *
FROM `z0djb_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language LIKE "vi_vn")
SELECT *
FROM z0djb_mt_visitcounter
WHERE ip='ckrip0huq8154nvqvhs6e90ka3'
AND ngay='2021-01-20'
INSERT INTO z0djb_mt_visitcounter (ip,ngay)
VALUES ('ckrip0huq8154nvqvhs6e90ka3','2021-01-20')
SELECT *
FROM z0djb_session
WHERE username<>'admin'
AND username<>'quantri'
SELECT *
FROM z0djb_mt_visitcounter
WHERE ngay='2021-01-20'
SELECT *
FROM z0djb_mt_visitcounter
WHERE ngay BETWEEN '2021-01-01'
AND '2021-01-31'
SELECT *
FROM z0djb_mt_visitcounter
WHERE ngay BETWEEN '2020-12-01'
AND '2020-12-31'
SELECT *
FROM z0djb_mt_visitcounter
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 0
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "223"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "185"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "177"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "77"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 223
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 185
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 177
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 77
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "239"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "222"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "208"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "190"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "178"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "176"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "175"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "174"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "161"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "106"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "100"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "99"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "98"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "97"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "93"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "81"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "84"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "82"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "80"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "79"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "78"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 239
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "240"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 240
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 222
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "230"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "227"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 230
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "234"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "233"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "232"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "231"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 234
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 233
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 232
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 231
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 227
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 208
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "242"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "241"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "238"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "213"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "212"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "211"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "210"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "209"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "105"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "104"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "103"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "102"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "101"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 242
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 241
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 238
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 213
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 212
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 211
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 210
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 209
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 105
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 104
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 103
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 102
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 101
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 190
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "243"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "189"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "83"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 243
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 189
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 83
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 178
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "183"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "182"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "181"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "180"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "179"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 183
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 182
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 181
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 180
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 179
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 176
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 175
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "214"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "150"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 214
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 150
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 174
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "221"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "220"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "219"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "218"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "217"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "216"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "162"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 221
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 220
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 219
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 218
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 217
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 216
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 162
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "207"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "206"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "205"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "204"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "203"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "202"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 207
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 206
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 205
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 204
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 203
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 202
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 161
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "172"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "171"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "170"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "169"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "168"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "167"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "166"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "165"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "164"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "163"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 172
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 171
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 170
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 169
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 168
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 167
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 166
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 165
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 164
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 163
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 106
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "237"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "236"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "235"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 237
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 236
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 235
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 100
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 99
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 98
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "120"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "119"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "118"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "117"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "116"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "115"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "114"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "113"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "112"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "111"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "110"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "109"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 120
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 119
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 118
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 117
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 116
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 115
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 114
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 113
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 112
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 111
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 110
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 109
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 97
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "173"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "136"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "135"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "134"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "133"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "132"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "131"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "130"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "129"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "128"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "127"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "126"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "125"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "124"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "123"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "122"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "121"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 173
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 136
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 135
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 134
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 133
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 132
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 131
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 130
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 129
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 128
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 127
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 126
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 125
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 124
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 123
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 122
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 121
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 93
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 81
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 84
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 82
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 80
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 79
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 78
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "229"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "226"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "225"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "224"
ORDER BY `ordering`
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 229
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 226
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 225
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 224
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, C.`created_on` DESC
SELECT *
FROM z0djb_virtuemart_customs
WHERE field_type = 'I'
AND published=1
SELECT *
FROM z0djb_virtuemart_customs
WHERE field_type = 'I'
AND published=1
UPDATE `z0djb_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1611101217;s:18:\"session.timer.last\";i:1611101217;s:17:\"session.timer.now\";i:1611101217;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\":26:{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:1:{i:0;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;s:3:\"gid\";i:1000;}s:16:\"com_mailto.links\";a:1:{s:40:\"487ab7ff40a37a00ea6ef05b0e5d61daa80d2fd1\";O:8:\"stdClass\":2:{s:4:\"link\";s:56:\"https://cameravn.net/2019-05-16-09-54-32/gioi-thieu.html\";s:6:\"expiry\";i:1611101218;}}}'
, `time` = '1611101219'
WHERE `session_id` = 'ckrip0huq8154nvqvhs6e90ka3'
115 × SELECT L.*
FROM `z0djb_virtuemart_categories_vi_vn` as L
JOIN `z0djb_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `z0djb_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
114 × SELECT `virtuemart_media_id`
FROM `z0djb_virtuemart_category_medias`
4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM z0djb_extensions
4 × SELECT *
FROM z0djb_mt_visitcounter
2 × SELECT *
FROM z0djb_virtuemart_customs
1 × SELECT COUNT(*)
FROM z0djb_k2_comments
1 × SELECT `config`
FROM `z0djb_virtuemart_configs`
1 × SELECT *
FROM z0djb_k2_categories
1 × SELECT id, name, parent
FROM z0djb_k2_categories
1 × SELECT *
FROM z0djb_session
1 × SELECT *
FROM z0djb_mt_visitcounte
1 × SELECT *
FROM z0djb_k2_items
1 × SELECT *
FROM `z0djb_menu`
1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `z0djb_virtuemart_permgroups`
1 × SELECT id
FROM z0djb_k2_categories
1 × SELECT folder AS type, element AS name, params
FROM z0djb_extensions
1 × SELECT *
FROM z0djb_languages
1 × SELECT id, rules
FROM `z0djb_viewlevels
1 × SELECT b.id
FROM z0djb_usergroups AS a
LEFT JOIN z0djb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `z0djb_session`
1 × SELECT COUNT(*)
FROM `z0djb_menu`
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 z0djb_menu AS m
LEFT JOIN z0djb_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT b.rules
FROM z0djb_assets AS a
LEFT JOIN z0djb_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT a.rules
FROM z0djb_assets AS a
1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM z0djb_modules AS m
LEFT JOIN z0djb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN z0djb_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT id, home, template, s.params
FROM z0djb_template_styles as s
LEFT JOIN z0djb_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `data`
FROM `z0djb_session`
1 × SHOW TABLES LIKE "z0djb_virtuemart_configs
1 × INSERT INTO z0djb_mt_visitcounter (ip,ngay)
VALUES ('ckrip0huq8154nvqvhs6e90ka3','2021-01-20'
1 × UPDATE `z0djb_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1611101217;s:18:\"session.timer.last\";i:1611101217;s:17:\"session.timer.now\";i:1611101217;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\":26:{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:1:{i:0;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;s:3:\"gid\";i:1000;}s:16:\"com_mailto.links\";a:1:{s:40:\"487ab7ff40a37a00ea6ef05b0e5d61daa80d2fd1\";O:8:\"stdClass\":2:{s:4:\"link\";s:56:\"https://cameravn.net/2019-05-16-09-54-32/gioi-thieu.html\";s:6:\"expiry\";i:1611101218;}}}' , `time` = '1611101219'
1 × UPDATE z0djb_k2_items
SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS
FROM `z0djb_k2_items
1 × INSERT INTO `z0djb_session` (`session_id`, `client_id`, `time`)
VALUES ('ckrip0huq8154nvqvhs6e90ka3', 0, '1611101217'
1 × SHOW FULL COLUMNS
FROM `z0djb_k2_categories
1 × DELETE
FROM `z0djb_session`