Связаться с нами

SELECT *
FROM pr_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://yavinav.ru/'

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

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

SELECT *
FROM pr_currency

SELECT *
FROM pr_weight_class wc
LEFT JOIN pr_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'

SELECT *
FROM pr_length_class mc
LEFT JOIN pr_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'

SELECT *
FROM pr_url_alias
WHERE `query` = 'common/home'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information/contact'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information/contact'

select curdate() as today, timestampadd(day,1,curdate()) as tommorow

SELECT *
FROM pr_layout_route
WHERE 'information/contact' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM pr_extension
WHERE `type` = 'module'

SELECT *
FROM pr_layout_route
WHERE 'information/contact' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM pr_extension
WHERE `type` = 'module'

SELECT *
FROM pr_layout_route
WHERE 'information/contact' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM pr_extension
WHERE `type` = 'module'

SELECT *
FROM pr_layout_route
WHERE 'information/contact' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM pr_extension
WHERE `type` = 'module'

SELECT *
FROM pr_information i
LEFT JOIN pr_information_description id ON (i.information_id = id.information_id)
LEFT JOIN pr_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC

SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=6'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=4'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=7'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=3'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=5'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information/contact'

SELECT *
FROM pr_url_alias
WHERE `query` = 'account/return/insert'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information/sitemap'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/manufacturer'

SELECT *
FROM pr_url_alias
WHERE `query` = 'account/voucher'

SELECT *
FROM pr_url_alias
WHERE `query` = 'affiliate/account'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/special'

SELECT *
FROM pr_url_alias
WHERE `query` = 'account/account'

SELECT *
FROM pr_url_alias
WHERE `query` = 'account/order'

SELECT *
FROM pr_url_alias
WHERE `query` = 'account/wishlist'

SELECT *
FROM pr_url_alias
WHERE `query` = 'account/newsletter'

DELETE
FROM `pr_customer_online`
WHERE (UNIX_TIMESTAMP(`date_added`) + 3600) < UNIX_TIMESTAMP(NOW())

REPLACE INTO `pr_customer_online` SET `ip` = '18.221.146.223', `customer_id` = '0', `url` = 'http://yavinav.ru/?route=information/contact', `referer` = '', `date_added` = NOW()

SELECT *
FROM pr_url_alias
WHERE `query` = 'account/login'

SELECT *
FROM pr_url_alias
WHERE `query` = 'account/register'

SELECT *
FROM pr_url_alias
WHERE `query` = 'account/account'

SELECT *
FROM pr_url_alias
WHERE `query` = 'account/logout'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/showproductall'

SELECT *
FROM pr_url_alias
WHERE `query` = 'common/home'

SELECT *
FROM pr_url_alias
WHERE `query` = 'account/wishlist'

SELECT *
FROM pr_url_alias
WHERE `query` = 'account/account'

SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/cart'

SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/checkout'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information/about_us'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information/payment_and_delivery'

SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '57' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'

SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '17' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=17'

SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '60' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=60'

SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=59'

SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '24' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '62' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=62'

SELECT *
FROM pr_url_alias
WHERE `query` = 'pavblog/blogs'

SELECT *
FROM pr_url_alias
WHERE `query` = 'module/language'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information/contact'

SELECT *
FROM pr_url_alias
WHERE `query` = 'module/currency'

SELECT *
FROM pr_url_alias
WHERE `query` = 'information/contact'

SELECT *
FROM pr_extension
WHERE `type` = 'total'

SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/cart'

SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/checkout'