SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')<br/>SELECT `data` FROM `oc_session` WHERE `session_id` = '08c7b3da2c0c1d442fa9a9c6a3' AND `expire` > '2026-10-05 09:16:30'<br/>SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://ethoscreations.com/'<br/>SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC<br/>SELECT * FROM oc_currency<br/>SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '223' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3669') ORDER BY tr1.priority ASC<br/>SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '223' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3669') ORDER BY tr1.priority ASC<br/>SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'<br/>SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'<br/>SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC<br/>SELECT * FROM oc_seo_url WHERE keyword = 'Blog' AND store_id = '0'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'plaza/blog' OR route = 'en-gb')<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'<br/>SELECT COUNT(DISTINCT p.post_id) AS total FROM oc_ptpost p LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id)  LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) WHERE pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1' <br/>SELECT p.post_id  FROM oc_ptpost p LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id)  LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) WHERE pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1'  GROUP BY p.post_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,10<br/>SELECT DISTINCT p.post_id, p.image, p.author, p.sort_order, p.status, p.date_added, p.date_modified, pd.language_id, pd.name, pd.description, pd.intro_text, pd.meta_title, pd.meta_description, pd.meta_keyword FROM oc_ptpost p LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id) WHERE p.post_id = '2' AND pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1' <br/>SELECT DISTINCT p.post_id, p.image, p.author, p.sort_order, p.status, p.date_added, p.date_modified, pd.language_id, pd.name, pd.description, pd.intro_text, pd.meta_title, pd.meta_description, pd.meta_keyword FROM oc_ptpost p LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id) WHERE p.post_id = '3' AND pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1' <br/>SELECT DISTINCT p.post_id, p.image, p.author, p.sort_order, p.status, p.date_added, p.date_modified, pd.language_id, pd.name, pd.description, pd.intro_text, pd.meta_title, pd.meta_description, pd.meta_keyword FROM oc_ptpost p LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id) WHERE p.post_id = '1' AND pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1' <br/>SELECT DISTINCT p.post_id, p.image, p.author, p.sort_order, p.status, p.date_added, p.date_modified, pd.language_id, pd.name, pd.description, pd.intro_text, pd.meta_title, pd.meta_description, pd.meta_keyword FROM oc_ptpost p LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id) WHERE p.post_id = '4' AND pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1' <br/>SELECT DISTINCT p.post_id, p.image, p.author, p.sort_order, p.status, p.date_added, p.date_modified, pd.language_id, pd.name, pd.description, pd.intro_text, pd.meta_title, pd.meta_description, pd.meta_keyword FROM oc_ptpost p LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id) WHERE p.post_id = '6' AND pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1' <br/>SELECT DISTINCT p.post_id, p.image, p.author, p.sort_order, p.status, p.date_added, p.date_modified, pd.language_id, pd.name, pd.description, pd.intro_text, pd.meta_title, pd.meta_description, pd.meta_keyword FROM oc_ptpost p LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id) WHERE p.post_id = '5' AND pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1' <br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/post' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_id=2' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/post' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_id=3' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/post' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_id=1' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/post' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_id=4' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/post' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_id=6' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/post' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_id=5' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_ptpost_list pl LEFT JOIN oc_ptpost_list_description pld ON (pl.post_list_id = pld.post_list_id) LEFT JOIN oc_ptpost_list_to_store pls ON (pl.post_list_id = pls.post_list_id) WHERE pl.post_list_id = '1' AND pld.language_id = '1' AND pls.store_id = '0' AND pl.status = '1' <br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_list_id=1' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_ptpost_list pl LEFT JOIN oc_ptpost_list_description pld ON (pl.post_list_id = pld.post_list_id) LEFT JOIN oc_ptpost_list_to_store pls ON (pl.post_list_id = pls.post_list_id) WHERE pl.post_list_id = '2' AND pld.language_id = '1' AND pls.store_id = '0' AND pl.status = '1' <br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_list_id=2' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_ptpost_list pl LEFT JOIN oc_ptpost_list_description pld ON (pl.post_list_id = pld.post_list_id) LEFT JOIN oc_ptpost_list_to_store pls ON (pl.post_list_id = pls.post_list_id) WHERE pl.post_list_id = '3' AND pld.language_id = '1' AND pls.store_id = '0' AND pl.status = '1' <br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_list_id=3' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_ptpost_list pl LEFT JOIN oc_ptpost_list_description pld ON (pl.post_list_id = pld.post_list_id) LEFT JOIN oc_ptpost_list_to_store pls ON (pl.post_list_id = pls.post_list_id) WHERE pl.post_list_id = '4' AND pld.language_id = '1' AND pls.store_id = '0' AND pl.status = '1' <br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_list_id=4' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/blog/widget/cate_list'<br/>SELECT p.post_id  FROM oc_ptpost p LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id)  LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) WHERE pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1'  GROUP BY p.post_id ORDER BY p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,5<br/>SELECT DISTINCT p.post_id, p.image, p.author, p.sort_order, p.status, p.date_added, p.date_modified, pd.language_id, pd.name, pd.description, pd.intro_text, pd.meta_title, pd.meta_description, pd.meta_keyword FROM oc_ptpost p LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id) WHERE p.post_id = '6' AND pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1' <br/>SELECT DISTINCT p.post_id, p.image, p.author, p.sort_order, p.status, p.date_added, p.date_modified, pd.language_id, pd.name, pd.description, pd.intro_text, pd.meta_title, pd.meta_description, pd.meta_keyword FROM oc_ptpost p LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id) WHERE p.post_id = '5' AND pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1' <br/>SELECT DISTINCT p.post_id, p.image, p.author, p.sort_order, p.status, p.date_added, p.date_modified, pd.language_id, pd.name, pd.description, pd.intro_text, pd.meta_title, pd.meta_description, pd.meta_keyword FROM oc_ptpost p LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id) WHERE p.post_id = '4' AND pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1' <br/>SELECT DISTINCT p.post_id, p.image, p.author, p.sort_order, p.status, p.date_added, p.date_modified, pd.language_id, pd.name, pd.description, pd.intro_text, pd.meta_title, pd.meta_description, pd.meta_keyword FROM oc_ptpost p LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id) WHERE p.post_id = '3' AND pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1' <br/>SELECT DISTINCT p.post_id, p.image, p.author, p.sort_order, p.status, p.date_added, p.date_modified, pd.language_id, pd.name, pd.description, pd.intro_text, pd.meta_title, pd.meta_description, pd.meta_keyword FROM oc_ptpost p LEFT JOIN oc_ptpost_description pd ON (p.post_id = pd.post_id) LEFT JOIN oc_ptpost_to_store pts ON (p.post_id = pts.post_id) WHERE p.post_id = '2' AND pd.language_id = '1' AND pts.store_id = '0' AND p.status = '1' <br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/post' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_id=6' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/post' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_id=5' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/post' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_id=4' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/post' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_id=3' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'plaza/blog/post' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'post_id=2' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/blog/widget/latest_blog'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'column_left' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/column_left'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'column_right' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/column_right'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'content_top' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/content_top'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'content_bottom' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/content_bottom'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'en-gb')<br/>SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information_id=20' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information_id=4' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information_id=6' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information_id=3' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information_id=5' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information_id=7' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/return/add' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/sitemap' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/tracking' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/voucher' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'affiliate/login' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/newsletter' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position1' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position1'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position2' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '33'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'plaza/module/ptmenu' OR route = 'en-gb')<br/>SELECT * FROM `oc_ptmegamenu` WHERE menu_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_top_item` m WHERE m.menu_id = '1' ORDER BY m.position ASC<br/>SELECT * FROM oc_language WHERE code = 'en-gb'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '1' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '2' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '2'<br/>SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '164' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'category_id=164' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '19' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '19'<br/>SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '29' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '29'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '28' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '28'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '17' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '17'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptmenu'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position2'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position3' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '35'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'plaza/module/ptmenu' OR route = 'en-gb')<br/>SELECT * FROM `oc_ptmegamenu` WHERE menu_id = '3'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_top_item` m WHERE m.menu_id = '3' ORDER BY m.position ASC<br/>SELECT * FROM oc_language WHERE code = 'en-gb'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '11' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '11'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '24' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '24'<br/>SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '164' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'category_id=164' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '25' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '25'<br/>SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '31' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '31'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '27' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '27'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information_id=4' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '30' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '30'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '16' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '16'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptmenu'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position3'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position4' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position4'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position5' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position5'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position6' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '41'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptstaticblock'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position6'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position7' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '76'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptstaticblock'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position7'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position8' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '44'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptstaticblock'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position8'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position9' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '42'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'plaza/module/ptnewsletter' OR route = 'en-gb')<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptnewsletter'<br/>SELECT * FROM oc_module WHERE module_id = '45'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptstaticblock'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position9'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position10' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position10'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/footer'<br/>SELECT * FROM oc_extension WHERE `type` = 'analytics'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'en-gb')<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/transaction' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/download' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'en-gb')<br/>SELECT * FROM oc_seo_url WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/language'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'en-gb')<br/>SELECT * FROM oc_seo_url WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/currency'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'plaza/module/ptsearch' OR route = 'en-gb')<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1172' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1099' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1100' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1160' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1174' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1101' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1108' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1196' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '300' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1159' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1165' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1168' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1175' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1187' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1184' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1158' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1176' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1253' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1252' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1251' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1250' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1249' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1248' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1246' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1245' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1254' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1255' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1256' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1257' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1258' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1259' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1260' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1261' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1262' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1263' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1264' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1265' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1266' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1267' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1268' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1269' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1270' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1271' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1272' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1273' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1274' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1275' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1276' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1277' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1278' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1279' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1280' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1281' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1282' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1283' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1284' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1285' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1286' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1287' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1288' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1289' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1290' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1291' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1292' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1293' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1294' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1295' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1296' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1297' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1298' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1299' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1300' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1301' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1303' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1304' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1305' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1306' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1307' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1308' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1309' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1310' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1311' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1312' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1313' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1314' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1315' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1316' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1317' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1318' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1319' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1320' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1321' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1322' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1323' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1324' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1325' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1326' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1327' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1328' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1185' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1093' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1081' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1244' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1302' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1183' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1189' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1157' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1247' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1098' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1162' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1166' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1167' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1169' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1148' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '311' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1075' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1186' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1200' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1201' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1146' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '240' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1224' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1226' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1225' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1077' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1080' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1078' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1076' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1106' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '329' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1079' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1179' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1180' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1154' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1125' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1163' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '62' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '321' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1207' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '309' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1177' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1170' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '327' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '328' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1155' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1164' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1173' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1109' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1147' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1105' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1197' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1202' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1198' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1215' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1211' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1213' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1205' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '60' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '324' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '320' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '325' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '123' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '75' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '318' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '312' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '61' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '314' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '319' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '313' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '315' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/search' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'extension/module/ptsearch/ajaxSearch' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/search/form'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'en-gb')<br/>SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '08c7b3da2c0c1d442fa9a9c6a3'<br/>SELECT * FROM oc_extension WHERE `type` = 'total'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'en-gb')<br/>SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '08c7b3da2c0c1d442fa9a9c6a3'<br/>SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '08c7b3da2c0c1d442fa9a9c6a3'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'en-gb')<br/>SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'en-gb')<br/>SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '08c7b3da2c0c1d442fa9a9c6a3'<br/>SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '08c7b3da2c0c1d442fa9a9c6a3'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/cart'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'en-gb')<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/menu'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position1' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position1'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position2' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '33'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'plaza/module/ptmenu' OR route = 'en-gb')<br/>SELECT * FROM `oc_ptmegamenu` WHERE menu_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_top_item` m WHERE m.menu_id = '1' ORDER BY m.position ASC<br/>SELECT * FROM oc_language WHERE code = 'en-gb'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '1' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '2' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '2'<br/>SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '164' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'category_id=164' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '19' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '19'<br/>SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '29' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '29'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '28' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '28'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '17' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '17'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptmenu'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position2'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position3' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '35'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'plaza/module/ptmenu' OR route = 'en-gb')<br/>SELECT * FROM `oc_ptmegamenu` WHERE menu_id = '3'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_top_item` m WHERE m.menu_id = '3' ORDER BY m.position ASC<br/>SELECT * FROM oc_language WHERE code = 'en-gb'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '11' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '11'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '24' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '24'<br/>SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '164' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'category_id=164' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '25' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '25'<br/>SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '31' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '31'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '27' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '27'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information_id=4' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '30' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '30'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '16' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '16'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptmenu'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position3'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position4' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position4'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position5' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position5'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position6' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '41'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptstaticblock'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position6'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position7' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '76'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptstaticblock'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position7'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position8' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '44'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptstaticblock'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position8'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position9' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '42'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'plaza/module/ptnewsletter' OR route = 'en-gb')<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptnewsletter'<br/>SELECT * FROM oc_module WHERE module_id = '45'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptstaticblock'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position9'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position10' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position10'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'en-gb')<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/transaction' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/download' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'en-gb')<br/>SELECT * FROM oc_seo_url WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/language'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'en-gb')<br/>SELECT * FROM oc_seo_url WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/currency'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'en-gb')<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/search'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'en-gb')<br/>SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '08c7b3da2c0c1d442fa9a9c6a3'<br/>SELECT * FROM oc_extension WHERE `type` = 'total'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'en-gb')<br/>SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '08c7b3da2c0c1d442fa9a9c6a3'<br/>SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '08c7b3da2c0c1d442fa9a9c6a3'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'en-gb')<br/>SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'en-gb')<br/>SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '08c7b3da2c0c1d442fa9a9c6a3'<br/>SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '08c7b3da2c0c1d442fa9a9c6a3'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/cart'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'en-gb')<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/menu'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'plaza/module/ptsearch' OR route = 'en-gb')<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1172' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1099' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1100' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1160' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1174' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1101' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1108' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1196' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '300' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1159' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1165' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1168' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1175' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1187' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1184' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1158' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1176' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1253' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1252' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1251' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1250' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1249' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1248' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1246' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1245' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1254' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1255' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1256' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1257' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1258' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1259' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1260' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1261' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1262' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1263' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1264' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1265' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1266' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1267' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1268' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1269' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1270' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1271' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1272' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1273' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1274' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1275' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1276' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1277' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1278' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1279' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1280' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1281' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1282' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1283' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1284' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1285' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1286' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1287' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1288' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1289' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1290' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1291' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1292' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1293' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1294' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1295' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1296' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1297' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1298' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1299' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1300' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1301' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1303' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1304' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1305' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1306' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1307' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1308' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1309' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1310' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1311' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1312' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1313' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1314' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1315' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1316' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1317' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1318' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1319' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1320' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1321' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1322' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1323' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1324' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1325' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1326' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1327' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1328' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1185' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1093' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1081' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1244' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1302' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1183' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1189' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1157' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1247' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1098' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1162' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1166' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1167' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1169' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1148' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '311' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1075' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1186' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1200' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1201' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1146' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '240' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1224' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1226' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1225' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1077' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1080' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1078' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1076' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1106' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '329' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1079' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1179' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1180' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1154' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1125' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1163' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '62' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '321' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1207' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '309' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1177' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1170' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '327' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '328' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1155' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1164' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1173' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1109' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1147' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1105' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1197' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1202' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1198' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1215' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1211' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1213' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1205' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '60' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '324' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '320' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '325' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '123' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '75' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '318' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '312' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '61' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '314' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '319' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '313' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '315' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/search' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'extension/module/ptsearch/ajaxSearch' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/search/form'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position1' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position1'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position2' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '33'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'plaza/module/ptmenu' OR route = 'en-gb')<br/>SELECT * FROM `oc_ptmegamenu` WHERE menu_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_top_item` m WHERE m.menu_id = '1' ORDER BY m.position ASC<br/>SELECT * FROM oc_language WHERE code = 'en-gb'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '1' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '2' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '2'<br/>SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '164' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'category_id=164' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '19' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '19'<br/>SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '29' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '29'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '28' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '28'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '17' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '17'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptmenu'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position2'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position3' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '35'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'plaza/module/ptmenu' OR route = 'en-gb')<br/>SELECT * FROM `oc_ptmegamenu` WHERE menu_id = '3'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_top_item` m WHERE m.menu_id = '3' ORDER BY m.position ASC<br/>SELECT * FROM oc_language WHERE code = 'en-gb'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '11' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '11'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '24' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '24'<br/>SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '164' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'category_id=164' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '25' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '25'<br/>SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '31' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '31'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '27' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '27'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information_id=4' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '30' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '30'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'<br/>SELECT DISTINCT * FROM `oc_ptmegamenu_sub_item` m WHERE m.parent_menu_item_id = '16' AND m.level = '2' ORDER BY m.position ASC<br/>SELECT * FROM oc_ptmegamenu_top_item_description WHERE menu_item_id = '16'<br/>SELECT * FROM oc_seo_url WHERE `query` = 'ptblog' AND store_id = '0' AND language_id = '1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptmenu'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position3'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position4' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position4'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position5' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position5'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position6' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '41'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptstaticblock'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position6'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position7' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '76'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptstaticblock'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position7'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position8' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '44'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptstaticblock'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position8'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position9' ORDER BY sort_order<br/>SELECT * FROM oc_module WHERE module_id = '42'<br/>SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'plaza/module/ptnewsletter' OR route = 'en-gb')<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptnewsletter'<br/>SELECT * FROM oc_module WHERE module_id = '45'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/module/ptstaticblock'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position9'<br/>SELECT * FROM oc_layout_route WHERE 'plaza/blog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1<br/>SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'position10' ORDER BY sort_order<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/position10'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/page_section/header/header1'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'common/header'<br/>SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google'<br/>SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'tt_corano1' AND route = 'plaza/blog/list'<br/><!DOCTYPE html>
<!--[if IE]><![endif]-->
<!--[if IE 8 ]><html dir="ltr" lang="en" class="ie8"><![endif]-->
<!--[if IE 9 ]><html dir="ltr" lang="en" class="ie9"><![endif]-->
<!--[if (gt IE 9)|!(IE)]><!-->
<html dir="ltr" lang="en">
<!--<![endif]-->
<head>
    
    <meta name="facebook-domain-verification" content="3dwxeu1icwbq32xjx8s384lveavwxu" />
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Blog</title>
<base href="https://ethoscreations.com/" />
<meta name="description" content="Blog Description" />
<meta name="keywords" content="Blog Keyword" />
<link href="catalog/view/javascript/bootstrap/css/bootstrap.min.css" rel="stylesheet" media="screen" />
<link href="catalog/view/theme/default/stylesheet/ga-product-variant.css" type="text/css" rel="stylesheet" media="screen" />
<link href="catalog/view/javascript/jquery/swiper/css/swiper.min.css" rel="stylesheet" type="text/css" />
<!-- icon font -->
<link href="catalog/view/javascript/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css" />
<link href="catalog/view/javascript/ionicons/css/ionicons.css" rel="stylesheet" type="text/css" />
<!-- use for corano -->
<link href="catalog/view/javascript/pe-icon-7-stroke/css/pe-icon-7-stroke.css" rel="stylesheet" type="text/css" />
<link href="catalog/view/javascript/pe-icon-7-stroke/css/helper.css" rel="stylesheet" type="text/css" />
<!-- end icon font -->
<link href="catalog/view/theme/tt_corano1/stylesheet/stylesheet.css" rel="stylesheet">
<link href="catalog/view/theme/tt_corano1/stylesheet/plaza/header/header1.css" rel="stylesheet">
<link href="catalog/view/theme/tt_corano1/stylesheet/plaza/theme.css" rel="stylesheet">
<script src="catalog/view/javascript/jquery/jquery-2.1.1.min.js" ></script>
<script src="catalog/view/javascript/custom.js" type="text/javascript"></script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/elevatezoom/3.0.8/jquery.elevatezoom.min.js"></script>
<script src="catalog/view/javascript/jquery/swiper/js/swiper.min.js" ></script>
<script src="catalog/view/javascript/plaza/ultimatemenu/menu.js" ></script>
<script src="catalog/view/javascript/plaza/newsletter/mail.js" ></script>
<script src="catalog/view/javascript/ga_product_variant/pls_chooser.js" ></script>
<script src="catalog/view/javascript/common.js" ></script>
<link href="http://ethoscreations.com/Blog" rel="" />
<link href="https://ethoscreations.com/image/catalog/logo/500x500.png" rel="icon" />
<!-- Lazy Load -->
      <script src="catalog/view/javascript/plaza/lazyload/jquery.lazy.min.js" ></script>
    <script>
      $(function() {
        $('.lazy-img').lazy({
          effect: "fadeIn",
          effectTime: 100,
          threshold: 200
        });
      });
    </script>
    <!-- Quick view -->
      <script src="catalog/view/javascript/plaza/cloudzoom/cloud-zoom.1.0.2.min.js" ></script>
    <script src="catalog/view/javascript/plaza/cloudzoom/zoom.js" ></script>
    <script src="catalog/view/javascript/plaza/quickview/quickview.js" ></script>
    <link href="catalog/view/theme/tt_corano1/stylesheet/plaza/quickview/quickview.css" rel="stylesheet" type="text/css" />
    <!-- General -->
  <!-- Sticky Menu -->
  	<script >
	 $(document).ready(function () {	
		var height_box_scroll = $('.scroll-fix').outerHeight(true);
	  $(window).scroll(function () {
		if ($(this).scrollTop() > 400) {
			$('.scroll-fix').addClass("scroll-fixed");
			$('body').css('padding-top',height_box_scroll);
		} else {
			$('.scroll-fix').removeClass("scroll-fixed");
			$('body').css('padding-top',0);
		}
	  });
	});
	</script>
    <!-- Scroll Top -->
      <script>
      $("#back-top").hide();
      $(function () {
        $(window).scroll(function () {
          if ($(this).scrollTop() > $('body').height()/3) {
            $('#back-top').fadeIn();
          } else {
            $('#back-top').fadeOut();
          }
        });
        $('#back-top').click(function () {
          $('body,html').animate({scrollTop: 0}, 800);
          return false;
        });
      });
    </script>
    <!-- Advance -->
      <!-- Bootstrap Js -->
  <script src="catalog/view/javascript/bootstrap/js/bootstrap.min.js" ></script>
<meta name="google-site-verification" content="od8CYK8CfWdcb6KK9KtbolJqCC33knhLoHtV-a3OnfE" />
 <!--<meta name="google-site-verification" content="9998W5S1aTlMri0zEQHCfP4fg94e9UADn4pXFpOC1_I" />-->
<!-- Google tag (gtag.js) -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-05QQDP3HPS"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

  gtag('config', 'G-05QQDP3HPS');
</script>
</head>
<body class="plaza-blog">
<div class="wrapper">
  <div id="back-top"><i class="ion-chevron-up"></i></div>
<nav id="top">
  <div class="container">
    <div class="box-inner">
		<ul class="box-top box-top-left pull-left">
			<!--<li><a href="http://ethoscreations.com/information-contact"><i class="fa fa-phone"></i> <span class="hidden-xs hidden-sm hidden-md">1.866.283.4367</span></a></li>
							<li><a href="http://ethoscreations.com/index.php?route=checkout/cart" title="Shopping Cart"><i class="fa fa-shopping-cart"></i> <span class="hidden-xs hidden-sm hidden-md">Shopping Cart</span></a></li>
				<li><a href="https://ethoscreations.com/index.php?route=checkout/checkout" title="Checkout"><i class="fa fa-share"></i> <span class="hidden-xs hidden-sm hidden-md">Checkout</span></a></li>
			 -->
			<li><p>A Woman-Owned Business Enterprise (WBE)</p></li>
		</ul>
	
		<ul class="box-top box-top-right pull-right">
		    <li class="top-menu">Loose Diamond</li>
			<li class="top-menu">Catalog</li>
			<li class="top-menu">Display Program</li>
			<li class="top-menu">FAQs</li>
			<li class="top-menu">Contact Us</li>
			<li class="currency">
						    <form action="https://ethoscreations.com/index.php?route=common/currency/currency" method="post" enctype="multipart/form-data" id="form-currency" class="header-dropdown">
    <div class="btn-group">
      <button id="rc" class="btn btn-link dropdown-toggle" data-toggle="dropdown">                                                                                           <span></span>        <span class="hidden-xs hidden-sm">Currency</span>&nbsp;<i class="icon-right ion-ios-arrow-down"></i></button>
      <ul id="rc1" class="dropdown-menu hidden-xs">
                        <li>
          <button class="currency-select btn btn-link btn-block" type="button" name="AUD"> Australian Dollar</button>
        </li>
                                <li>
          <button class="currency-select btn btn-link btn-block" type="button" name="CAD"> Canada Dollar</button>
        </li>
                                <li>
          <button class="currency-select btn btn-link btn-block" type="button" name="EUR"> Euro</button>
        </li>
                                <li>
          <button class="currency-select btn btn-link btn-block" type="button" name="HKD"> Hong Kong Dollar</button>
        </li>
                                <li>
          <button class="currency-select btn btn-link btn-block" type="button" name="INR"> Indian Rupee </button>
        </li>
                                <li>
          <button class="currency-select btn btn-link btn-block" type="button" name="GBP"> Pound Sterling</button>
        </li>
                                <li>
          <button class="currency-select btn btn-link btn-block" type="button" name="AED"> UAE</button>
        </li>
                                <li>
          <button class="currency-select btn btn-link btn-block" type="button" name="USD"> US Dollar</button>
        </li>
                      </ul>
    </div>
    <input type="hidden" name="code" value="" />
    <input type="hidden" name="redirect" value="https://ethoscreations.com/Blog?layout=right" />
  </form>
 
						</li>
			<li class="language">
			  <form action="https://ethoscreations.com/index.php?route=common/language/language" method="post" enctype="multipart/form-data" id="form-language" class="header-dropdown">
    <div class="btn-group">
      <button class="btn btn-link dropdown-toggle" data-toggle="dropdown">
             
      <img src="catalog/language/en-gb/en-gb.png" alt="English" title="English">
                  <span class="hidden-xs hidden-sm">Language</span>&nbsp;<i class="icon-right ion-ios-arrow-down"></i></button>
      <ul class="dropdown-menu">
                <li>
          <button class="btn btn-link btn-block language-select" type="button" name="en-gb"><img src="catalog/language/en-gb/en-gb.png" alt="English" title="English" /> English</button>
        </li>
              </ul>
    </div>
    <input type="hidden" name="code" value="" />
    <input type="hidden" name="redirect" value="https://ethoscreations.com/Blog?layout=right" />
  </form>

			</li>
		
		</ul>
	</div>
  </div>
</nav>
<header class="scroll-fix">
	<div class="container">
		<div class="box-inner">
			<div class="box-inner-inner">
				<style>
    #pt-menu-3992 .pt-menu-bar {
        background: #FFFFFF;
        color: #242424;
		padding: 0px 0px 0px 0px;
    }
    #pt-menu-3992.pt-menu-bar {
        background: #FFFFFF;
        color: #242424;
    }
    #pt-menu-3992 .ul-top-items .li-top-item .a-top-link {
		background: #FFFFFF;
		padding: 5px 0px 5px 0px;
		color: #222222;
        font-size: 1.4rem;
        text-transform: uppercase;
        font-weight: 400;
    }
    #pt-menu-3992 .ul-top-items .li-top-item:hover .a-top-link,#pt-menu-3992 .ul-top-items .li-top-item:hover .a-top-link i, #pt-menu-3992 .ul-top-items .li-top-item.active .a-top-link{
        color: #C29958;
        font-weight: 400;
		background: #FFFFFF;
    }
    #pt-menu-3992 .mega-menu-container {
        
        background: #FFFFFF;
        padding: 0px 0px 0px 0px;
    }
	#pt-menu-3992 .mega-menu-container .a-mega-second-link {
		color: #FFFFFF;
		font-size: 1.4rem;
		text-transform: none;
		font-weight: 300;
	}
	#pt-menu-3992 .mega-menu-container .a-mega-second-link:hover {
		color: #FFFFFF;
		font-weight: 300;
	}
	#pt-menu-3992 .mega-menu-container .a-mega-third-link {
		color: #FFFFFF;
		font-size: 1.4rem;
		text-transform: none;
		font-weight: 300;
	}
	#pt-menu-3992 .mega-menu-container .a-mega-third-link:hover {
		color: #FFFFFF;
		font-weight: 300;
	}
    #pt-menu-3992 .ul-second-items .li-second-items {
        background: #FFFFFF;
        color: #222222;
    }
    #pt-menu-3992 .ul-second-items .li-second-items:hover, #pt-menu-3992 .ul-second-items .li-second-items.active {
        background: #FFFFFF;
        color: #C29958;
    }
    #pt-menu-3992 .ul-second-items .li-second-items .a-second-link {
        color: #222222;
        font-size: 1.4rem;
        text-transform: capitalize;
        font-weight: 400;
    }
    #pt-menu-3992 .ul-second-items .li-second-items .a-second-link:hover, #pt-menu-3992 .ul-second-items .li-second-items.active .a-second-link {
        color: #C29958;
        font-weight: 400;
    }
    #pt-menu-3992 .ul-third-items .li-third-items {
        background: #FFFFFF;
    }
    #pt-menu-3992 .ul-third-items .li-third-items:hover, #pt-menu-3992 .ul-third-items .li-third-items.active {
        background: #FFFFFF;
    }
    #pt-menu-3992 .ul-third-items .li-third-items .a-third-link {
        color: #888888;
        font-size: 1.4rem;
        text-transform: capitalize;
        font-weight: 400;
    }
    #pt-menu-3992 .ul-third-items .li-third-items .a-third-link:hover, #pt-menu-3992 .ul-third-items .li-third-items.active .a-third-link {
        color: #C29958;
        font-weight: 400;
    }
</style>
    
        
           <div class="pt-menu mobile-menu hidden-lg  " id="pt-menu-3992">
            
                            <input type="hidden" id="menu-effect-3992" class="menu-effect" value="none" />
                <div class="pt-menu-bar">
                    <i class="ion-android-menu" aria-hidden="true"></i>
                    <i class="ion-android-close" aria-hidden="true"></i>
                </div>
                <ul class="ul-top-items">
                    <li class="menu-mobile-title"><h3>Mobile Menu</h3></li>
					                                                    <li class="li-top-item  ">
                                                                    <a class="a-top-link a-item my-link" href="http://ethoscreations.com/">
                                                                                                                            <span>Home</span>
                                                                            </a>
                                                                                                                                </li>
                            
                            
                                                
                                                
                                                                    
                                                
                                                                    
                                                
                                                                        <li class="li-top-item  ">
                                                                    <a class="a-top-link a-item my-link" href="http://ethoscreations.com/product-special">
                                                                                                                            <span>Specials</span>
                                                                            </a>
                                                                                                                                </li>
                            
                            
                                                
                                                
                                                                        <li class="li-top-item  ">
                                                                    <a class="a-top-link a-item my-link" href="http://ethoscreations.com/our_story">
                                                                                                                            <span>About us</span>
                                                                            </a>
                                                                                                                                </li>
                            
                            
                                                
                                                
                                                                        <li class="li-top-item  ">
                                                                    <a class="a-top-link a-item my-link" href="http://ethoscreations.com/information-contact">
                                                                                                                            <span>Contact Us</span>
                                                                            </a>
                                                                                                                                </li>
                            
                            
                                                
                                                
                                                                        <li class="li-top-item   m-link ">
                                                                    <a class="a-top-link a-item my-link" href="http://ethoscreations.com/Blog">
                                                                                                                            <span>Blog</span>
                                                                            </a>
                                                                                                                                        
                                                                                                </li>
                            
                            
                                                
                                                
                                    </ul>
                    </div>
    
				
				<div id="logo">
				<a href="http://ethoscreations.com/"><img src="https://ethoscreations.com/image/catalog/logo/rsz_1200x400.png" title="" alt="" class="img-responsive" /></a>				</div>
				<div class="col-hoz"><style>
    #pt-menu-7777 .pt-menu-bar {
        background: #FFFFFF;
        color: #FFFFFF;
		padding: 0px 0px 0px 0px;
    }
    #pt-menu-7777.pt-menu-bar {
        background: #FFFFFF;
        color: #FFFFFF;
    }
    #pt-menu-7777 .ul-top-items .li-top-item .a-top-link {
		background: #FFFFFF;
		padding: 1rem 2rem 1rem 2rem;
		color: #222222;
        font-size: 1.5rem;
        text-transform: capitalize;
        font-weight: 400;
    }
    #pt-menu-7777 .ul-top-items .li-top-item:hover .a-top-link,#pt-menu-7777 .ul-top-items .li-top-item:hover .a-top-link i, #pt-menu-7777 .ul-top-items .li-top-item.active .a-top-link{
        color: #C29958;
        font-weight: 400;
		background: #FFFFFF;
    }
    #pt-menu-7777 .mega-menu-container {
        
        background: #FFFFFF;
        padding: 1.3rem 3rem 3rem 3rem;
    }
	#pt-menu-7777 .mega-menu-container .a-mega-second-link {
		color: #222222;
		font-size: 1.6rem;
		text-transform: capitalize;
		font-weight: 700;
	}
	#pt-menu-7777 .mega-menu-container .a-mega-second-link:hover {
		color: #C29958;
		font-weight: 700;
	}
	#pt-menu-7777 .mega-menu-container .a-mega-third-link {
		color: #888888;
		font-size: 1.4rem;
		text-transform: capitalize;
		font-weight: 400;
	}
	#pt-menu-7777 .mega-menu-container .a-mega-third-link:hover {
		color: #C29958;
		font-weight: 400;
	}
    #pt-menu-7777 .ul-second-items .li-second-items {
        background: #FFFFFF;
        color: #222222;
    }
    #pt-menu-7777 .ul-second-items .li-second-items:hover, #pt-menu-7777 .ul-second-items .li-second-items.active {
        background: #FFFFFF;
        color: #C29958;
    }
    #pt-menu-7777 .ul-second-items .li-second-items .a-second-link {
        color: #222222;
        font-size: 1.6rem;
        text-transform: capitalize;
        font-weight: 700;
    }
    #pt-menu-7777 .ul-second-items .li-second-items .a-second-link:hover, #pt-menu-7777 .ul-second-items .li-second-items.active .a-second-link {
        color: #C29958;
        font-weight: 700;
    }
    #pt-menu-7777 .ul-third-items .li-third-items {
        background: #FFFFFF;
    }
    #pt-menu-7777 .ul-third-items .li-third-items:hover, #pt-menu-7777 .ul-third-items .li-third-items.active {
        background: #FFFFFF;
    }
    #pt-menu-7777 .ul-third-items .li-third-items .a-third-link {
        color: #888888;
        font-size: 1.4rem;
        text-transform: capitalize;
        font-weight: 400;
    }
    #pt-menu-7777 .ul-third-items .li-third-items .a-third-link:hover, #pt-menu-7777 .ul-third-items .li-third-items.active .a-third-link {
        color: #C29958;
        font-weight: 400;
    }
</style>
            <div class="pt-menu horizontal-menu pt-menu-bar visible-lg  " id="pt-menu-7777">
            
                            <input type="hidden" id="menu-effect-7777" class="menu-effect" value="none" />
                <ul class="ul-top-items">
                                                                        <li class="li-top-item left " style="float: left">
                                                                    <a class="a-top-link" href="http://ethoscreations.com/">
                                                                                                                            <span>Home</span>
                                                                                                                    </a>
                                                                                            </li>
                                                	                        
                        <!-- end-->
                                                                    	                        
                        <!-- end-->
                                                                    	                        
                        <!-- end-->
                                                                        <li class="li-top-item left " style="float: left">
                                                                    <a class="a-top-link" href="http://ethoscreations.com/product-special">
                                                                                                                            <span>Specials</span>
                                                                                                                    </a>
                                                                                            </li>
                                                	                        
                        <!-- end-->
                                                                        <li class="li-top-item left " style="float: left">
                                                                    <a class="a-top-link" href="http://ethoscreations.com/information-contact">
                                                                                                                            <span>Contact Us</span>
                                                                                                                    </a>
                                                                                            </li>
                                                	                        
                        <!-- end-->
                                                                        <li class="li-top-item left " style="float: left">
                                                                    <a class="a-top-link" href="http://ethoscreations.com/Blog">
                                                                                                                            <span>Blog</span>
                                                                                                                            <i class="ion-ios-arrow-down" aria-hidden="true"></i>
                                                                            </a>
                                                                                                    <!-- Mega Menu -->
                                                                            
                                        
                                                                                                                                    <div class="mega-menu-container sub-menu-container left " style="width: 113rem;">
                                                    <div class="row">
													                                                                                                                                                                                                                                                        
                                                                    
                                                                                                                                            <div class="col-md-4 sub-item2-content" data-cols="4">
                                                                            <h4 class="html-title">Blog Page With Left Column</h4>                                                                            <div class="pt-block"><div class="image"><a href="index.php?route=plaza/blog&amp;layout=left"><img src="image/catalog/blog-menu/blog-page-left-column.jpg" alt="blog-page-left-column"></a></div></div>
                                                                        </div>
                                                                    
                                                                                                                                                                                                        
                                                                    
                                                                                                                                            <div class="col-md-4 sub-item2-content" data-cols="4">
                                                                            <h4 class="html-title">Blog Page With Right Column</h4>                                                                            <div class="pt-block"><div class="image"><a href="index.php?route=plaza/blog&amp;layout=right"><img src="image/catalog/blog-menu/blog-page-right-column.jpg" alt="blog-page-right-column"></a></div></div>
                                                                        </div>
                                                                    
                                                                                                                                                                                                        
                                                                    
                                                                                                                                            <div class="col-md-4 sub-item2-content" data-cols="4">
                                                                            <h4 class="html-title">Blog Page With Grid Style</h4>                                                                            <div class="pt-block"><div class="image"><a href="index.php?route=plaza/blog&amp;layout=full&amp;content=grid"><img src="image/catalog/blog-menu/blog-page-grid-style.jpg" alt="blog-page-grid-style"></a></div></div>
                                                                        </div>
                                                                    
                                                                                                                                                                                                        
                                                                    
                                                                                                                                            <div class="col-md-4 sub-item2-content" data-cols="4">
                                                                            <h4 class="html-title">Blog Page With List Style</h4>                                                                            <div class="pt-block"><div class="image"><a href="index.php?route=plaza/blog&amp;layout=full&amp;content=list"><img src="image/catalog/blog-menu/blog-page-list-style.jpg" alt="blog-page-list-style"></a></div></div>
                                                                        </div>
                                                                    
                                                                                                                                                                                                        
                                                                    
                                                                                                                                            <div class="col-md-4 sub-item2-content" data-cols="4">
                                                                            <h4 class="html-title">Categories Post Page</h4>                                                                            <div class="pt-block"><div class="image"><a href="index.php?route=plaza/blog/category&amp;post_list_id=1"><img src="image/catalog/blog-menu/categories-post-page.jpg" alt="categories-post-page"></a></div></div>
                                                                        </div>
                                                                    
                                                                                                                                                                                                        
                                                                    
                                                                                                                                            <div class="col-md-4 sub-item2-content" data-cols="4">
                                                                            <h4 class="html-title">Post Page</h4>                                                                            <div class="pt-block"><div class="image"><a href="index.php?route=plaza/blog/post&amp;post_id=1"><img src="image/catalog/blog-menu/post-page.jpg" alt="post-page"></a></div></div>
                                                                        </div>
                                                                    
                                                                                                                                                                                                                                                                                                            													</div>
                                                </div>
                                                                                                                        
                                    <!-- Flyout Menu -->
                                                                                                </li>
                                                	                        
                        <!-- end-->
                                    </ul>
                    </div>
    
        
   
</div>
				<div class="col-cart">
					<div id="top-links" class="nav header-dropdown">
					  <ul class="list-inline">
						<li class="dropdown"><a href="https://ethoscreations.com/index.php?route=account/account" title="My Profile" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-user"></i> <span class="hidden-xs hidden-sm">My Profile</span> <i class="icon-right ion-ios-arrow-down"></i></a>
						  <ul class="dropdown-menu dropdown-menu-right pt-account">
														<li><a id="pt-register-link" href="https://ethoscreations.com/index.php?route=account/register">Create Account</a></li>
							<li><a id="pt-login-link" href="https://ethoscreations.com/login">Login</a></li>
													  </ul>
						</li>
					  </ul>
					</div>
					<a href="https://ethoscreations.com/index.php?route=account/wishlist" id="wishlist-total" ><span><span class="text-wishlist">Wish List</span> <span class="txt-count">0</span></span></a>
					<div id="cart" class="btn-group btn-block">
  <button type="button" data-toggle="dropdown" data-loading-text="Loading..." class="btn btn-inverse btn-block btn-lg dropdown-toggle"><span id="cart-total"><span class="txt-count">0</span> <span class="text-cart">Your Cart - $0</span></span></button>
  <ul class="dropdown-menu pull-right">
	    <li>
      <span class="cart-dropdown-menu-close"><i class="ion-android-close"></i></span>
	  <p class="text-center">Your shopping cart is empty!</p>
    </li>
      </ul>
</div>
				</div>
			</div>
			<div class="col-search"><div id="search-by-category">
    <div class="dropdown-toggle search-button" data-toggle="dropdown"></div>
	<div class="dropdown-menu search-content" >
		<div class="search-container">
			<div class="categories-container">
				<div class="hover-cate">
					<p><span class="cate-selected" data-value="0">All Categories</span><i class="fa fa-caret-down"></i></p>
					<ul class="cate-items">
						<li class="item-cate" data-value="0">All Categories</li>
																					<li data-value="1172" class="item-cate">4th of July</li>
																																			<li data-value="1099" class="item-cate">Catalog</li>
																															<li data-value="1100" class="item-cate f1">Holiday 2023</li>
																																								<li data-value="1160" class="item-cate f1">Holiday 2024</li>
																																								<li data-value="1174" class="item-cate f1">Holiday 2025</li>
																																								<li data-value="1101" class="item-cate f1">Spring 2023</li>
																																								<li data-value="1108" class="item-cate f1">Spring 2024</li>
																																								<li data-value="1196" class="item-cate f1">Summer Spring 2026</li>
																																												<li data-value="300" class="item-cate">Collections</li>
																															<li data-value="1159" class="item-cate f1">21K Platinum</li>
																																								<li data-value="1165" class="item-cate f1">Amore</li>
																																								<li data-value="1168" class="item-cate f1">Azurea</li>
																																								<li data-value="1175" class="item-cate f1">Ballet of Sugar Plum Love</li>
																																								<li data-value="1187" class="item-cate f1">Bands</li>
																																								<li data-value="1184" class="item-cate f1">Champagne Toast</li>
																																								<li data-value="1158" class="item-cate f1">Diamonds in Rhythm</li>
																																								<li data-value="1176" class="item-cate f1">Dreams of Pearl</li>
																																								<li data-value="1253" class="item-cate f1">Enchant?</li>
																																								<li data-value="1252" class="item-cate f1">Enchant?</li>
																																								<li data-value="1251" class="item-cate f1">Enchant?</li>
																																								<li data-value="1250" class="item-cate f1">Enchant?</li>
																																								<li data-value="1249" class="item-cate f1">Enchant?</li>
																																								<li data-value="1248" class="item-cate f1">Enchant?</li>
																																								<li data-value="1246" class="item-cate f1">Enchant?</li>
																																								<li data-value="1245" class="item-cate f1">Enchant?</li>
																																								<li data-value="1254" class="item-cate f1">Enchant?</li>
																																								<li data-value="1255" class="item-cate f1">Enchant?</li>
																																								<li data-value="1256" class="item-cate f1">Enchant?</li>
																																								<li data-value="1257" class="item-cate f1">Enchant?</li>
																																								<li data-value="1258" class="item-cate f1">Enchant?</li>
																																								<li data-value="1259" class="item-cate f1">Enchant?</li>
																																								<li data-value="1260" class="item-cate f1">Enchant?</li>
																																								<li data-value="1261" class="item-cate f1">Enchant?</li>
																																								<li data-value="1262" class="item-cate f1">Enchant?</li>
																																								<li data-value="1263" class="item-cate f1">Enchant?</li>
																																								<li data-value="1264" class="item-cate f1">Enchant?</li>
																																								<li data-value="1265" class="item-cate f1">Enchant?</li>
																																								<li data-value="1266" class="item-cate f1">Enchant?</li>
																																								<li data-value="1267" class="item-cate f1">Enchant?</li>
																																								<li data-value="1268" class="item-cate f1">Enchant?</li>
																																								<li data-value="1269" class="item-cate f1">Enchant?</li>
																																								<li data-value="1270" class="item-cate f1">Enchant?</li>
																																								<li data-value="1271" class="item-cate f1">Enchant?</li>
																																								<li data-value="1272" class="item-cate f1">Enchant?</li>
																																								<li data-value="1273" class="item-cate f1">Enchant?</li>
																																								<li data-value="1274" class="item-cate f1">Enchant?</li>
																																								<li data-value="1275" class="item-cate f1">Enchant?</li>
																																								<li data-value="1276" class="item-cate f1">Enchant?</li>
																																								<li data-value="1277" class="item-cate f1">Enchant?</li>
																																								<li data-value="1278" class="item-cate f1">Enchant?</li>
																																								<li data-value="1279" class="item-cate f1">Enchant?</li>
																																								<li data-value="1280" class="item-cate f1">Enchant?</li>
																																								<li data-value="1281" class="item-cate f1">Enchant?</li>
																																								<li data-value="1282" class="item-cate f1">Enchant?</li>
																																								<li data-value="1283" class="item-cate f1">Enchant?</li>
																																								<li data-value="1284" class="item-cate f1">Enchant?</li>
																																								<li data-value="1285" class="item-cate f1">Enchant?</li>
																																								<li data-value="1286" class="item-cate f1">Enchant?</li>
																																								<li data-value="1287" class="item-cate f1">Enchant?</li>
																																								<li data-value="1288" class="item-cate f1">Enchant?</li>
																																								<li data-value="1289" class="item-cate f1">Enchant?</li>
																																								<li data-value="1290" class="item-cate f1">Enchant?</li>
																																								<li data-value="1291" class="item-cate f1">Enchant?</li>
																																								<li data-value="1292" class="item-cate f1">Enchant?</li>
																																								<li data-value="1293" class="item-cate f1">Enchant?</li>
																																								<li data-value="1294" class="item-cate f1">Enchant?</li>
																																								<li data-value="1295" class="item-cate f1">Enchant?</li>
																																								<li data-value="1296" class="item-cate f1">Enchant?</li>
																																								<li data-value="1297" class="item-cate f1">Enchant?</li>
																																								<li data-value="1298" class="item-cate f1">Enchant?</li>
																																								<li data-value="1299" class="item-cate f1">Enchant?</li>
																																								<li data-value="1300" class="item-cate f1">Enchant?</li>
																																								<li data-value="1301" class="item-cate f1">Enchant?</li>
																																								<li data-value="1303" class="item-cate f1">Enchant?</li>
																																								<li data-value="1304" class="item-cate f1">Enchant?</li>
																																								<li data-value="1305" class="item-cate f1">Enchant?</li>
																																								<li data-value="1306" class="item-cate f1">Enchant?</li>
																																								<li data-value="1307" class="item-cate f1">Enchant?</li>
																																								<li data-value="1308" class="item-cate f1">Enchant?</li>
																																								<li data-value="1309" class="item-cate f1">Enchant?</li>
																																								<li data-value="1310" class="item-cate f1">Enchant?</li>
																																								<li data-value="1311" class="item-cate f1">Enchant?</li>
																																								<li data-value="1312" class="item-cate f1">Enchant?</li>
																																								<li data-value="1313" class="item-cate f1">Enchant?</li>
																																								<li data-value="1314" class="item-cate f1">Enchant?</li>
																																								<li data-value="1315" class="item-cate f1">Enchant?</li>
																																								<li data-value="1316" class="item-cate f1">Enchant?</li>
																																								<li data-value="1317" class="item-cate f1">Enchant?</li>
																																								<li data-value="1318" class="item-cate f1">Enchant?</li>
																																								<li data-value="1319" class="item-cate f1">Enchant?</li>
																																								<li data-value="1320" class="item-cate f1">Enchant?</li>
																																								<li data-value="1321" class="item-cate f1">Enchant?</li>
																																								<li data-value="1322" class="item-cate f1">Enchant?</li>
																																								<li data-value="1323" class="item-cate f1">Enchant?</li>
																																								<li data-value="1324" class="item-cate f1">Enchant?</li>
																																								<li data-value="1325" class="item-cate f1">Enchant?</li>
																																								<li data-value="1326" class="item-cate f1">Enchant?</li>
																																								<li data-value="1327" class="item-cate f1">Enchant?</li>
																																								<li data-value="1328" class="item-cate f1">Enchant?</li>
																																								<li data-value="1185" class="item-cate f1">Enchante</li>
																																								<li data-value="1093" class="item-cate f1">Ensembles</li>
																																								<li data-value="1081" class="item-cate f1">Eternal Blush</li>
																																								<li data-value="1244" class="item-cate f1">Heirloom</li>
																																								<li data-value="1302" class="item-cate f1">Holiday 2026</li>
																																								<li data-value="1183" class="item-cate f1">Linked Hearts</li>
																																								<li data-value="1189" class="item-cate f1">Lovestruck Vine</li>
																																								<li data-value="1157" class="item-cate f1">Medley</li>
																																								<li data-value="1247" class="item-cate f1">Mirage</li>
																																								<li data-value="1098" class="item-cate f1">Muse</li>
																																								<li data-value="1162" class="item-cate f1">Radiance by MARCHESA</li>
																																								<li data-value="1166" class="item-cate f1">Regalia</li>
																																								<li data-value="1167" class="item-cate f1">Serafina</li>
																																								<li data-value="1169" class="item-cate f1">Serafine</li>
																																								<li data-value="1148" class="item-cate f1">Steps Of Love</li>
																																								<li data-value="311" class="item-cate f1">Toi Et Moi</li>
																																								<li data-value="1075" class="item-cate f1">Trinity</li>
																																								<li data-value="1186" class="item-cate f1">Wrapped In You</li>
																																												<li data-value="1200" class="item-cate">Engagement &Amp; Wedding Rings</li>
																															<li data-value="1201" class="item-cate f1">Halo</li>
																																												<li data-value="1146" class="item-cate">Fashion Pendant</li>
																																			<li data-value="240" class="item-cate">Loose Diamonds</li>
																																			<li data-value="1224" class="item-cate">MEN'S JEWELERY</li>
																															<li data-value="1226" class="item-cate f1">Men's Bands</li>
																																								<li data-value="1225" class="item-cate f1">Men's Rings</li>
																																												<li data-value="1077" class="item-cate">Men's Jewelry</li>
																															<li data-value="1080" class="item-cate f1">Men's Bands</li>
																																								<li data-value="1078" class="item-cate f1">Men's Bracelets</li>
																																								<li data-value="1076" class="item-cate f1">Men's Earrings</li>
																																								<li data-value="1106" class="item-cate f1">Men's Necklaces</li>
																																								<li data-value="329" class="item-cate f1">Men's Rings</li>
																																								<li data-value="1079" class="item-cate f1">Mens Pendant / Chains</li>
																																												<li data-value="1179" class="item-cate">Men's JeYelry</li>
																															<li data-value="1180" class="item-cate f1">Mens Pendant / Chains</li>
																																												<li data-value="1154" class="item-cate">Men's Pendants</li>
																																			<li data-value="1125" class="item-cate">Mother's Day</li>
																																			<li data-value="1163" class="item-cate">Radiance by MARCHESA</li>
																																			<li data-value="62" class="item-cate">Rings</li>
																															<li data-value="321" class="item-cate f1">Bands</li>
																																			<li data-value="322" class="item-cate f2">Eternity Bands</li>
																																				<li data-value="330" class="item-cate f2">Fashion Bands</li>
																																				<li data-value="323" class="item-cate f2">Wedding Bands</li>
																																									<li data-value="1207" class="item-cate f1">Engagement & Wedding Rings</li>
																																			<li data-value="1210" class="item-cate f2">3 Stones</li>
																																				<li data-value="1228" class="item-cate f2">Bridal Sets</li>
																																				<li data-value="1217" class="item-cate f2">Classic</li>
																																				<li data-value="1209" class="item-cate f2">Halo</li>
																																				<li data-value="1208" class="item-cate f2">Hidden Halo</li>
																																				<li data-value="1220" class="item-cate f2">Solitaires</li>
																																									<li data-value="309" class="item-cate f1">Engagement &amp; Wedding Rings</li>
																																			<li data-value="310" class="item-cate f2">3 Stones</li>
																																				<li data-value="326" class="item-cate f2">Bridal Sets</li>
																																				<li data-value="317" class="item-cate f2">Classic</li>
																																				<li data-value="316" class="item-cate f2">Halo</li>
																																				<li data-value="1094" class="item-cate f2">Hidden Halo</li>
																																				<li data-value="236" class="item-cate f2">Solitaires</li>
																																									<li data-value="1177" class="item-cate f1">Engagement &amp; Yedding Rings</li>
																																			<li data-value="1181" class="item-cate f2">Classic</li>
																																				<li data-value="1178" class="item-cate f2">Halo</li>
																																									<li data-value="1170" class="item-cate f1">Fashion</li>
																																								<li data-value="327" class="item-cate f1">Fashion Rings</li>
																																			<li data-value="1182" class="item-cate f2">Classic</li>
																																									<li data-value="328" class="item-cate f1">Wraps &amp; Enhancers</li>
																																												<li data-value="1155" class="item-cate">Solitaires</li>
																																			<li data-value="1164" class="item-cate">Steps Of Love</li>
																																			<li data-value="1173" class="item-cate">The Ethos Edit</li>
																																			<li data-value="1109" class="item-cate">Tie The Knot</li>
																																			<li data-value="1147" class="item-cate">Timeless Classic</li>
																																			<li data-value="1105" class="item-cate">Valentine's Gifts</li>
																																			<li data-value="1197" class="item-cate">WOMEN'S JEWELERY</li>
																															<li data-value="1202" class="item-cate f1"> Bracelets</li>
																																			<li data-value="1203" class="item-cate f2">Bangles</li>
																																									<li data-value="1198" class="item-cate f1"> Rings</li>
																																			<li data-value="1199" class="item-cate f2">Bands</li>
																																				<li data-value="1204" class="item-cate f2">Wraps & Enhancers</li>
																																									<li data-value="1215" class="item-cate f1">Bracelets</li>
																																			<li data-value="1216" class="item-cate f2">Fashion Bracelets</li>
																																				<li data-value="1222" class="item-cate f2">Tennis Bracelets</li>
																																									<li data-value="1211" class="item-cate f1">Earrings</li>
																																			<li data-value="1219" class="item-cate f2">Fashion Earrings</li>
																																				<li data-value="1212" class="item-cate f2">Hoops</li>
																																				<li data-value="1221" class="item-cate f2">Solitaires</li>
																																									<li data-value="1213" class="item-cate f1">Necklaces & Pendants</li>
																																			<li data-value="1214" class="item-cate f2">Fashion Necklace</li>
																																				<li data-value="1218" class="item-cate f2">Fashion Pendant</li>
																																				<li data-value="1227" class="item-cate f2">Tennis Necklace</li>
																																									<li data-value="1205" class="item-cate f1">Rings</li>
																																			<li data-value="1223" class="item-cate f2">Bands</li>
																																				<li data-value="1206" class="item-cate f2">Fashion Rings</li>
																																													<li data-value="60" class="item-cate">Earrings</li>
																															<li data-value="324" class="item-cate f1">Fashion Earrings</li>
																																								<li data-value="320" class="item-cate f1">Hoops</li>
																																								<li data-value="325" class="item-cate f1">Linear Diamond</li>
																																								<li data-value="123" class="item-cate f1">Solitaires</li>
																																												<li data-value="59" class="item-cate">Bracelets</li>
																															<li data-value="75" class="item-cate f1">Bangles</li>
																																								<li data-value="318" class="item-cate f1">Fashion Bracelets</li>
																																								<li data-value="312" class="item-cate f1">Tennis Bracelets</li>
																																												<li data-value="61" class="item-cate">Necklaces &amp; Pendants</li>
																															<li data-value="314" class="item-cate f1">Fashion Necklace</li>
																																								<li data-value="319" class="item-cate f1">Fashion Pendant</li>
																																								<li data-value="313" class="item-cate f1">Solitaire Pendants</li>
																																								<li data-value="315" class="item-cate f1">Tennis Necklace</li>
																																		</ul>
				</div>
			</div>
			<input type="text" name="search" id="text-search" value="" placeholder="Search entire store here ..." class=""  />
			<div id="sp-btn-search" class="">
				<button type="button" id="btn-search-category" class="btn btn-default btn-lg">
					<span class="hidden-xs">Search</span>
				</button>
			</div>
			<div class="search-ajax">
				<div class="ajax-loader-container" style="display: none;">
					<img src="https://ethoscreations.com/image/catalog/ajax-loader.gif" alt="search-ajax" class="ajax-load-img" width="30" height="30" />
				</div>
				<div class="ajax-result-container">
					<!-- Content of search results -->
				</div>
			</div>
			<input type="hidden" id="ajax-search-enable" value="1" />
		</div>
	
		
	</div>
</div>

<script >
$(document).ready(function () {
    var flag = false;
    var ajax_search_enable = $('#ajax-search-enable').val();
    var debounceTimer;
    var currentAjaxRequest = null;

    var current_cate_value = $('ul.cate-items li.selected').data('value');
    var current_cate_text = $('ul.cate-items li.selected').html();

    $('.cate-selected').attr('data-value', current_cate_value);
    $('.cate-selected').html(current_cate_text);

    $('.hover-cate p').click(function () {
        $(".cate-items").toggle("slow");
    });

    $('.ajax-result-container').hover(
        function() {
            flag = true;
        },
        function() {
            flag = false;
        }
    );

    $('.hover-cate').hover(
        function() {
            flag = true;
        },
        function() {
            flag = false;
        }
    );

    $('#search-by-category').focusout(function() {
        if(flag == true) {
            $('.ajax-result-container').show();
        } else {
            $('.ajax-result-container').hide();
        }
    });

    $('#search-by-category').focusin(function() {
        $('.ajax-result-container').show();
    });

    $('#btn-search-category').click(function () {
        var url = 'https://ethoscreations.com/index.php?route=product/search';
        var text_search = $('#text-search').val();
        if(text_search) {
            url += '&search=' + encodeURIComponent(text_search);
        }

        var category_search = $('.cate-selected').attr("data-value");
        if(category_search) {
            url += '&category_id=' + encodeURIComponent(category_search);
        }

        location = url;
    });

    //omer's code starts
    $('#text-search').keydown(function(event) {
        if (event.keyCode === 13) { // Enter key code is 13
            var url = 'https://ethoscreations.com/index.php?route=product/search';
            var text_search = $('#text-search').val();
            if(text_search) {
                url += '&search=' + encodeURIComponent(text_search);
            }

            var category_search = $('.cate-selected').attr("data-value");
            if(category_search) {
                url += '&category_id=' + encodeURIComponent(category_search);
            }

            location = url;
        }
    });
    //omer's code ends here

    if(ajax_search_enable == '1') {
        $('#text-search').keyup(function(e) {
            clearTimeout(debounceTimer);
            debounceTimer = setTimeout(function() {
                var text_search = $('#text-search').val();
                var cate_search = $('.cate-selected').attr("data-value");

                if(text_search != null && text_search.length >= 3) {
                    if (currentAjaxRequest) {
                        currentAjaxRequest.abort(); // Abort the previous request
                    }
                    currentAjaxRequest = ajaxSearch(text_search, cate_search);
                } else {
                    $('.ajax-result-container').html('');
                    $('.ajax-loader-container').hide();
                }
            }, 300); // Delay of 300 milliseconds
        });

        $('ul.cate-items li.item-cate').click(function() {
            var cate_search = $(this).data('value');
            var text_search = $('#text-search').val();
            $('.cate-selected').attr('data-value', cate_search);
            $('.cate-selected').html($(this).html());

            if(text_search != null && text_search.length >= 3) {
                if (currentAjaxRequest) {
                    currentAjaxRequest.abort(); // Abort the previous request
                }
                currentAjaxRequest = ajaxSearch(text_search, cate_search);
            } else {
                $('.ajax-result-container').html('');
                $('.ajax-loader-container').hide();
            }
            $(".cate-items").hide();
            $('#text-search').focus();
        });
    }

    function ajaxSearch(text_search, cate_search) {
        return $.ajax({
            url: 'https://ethoscreations.com/index.php?route=extension/module/ptsearch/ajaxSearch',
            type: 'post',
            data: { text_search: text_search, cate_search: cate_search },
            beforeSend: function () {
                $('.ajax-loader-container').show();
                $('.ajax-result-container').html('<p style="text-align:center;">Loading...</p>');
            },
            success: function(json) {
                if(json['success'] == true) {
                    $('.ajax-result-container').html('');
                    $('.ajax-result-container').html(json['result_html']);
                    $('.ajax-loader-container').hide();
                }
            }
        });
    }
});


    // $(document).ready(function () {
    //     var flag = false;
    //     var ajax_search_enable = $('#ajax-search-enable').val();

    //     var current_cate_value = $('ul.cate-items li.selected').data('value');
    //     var current_cate_text = $('ul.cate-items li.selected').html();

    //     $('.cate-selected').attr('data-value', current_cate_value);
    //     $('.cate-selected').html(current_cate_text);

    //     $('.hover-cate p').click(function () {
    //         $( ".cate-items" ).toggle("slow");
    //     });

    //     $('.ajax-result-container').hover(
    //         function() {
    //             flag = true;
    //         },
    //         function() {
    //             flag = false;
    //         }
    //     );

    //     $('.hover-cate').hover(
    //         function() {
    //             flag = true;
    //         },
    //         function() {
    //             flag = false;
    //         }
    //     );

    //     $('#search-by-category').focusout(function() {
    //         if(flag == true) {
    //             $('.ajax-result-container').show();
    //         } else {
    //             $('.ajax-result-container').hide();
    //         }
    //     });

    //     $('#search-by-category').focusin(function() {
    //         $('.ajax-result-container').show();
    //     });

    //     $('#btn-search-category').click(function () {
    //         var url = 'https://ethoscreations.com/index.php?route=product/search';
    //         var text_search = $('#text-search').val();
    //         if(text_search) {
    //             url += '&search=' + encodeURIComponent(text_search);
    //         }

    //         var category_search = $('.cate-selected').attr("data-value");
    //         if(category_search) {
    //             url += '&category_id=' + encodeURIComponent(category_search);
    //         }

    //         location = url;
    //     });
        
    //     //omer's code starts
        
    //     $('#text-search').keydown(function(event) {
    //         if (event.keyCode === 13) { // Enter key code is 13
    //             var url = 'https://ethoscreations.com/index.php?route=product/search';
    //             var text_search = $('#text-search').val();
    //             if(text_search) {
    //                 url += '&search=' + encodeURIComponent(text_search);
    //             }
        
    //             var category_search = $('.cate-selected').attr("data-value");
    //             if(category_search) {
    //                 url += '&category_id=' + encodeURIComponent(category_search);
    //             }
        
    //             location = url;
    //         }
    //     });
        
    //     //omer's code ends here

    //     if(ajax_search_enable == '1') {
    //         $('#text-search').keyup(function(e) {
    //             var text_search = $(this).val();
    //             var cate_search = $('.cate-selected').attr("data-value");
    //             if(text_search != null && text_search != '') {
    //                 ajaxSearch(text_search, cate_search);
    //             } else {
    //                 $('.ajax-result-container').html('');
    //                 $('.ajax-loader-container').hide();
    //             }
    //         });

    //         $('ul.cate-items li.item-cate').click(function() {
    //             var cate_search = $(this).data('value');
    //             var text_search = $('#text-search').val();
    //             $('.cate-selected').attr('data-value', cate_search);
    //             $('.cate-selected').html($(this).html());
    //             if(text_search != null && text_search != '') {
    //                 ajaxSearch(text_search, cate_search);
    //             } else {
    //                 $('.ajax-result-container').html('');
    //                 $('.ajax-loader-container').hide();
    //             }
    //             $( ".cate-items" ).hide();
    //             $('#text-search').focus();
    //         });
    //     }

    //     function ajaxSearch(text_search, cate_search) {
    //         $.ajax({
    //             url         : 'https://ethoscreations.com/index.php?route=extension/module/ptsearch/ajaxSearch',
    //             type        : 'post',
    //             data        : { text_search : text_search, cate_search : cate_search },
    //             beforeSend  : function () {
    //                 $('.ajax-loader-container').show();
    //                 $('.ajax-result-container').html('<p style="text-align:center;">Loading...</p>');
    //             },
    //             success     : function(json) {
    //                 if(json['success'] == true) {
    //                     $('.ajax-result-container').html('');
    //                     $('.ajax-result-container').html(json['result_html']);
    //                     $('.ajax-loader-container').hide();
    //                 }
    //             }
    //         });
    //     }

    // });
</script></div>
		</div>
		
	</div>
</header>
<div class="container">
    <ul class="breadcrumb">
                    <li><a href="http://ethoscreations.com/"><i class="fa fa-home"></i></a></li>
                <li>Blog</li>
    </ul>
</div>
<div class="container">
    <div class="main">
        <div class="row">
                                                                <div id="content" class="col-md-9 col-sm-12 col-xs-12">
				<h1>Blog</h1>
				<div class="tool-bar">	
					<div class="row">
						<div class="col-sm-6 col-xs-6">
							<div class="btn-group btn-group-sm">
								<button type="button"  onclick="location='https://ethoscreations.com/Blog?content=grid&amp;layout=right'" class="btn-grid-view btn btn-default active" data-toggle="tooltip" title="Grid"></button>
								<button type="button"  onclick="location='https://ethoscreations.com/Blog?content=list&amp;layout=right'" class="btn-list-view btn btn-default " data-toggle="tooltip" title="List"></button>
								
							</div>
						</div>
						<div class="col-sm-6 col-xs-6">
							<div class="post-item-limit form-group input-group input-group-sm">
								<label class="input-group-addon" for="input-limit">Limit</label>
								<select id="input-limit" class="form-control" onchange="location = this.value;">
																														<option value="https://ethoscreations.com/Blog?layout=right&amp;limit=10" selected="selected">10</option>
																																								<option value="https://ethoscreations.com/Blog?layout=right&amp;limit=50">50</option>
																																								<option value="https://ethoscreations.com/Blog?layout=right&amp;limit=75">75</option>
																																								<option value="https://ethoscreations.com/Blog?layout=right&amp;limit=100">100</option>
																											</select>
							</div>
						</div>
					</div>
				</div>
                                    <div class="post-page">
                                                                            <div class="row">
                                                                                                        <div class="post-layout col-sm-4 col-xs-6">
										<div class="post-grid">
											<div class="post-item odd">
												<div class="post-image">
													<a title="Celebrity Daughter Opens Up About Having Her Eye Color Changed" href="http://ethoscreations.com/celebrity-daughter-opens-up-about-having-her-eye-color-changed?layout=right"><img src="https://ethoscreations.com/image/cache/catalog/blog/2-356x279.jpg" alt="Celebrity Daughter Opens Up About Having Her Eye Color Changed" /></a>
												</div>
												<div class="post-cation">
													<div class="post-date">
														01/18/2019 | Plaza Themes													</div>
													<h4 class="post-name"><a  href="http://ethoscreations.com/celebrity-daughter-opens-up-about-having-her-eye-color-changed?layout=right">Celebrity Daughter Opens Up About Having Her Eye Color Changed</a></h4>
													<div class="post-intro"><p>People are constantly changing things about themselves--- from their hair styles to their clothes, to even the way they physically look. There are some things, like the color of your eyes however, that aren’t as easy to change. Here, one reality tv star has opened up about having had her eyes surgically altered to look gray instead of her natural brown.</p></div>
													<!--div class="btn-more"><a href="http://ethoscreations.com/celebrity-daughter-opens-up-about-having-her-eye-color-changed?layout=right">Show more</a></div-->
												</div>
											</div>
										</div>
                                    </div>
                                                                                                        <div class="post-layout col-sm-4 col-xs-6">
										<div class="post-grid">
											<div class="post-item even">
												<div class="post-image">
													<a title="Children Left Home Alone For 4 Days In TV Experiment" href="http://ethoscreations.com/children-left-home-alone-for-4-days-in-tv-experiment?layout=right"><img src="https://ethoscreations.com/image/cache/catalog/blog/3-356x279.jpg" alt="Children Left Home Alone For 4 Days In TV Experiment" /></a>
												</div>
												<div class="post-cation">
													<div class="post-date">
														01/18/2019 | Plaza Themes													</div>
													<h4 class="post-name"><a  href="http://ethoscreations.com/children-left-home-alone-for-4-days-in-tv-experiment?layout=right">Children Left Home Alone For 4 Days In TV Experiment</a></h4>
													<div class="post-intro"><p>A new reality show in the UK conducted an experiment to see just how kids and teens would behave after being left home alone for the weekend. The show, called Alone at Home, recruited four families to participate in the experiment.</p></div>
													<!--div class="btn-more"><a href="http://ethoscreations.com/children-left-home-alone-for-4-days-in-tv-experiment?layout=right">Show more</a></div-->
												</div>
											</div>
										</div>
                                    </div>
                                                                                                        <div class="post-layout col-sm-4 col-xs-6">
										<div class="post-grid">
											<div class="post-item odd">
												<div class="post-image">
													<a title="Lesbian Sex Stories Of Hollywood’s Biggest Celebrities" href="http://ethoscreations.com/index.php?route=plaza/blog/post&amp;post_id=1&amp;layout=right"><img src="https://ethoscreations.com/image/cache/catalog/blog/1-356x279.jpg" alt="Lesbian Sex Stories Of Hollywood’s Biggest Celebrities" /></a>
												</div>
												<div class="post-cation">
													<div class="post-date">
														01/18/2019 | Plaza Themes													</div>
													<h4 class="post-name"><a  href="http://ethoscreations.com/index.php?route=plaza/blog/post&amp;post_id=1&amp;layout=right">Lesbian Sex Stories Of Hollywood’s Biggest Celebrities</a></h4>
													<div class="post-intro"><p>As a celebrity, your life is pretty much always on display.. whether you want it to be or not. Where you buy your avocados? TMZ is covering it. Who you went to lunch with last week? TMZ is covering it.</p></div>
													<!--div class="btn-more"><a href="http://ethoscreations.com/index.php?route=plaza/blog/post&amp;post_id=1&amp;layout=right">Show more</a></div-->
												</div>
											</div>
										</div>
                                    </div>
                                                                                                        <div class="post-layout col-sm-4 col-xs-6">
										<div class="post-grid">
											<div class="post-item even">
												<div class="post-image">
													<a title="Lotto Winner Offering Up Money To Any Man That Will Date Her" href="http://ethoscreations.com/lotto-winner-offering-money-man-will-date?layout=right"><img src="https://ethoscreations.com/image/cache/catalog/blog/4-356x279.jpg" alt="Lotto Winner Offering Up Money To Any Man That Will Date Her" /></a>
												</div>
												<div class="post-cation">
													<div class="post-date">
														01/18/2019 | Plaza Themes													</div>
													<h4 class="post-name"><a  href="http://ethoscreations.com/lotto-winner-offering-money-man-will-date?layout=right">Lotto Winner Offering Up Money To Any Man That Will Date Her</a></h4>
													<div class="post-intro"><p>The UK’s youngest lottery winner has recently revealed she is searching for a boyfriend, and is willing to pay for the right man. Jane Park won the lottery when she was just 17, but now at 23, is looking for someone to settle down.</p></div>
													<!--div class="btn-more"><a href="http://ethoscreations.com/lotto-winner-offering-money-man-will-date?layout=right">Show more</a></div-->
												</div>
											</div>
										</div>
                                    </div>
                                                                                                        <div class="post-layout col-sm-4 col-xs-6">
										<div class="post-grid">
											<div class="post-item odd">
												<div class="post-image">
													<a title="Lotto Winner Offering Up Money To Any Man That Will Date Her2" href="http://ethoscreations.com/lotto-winner-offering-money-man-will-date2?layout=right"><img src="https://ethoscreations.com/image/cache/catalog/blog/4-356x279.jpg" alt="Lotto Winner Offering Up Money To Any Man That Will Date Her2" /></a>
												</div>
												<div class="post-cation">
													<div class="post-date">
														01/31/2019 | Plaza Themes													</div>
													<h4 class="post-name"><a  href="http://ethoscreations.com/lotto-winner-offering-money-man-will-date2?layout=right">Lotto Winner Offering Up Money To Any Man That Will Date Her2</a></h4>
													<div class="post-intro"><p>The UK’s youngest lottery winner has recently revealed she is searching for a boyfriend, and is willing to pay for the right man. Jane Park won the lottery when she was just 17, but now at 23, is looking for someone to settle down.</p></div>
													<!--div class="btn-more"><a href="http://ethoscreations.com/lotto-winner-offering-money-man-will-date2?layout=right">Show more</a></div-->
												</div>
											</div>
										</div>
                                    </div>
                                                                                                        <div class="post-layout col-sm-4 col-xs-6">
										<div class="post-grid">
											<div class="post-item even">
												<div class="post-image">
													<a title="People are Willing to Lie When It Comes to Money, According to Research" href="http://ethoscreations.com/people-willing-lie-comes-money-according-research?layout=right"><img src="https://ethoscreations.com/image/cache/catalog/blog/5-356x279.jpg" alt="People are Willing to Lie When It Comes to Money, According to Research" /></a>
												</div>
												<div class="post-cation">
													<div class="post-date">
														01/18/2019 | Plaza Themes													</div>
													<h4 class="post-name"><a  href="http://ethoscreations.com/people-willing-lie-comes-money-according-research?layout=right">People are Willing to Lie When It Comes to Money, According to Research</a></h4>
													<div class="post-intro"><p>Humans have a problem: we really like to lie. And most of the lies that we tell aren’t even malicious. We frequently tell lies that will make others or ourselves feel better. Research has found that we tell at least one lie a day and about 40 percent of people would happily lie if they knew they could get away with it.</p></div>
													<!--div class="btn-more"><a href="http://ethoscreations.com/people-willing-lie-comes-money-according-research?layout=right">Show more</a></div-->
												</div>
											</div>
										</div>
                                    </div>
                                                            </div>
                        
                                            </div>
					<div class="tool-bar-bottom">
						<div class="row">
							<div class="col-sm-6 show-page text-left"></div>
							<div class="col-sm-6 text-right">Showing 1 to 6 of 6 (1 Pages)</div>
						</div>
					</div>
                            </div>
                        <div class="col-md-3 col-xs-12">
                    <div class="blog-widget-section categories-widget">
        <div class="title cat-title">
            <h3>Categories</h3>
        </div>
                <div class="widget-content">
            <a href="https://ethoscreations.com/jewelry-blog?layout=right">Jewelry</a>
        </div>
                <div class="widget-content">
            <a href="https://ethoscreations.com/fashion-blog?layout=right">Fashion</a>
        </div>
                <div class="widget-content">
            <a href="https://ethoscreations.com/furniture-blog?layout=right">Furniture</a>
        </div>
                <div class="widget-content">
            <a href="https://ethoscreations.com/digital-blog?layout=right">Digital</a>
        </div>
            </div>

                    <div class="blog-widget-section blog-widget">
        <div class="title">
            <h3>Latest Post</h3>
        </div>
                <div class="widget-content">
            <a href="http://ethoscreations.com/lotto-winner-offering-money-man-will-date2?layout=right"><img src="https://ethoscreations.com/image/cache/catalog/blog/4-75x58.jpg" alt="Lotto Winner Offering Up Money To Any Ma..." /></a>
			<div class="latest-post-content">
				<h5 class="latest-post-name"><a href="http://ethoscreations.com/lotto-winner-offering-money-man-will-date2?layout=right">Lotto Winner Offering Up Money To Any Ma...</a></h5>
				<div class="post-date">
					01/31/2019 | Plaza Themes				</div>
			</div>
        </div>
                <div class="widget-content">
            <a href="http://ethoscreations.com/people-willing-lie-comes-money-according-research?layout=right"><img src="https://ethoscreations.com/image/cache/catalog/blog/5-75x58.jpg" alt="People are Willing to Lie When It Comes ..." /></a>
			<div class="latest-post-content">
				<h5 class="latest-post-name"><a href="http://ethoscreations.com/people-willing-lie-comes-money-according-research?layout=right">People are Willing to Lie When It Comes ...</a></h5>
				<div class="post-date">
					01/18/2019 | Plaza Themes				</div>
			</div>
        </div>
                <div class="widget-content">
            <a href="http://ethoscreations.com/lotto-winner-offering-money-man-will-date?layout=right"><img src="https://ethoscreations.com/image/cache/catalog/blog/4-75x58.jpg" alt="Lotto Winner Offering Up Money To Any Ma..." /></a>
			<div class="latest-post-content">
				<h5 class="latest-post-name"><a href="http://ethoscreations.com/lotto-winner-offering-money-man-will-date?layout=right">Lotto Winner Offering Up Money To Any Ma...</a></h5>
				<div class="post-date">
					01/18/2019 | Plaza Themes				</div>
			</div>
        </div>
                <div class="widget-content">
            <a href="http://ethoscreations.com/children-left-home-alone-for-4-days-in-tv-experiment?layout=right"><img src="https://ethoscreations.com/image/cache/catalog/blog/3-75x58.jpg" alt="Children Left Home Alone For 4 Days In T..." /></a>
			<div class="latest-post-content">
				<h5 class="latest-post-name"><a href="http://ethoscreations.com/children-left-home-alone-for-4-days-in-tv-experiment?layout=right">Children Left Home Alone For 4 Days In T...</a></h5>
				<div class="post-date">
					01/18/2019 | Plaza Themes				</div>
			</div>
        </div>
                <div class="widget-content">
            <a href="http://ethoscreations.com/celebrity-daughter-opens-up-about-having-her-eye-color-changed?layout=right"><img src="https://ethoscreations.com/image/cache/catalog/blog/2-75x58.jpg" alt="Celebrity Daughter Opens Up About Having..." /></a>
			<div class="latest-post-content">
				<h5 class="latest-post-name"><a href="http://ethoscreations.com/celebrity-daughter-opens-up-about-having-her-eye-color-changed?layout=right">Celebrity Daughter Opens Up About Having...</a></h5>
				<div class="post-date">
					01/18/2019 | Plaza Themes				</div>
			</div>
        </div>
            </div>

            </div>
                    </div>
    </div>
</div>
<footer>
	<div class="footer-links">  
	  <div class="container">
		<div class="inner">	
			<div class="row">
			  <div class="col col-md-3 col-sm-6">
				<div class="btn-group">
					<h5 data-toggle="dropdown" class="dropdown-toggle visible-xs">about us<i class="visible-xs ion-chevron-down"></i></h5>
					<div class="dropdown-menu footer-content">
					    <img src= "https://ethoscreations.com/image/catalog/logo/500x500.png" width="200px">
				
					</div>
				</div>
			  </div>
			  <div class="col col-md-3 col-sm-6">
				<div class="btn-group">
					<h5 data-toggle="dropdown" class="dropdown-toggle">Contact Us<i class="visible-xs ion-chevron-down"></i></h5>
					<div class="dropdown-menu footer-content">
					<div class="contact-block">
  <ul>
    <li class="address">4710-4890 Breckinridge USA</li>
    <li class="email">demo@plazathemes.com</li>
    <li class="phone">(012) 800 456 789-987</li>
  </ul>
</div>


					</div>
				</div>
			  </div>
			  <div class="col col-md-3 col-sm-6">
				<div class="btn-group">
					<h5 data-toggle="dropdown" class="dropdown-toggle">Information<i class="visible-xs ion-chevron-down"></i></h5>
					<div class="dropdown-menu footer-content footer-information">

						<ul class="list-unstyled">
						 						 					
						 						 						  <li><a href="https://ethoscreations.com/staging/about_us">About Us</a></li>
						 						 						  	  
						  						  						  <li><a href="https://ethoscreations.com/staging/information-contact">Contact Us</a></li>
						  						  						  <li><a href="https://ethoscreations.com/staging/delivery">Shipping Charges</a></li>
						  						  <li><a href="https://ethoscreations.com/staging/index.php?route=information/information&amp;information_id=7">Trade Shows</a></li>
						  						  <li><a href="https://ethoscreations.com/staging/privacy">Privacy Policy</a></li>
						  						  <li><a href="https://ethoscreations.com/staging/terms">Terms &amp; Conditions</a></li>
						  					
						  <li><a href="https://ethoscreations.com/staging/information-sitemap">Site Map</a></li>
						</ul>
					</div>
				</div>
			  </div>
			  <!--div class="col col-md-2 col-sm-6">
				<div class="btn-group">
					<h5 data-toggle="dropdown" class="dropdown-toggle">Extras<i class="visible-xs ion-chevron-down"></i></h5>
					<div class="dropdown-menu">
						<ul class="list-unstyled">
						  <li><a href="http://ethoscreations.com/product-manufacturer">Brands</a></li>
						  <li><a href="https://ethoscreations.com/account-voucher">Gift Certificates</a></li>
						  <li><a href="https://ethoscreations.com/affiliate-login">Affiliate</a></li>
						  <li><a href="http://ethoscreations.com/product-special">Specials</a></li>
						  <li><a href="https://ethoscreations.com/account-return-add">Returns</a></li>
						  <li><a href="https://ethoscreations.com/account-order">Order History</a></li>
						</ul>
					</div>
				</div>
			  </div-->
			  <!--div class="col col-md-2 col-sm-6">
				<div class="btn-group">	
					<h5 data-toggle="dropdown" class="dropdown-toggle">My Account<i class="visible-xs ion-chevron-down"></i></h5>
					<div class="dropdown-menu">	
						<ul class="list-unstyled">
						  <li><a href="https://ethoscreations.com/index.php?route=account/account">My Account</a></li>
						  <li><a href="https://ethoscreations.com/account-order">Order History</a></li>
						  <li><a href="https://ethoscreations.com/index.php?route=account/wishlist">Wish List</a></li>
						  <li><a href="https://ethoscreations.com/index.php?route=account/newsletter">Newsletter</a></li>
						</ul>
					</div>
				</div>
			  </div-->
			  
			  <div class="col col-md-3 col-sm-6">
				<div class="btn-group">
					<h5 >Follow Us</h5>
					<div class="footer-content">	
						<div class="social">
  <a href="https://www.facebook.com/PlazaThemes1/" class="facebook" target="_blank" title="Facebook"><span>Facebook</span></a>
  <a href="https://twitter.com/plazathemes" target="_blank" class="twitter" title="Twitter"><span>Twitter</span></a>
  <a href="#" target="_blank" class="google" title="Google+"><span>Google</span></a>
  <a href="#" target="_blank" class="instagram" title="Instagram"><span>Instagram</span></a>
  <a href="https://www.youtube.com/user/plazathemes" target="_blank" class="youtube" title="Youtube"><span>Youtube</span></a>
</div>


					</div>
				</div>
			  </div>
			</div>
			<div class="newsletter-group">
				    <div class="newsletter-container newsletter-block">
        
		<div class="newsletter-heading" >
        <h3>Subscribe For Newsletter</h3>
		<!--<p>Get E-mail updates about our latest shop and special offers.</p>-->
    </div>
	    <div class="newsletter-content">
        
        <div class="content">
            <!--<div class="col-md-6">
            <input type="text" class="newsletter_company" name="company" value="" placeholder="Company Name" />
            </div>
            <div class="col-md-6">
            <input type="text" class="newsletter_city" name="city" value="" placeholder="City" />
            </div>
            <div class="col-md-12">-->
            <input type="text" class="newsletter_email" name="mail_subscribe" value="" placeholder="Enter Email" />
            
            
            <button type="button" class="btn btn-primary" onclick="ptnewsletter.saveMail($(this));">Subscribe</button>
            <!--</div>-->
        </div>
            </div>
    <div class="newsletter-notification"></div>
	</div>
<script>
    ptnewsletter.checkCookie();
</script>
<div class="payment">
  <img src="image/catalog/ptblock/payment.png" alt="payment">
</div>


			</div>
		</div>
	  </div>
	</div>
	<div class="footer-copyright">
		<div class="container">
			<div class="inner">
				<p class="text-powered">Copyright 2023 <a href="https://ethoscreations.com/">Ethos Creation LLC</a> | All Rights Reserved | Designed &amp; Developed by <a href="https://web4jewelers.com/" target="_blank">Web4Jewelers.</a></p>
			</div>
		</div>
	</div>
</footer>
<!--
OpenCart is open source software and you are free to remove the powered by OpenCart if you want, but its generally accepted practise to make a small donation.
Please donate via PayPal to donate@opencart.com
//-->
</div></body></html>