SELECT *
FROM arp_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://thehappyshoeshop.com.au/'

SELECT *
FROM `arp_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

SELECT *
FROM `arp_language`
WHERE status = '1'

SELECT *
FROM arp_currency

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM arp_tax_rule tr1
LEFT JOIN arp_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN arp_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN arp_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN arp_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 = '13' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '197')
ORDER BY tr1.priority ASC

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM arp_tax_rule tr1
LEFT JOIN arp_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN arp_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN arp_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN arp_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 = '13' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '197')
ORDER BY tr1.priority ASC

SELECT *
FROM arp_weight_class wc
LEFT JOIN arp_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'

SELECT *
FROM arp_length_class mc
LEFT JOIN arp_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'

SELECT *
FROM arp_extension
WHERE `type` = 'openbay'

SELECT *
FROM arp_event

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT redirect, language_id
FROM arp_url_redirect
WHERE query = 'https://thehappyshoeshop.com.au/' LIMIT 1

SELECT *
FROM arp_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM arp_layout_module
WHERE layout_id = '1' AND position = 'home_top_full'
ORDER BY sort_order

SELECT *
FROM arp_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM arp_layout_module
WHERE layout_id = '1' AND position = 'column_left'
ORDER BY sort_order

SELECT *
FROM arp_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM arp_layout_module
WHERE layout_id = '1' AND position = 'column_right'
ORDER BY sort_order

SELECT *
FROM arp_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM arp_layout_module
WHERE layout_id = '1' AND position = 'content_top'
ORDER BY sort_order

SELECT *
FROM arp_module
WHERE module_id = '80'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM arp_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM arp_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM arp_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM arp_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM arp_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM arp_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM arp_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM arp_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM arp_product p
LEFT JOIN arp_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN arp_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN arp_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109358' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM arp_product_image
WHERE product_id = '109358'
ORDER BY sort_order ASC

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/product' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'product_id=109358' AND (`language_id` = '1' OR `language_id` = 0)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM arp_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM arp_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM arp_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM arp_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM arp_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM arp_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM arp_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM arp_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM arp_product p
LEFT JOIN arp_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN arp_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN arp_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109357' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM arp_product_image
WHERE product_id = '109357'
ORDER BY sort_order ASC

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/product' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'product_id=109357' AND (`language_id` = '1' OR `language_id` = 0)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM arp_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM arp_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM arp_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM arp_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM arp_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM arp_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM arp_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM arp_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM arp_product p
LEFT JOIN arp_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN arp_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN arp_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109359' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM arp_product_image
WHERE product_id = '109359'
ORDER BY sort_order ASC

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/product' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'product_id=109359' AND (`language_id` = '1' OR `language_id` = 0)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM arp_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM arp_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM arp_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM arp_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM arp_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM arp_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM arp_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM arp_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM arp_product p
LEFT JOIN arp_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN arp_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN arp_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108859' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM arp_product_image
WHERE product_id = '108859'
ORDER BY sort_order ASC

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/product' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'product_id=108859' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_module
WHERE module_id = '76'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM arp_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM arp_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM arp_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM arp_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM arp_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM arp_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM arp_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM arp_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM arp_product p
LEFT JOIN arp_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN arp_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN arp_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108947' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM arp_product_image
WHERE product_id = '108947'
ORDER BY sort_order ASC

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/product' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'product_id=108947' AND (`language_id` = '1' OR `language_id` = 0)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM arp_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM arp_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM arp_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM arp_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM arp_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM arp_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM arp_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM arp_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM arp_product p
LEFT JOIN arp_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN arp_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN arp_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '107221' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM arp_product_image
WHERE product_id = '107221'
ORDER BY sort_order ASC

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/product' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'product_id=107221' AND (`language_id` = '1' OR `language_id` = 0)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM arp_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM arp_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM arp_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM arp_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM arp_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM arp_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM arp_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM arp_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM arp_product p
LEFT JOIN arp_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN arp_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN arp_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '106026' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM arp_product_image
WHERE product_id = '106026'
ORDER BY sort_order ASC

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/product' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'product_id=106026' AND (`language_id` = '1' OR `language_id` = 0)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM arp_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM arp_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM arp_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM arp_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM arp_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM arp_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM arp_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM arp_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM arp_product p
LEFT JOIN arp_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN arp_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN arp_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108668' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM arp_product_image
WHERE product_id = '108668'
ORDER BY sort_order ASC

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/product' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'product_id=108668' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_module
WHERE module_id = '73'

SELECT *
FROM arp_banner_image bi
LEFT JOIN arp_banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id)
WHERE bi.banner_id = '8' AND bid.language_id = '1'
ORDER BY bi.sort_order ASC

SELECT *
FROM arp_module
WHERE module_id = '78'

SELECT *
FROM arp_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM arp_layout_module
WHERE layout_id = '1' AND position = 'content_bottom'
ORDER BY sort_order

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/login' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'abandonedcarts'

SELECT *
FROM `arp_abandonedcarts`
WHERE `restore_id` = 'cd30cb3b0439a3253b75906e5929a88f' AND `ordered`=0

SELECT *
FROM arp_layout
WHERE name like '%Footer%' LIMIT 1

SELECT *
FROM arp_layout_module
WHERE layout_id = '0' AND position = 'footer'
ORDER BY sort_order

SELECT *
FROM arp_information i
LEFT JOIN arp_information_description id ON (i.information_id = id.information_id)
LEFT JOIN arp_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

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/information' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'information_id=4' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/information' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'information_id=8' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/information' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'information_id=6' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/information' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'information_id=3' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/information' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'information_id=5' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/information' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'information_id=7' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/contact' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/return/add' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/sitemap' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_extension
WHERE code = 'ka_product_warranty'

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/product_warranties/save' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/voucher' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=affiliate/account' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/special' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/account' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/order' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/wishlist' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/newsletter' AND (`language_id` = '1' OR `language_id` = 0)

DELETE
FROM `arp_customer_online`
WHERE date_added < '2023-11-29 23:13:38'

SELECT COUNT(*) AS total
FROM `arp_customer_online`
WHERE `ip` = '3.238.180.174'

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT route
FROM arp_mblog_layout_route
WHERE layout_id ='47' AND store_id = '0'

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT *
FROM arp_information i
LEFT JOIN arp_information_description id ON (i.information_id = id.information_id)
LEFT JOIN arp_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

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/information' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'information_id=4' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/information' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'information_id=8' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/information' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'information_id=6' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/information' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'information_id=3' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/information' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'information_id=5' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/information' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'information_id=7' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/account' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/logout' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/wishlist' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/account' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/register' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/login' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/order' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/transaction' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/download' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=account/logout' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=checkout/cart' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=checkout/checkout' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=information/contact' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=74' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=11' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=63' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=65' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=99' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=100' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=29' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=108' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=96' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=86' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=44' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=94' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=35' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=112' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=22' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=64' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=24' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=70' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=90' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=76' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=113' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=79' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=80' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=114' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=67' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=43' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=45' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=81' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=12' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=61' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=77' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=27' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=102' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=107' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=31' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=32' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=111' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=117' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=103' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=26' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=88' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=39' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=57' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=20' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=91' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=51' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=30' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=38' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=66' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=101' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=109' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=97' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=89' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=73' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=78' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=69' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=72' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=37' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=75' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=49' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=87' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=52' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=50' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=53' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=48' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=21' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=104' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=68' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=58' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=105' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=95' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=36' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=82' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=59' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=110' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=93' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=92' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=83' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=115' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=40' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=116' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=19' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=42' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=55' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=85' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=98' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=106' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/manufacturer/info' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'manufacturer_id=54' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_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)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10145' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10183' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10145' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10187' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10145' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10185' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10145' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10153' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10145' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10182' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10145' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10186' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10145' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10184' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10145' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10145' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_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)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10114' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10114' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10237' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10237' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10225' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10225' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10236' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10236' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10180' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10180' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10113' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10113' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10179' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10179' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10149' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10149' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10123' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10123' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10093' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10093' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10118' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10118' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10157' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10157' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=60' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_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)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10175' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=61' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10175' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10174' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=61' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10174' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10235' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=61' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10235' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10178' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=61' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10178' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10152' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=61' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10152' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10177' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=61' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10177' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_category c
LEFT JOIN arp_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN arp_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10107' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM arp_setting
WHERE store_id = '0' AND `code` = 'mblog_setting'

SELECT keyword
FROM arp_url_alias
WHERE `query` = 'route=product/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=61' AND (`language_id` = '1' OR `language_id` = 0)