Account Login

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/index.php?route=account/login' LIMIT 1

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/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/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/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/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/forgotten' AND (`language_id` = '1' OR `language_id` = 0)

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

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

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

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

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

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

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

SELECT *
FROM arp_layout_module
WHERE layout_id = '6' 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` = 'd489f968b6259aadb1e4df00354389c4' 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:22:18'

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 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 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)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10107' 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 = '10162' 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=10162' 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 = '10132' 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=10132' 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=61' 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 = '10124' 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 = '10181' 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=10124' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10181' 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 = '10170' 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=10124' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10170' 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 = '10173' 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=10124' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10173' 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 = '10171' 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=10124' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10171' 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=10124' 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 = '10109' 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 = '10169' 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=10109' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10169' 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=10109' 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 = '89' 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=89' 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 = '10108' 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 = '10154' 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=10108' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10154' 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=10108' 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 = '63' 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 = '10099' 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=63' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=10099' 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 = '101' 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=63' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=101' 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 = '88' 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=63' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=88' 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 = '87' 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=63' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_id=87' 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 = '97' 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=63' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_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/category' AND (`language_id` = '1' OR `language_id` = 0)

SELECT *
FROM arp_url_alias
WHERE `query` = 'category_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=common/language/language' 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=common/currency/currency' 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_extension
WHERE `type` = 'total'

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'