SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = 2 AND id_shop = 1 LIMIT 1 SELECT `id_country` FROM `ps_country` WHERE `iso_code` = 'US' LIMIT 1 SELECT `iso_code` FROM `ps_country` WHERE `id_country` = 86 LIMIT 1 SELECT `id_country` FROM `ps_country` WHERE `iso_code` = 'US' LIMIT 1 SELECT * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 21) LIMIT 1 SELECT * FROM `ps_country_lang` WHERE `id_country` = 21 SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 1) LIMIT 1 SELECT id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 SELECT * FROM `ps_group` a LEFT JOIN `ps_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 1 WHERE (a.id_group = 1) LIMIT 1 SELECT * FROM `ps_group_lang` WHERE `id_group` = 1 SELECT id_shop FROM `ps_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta WHERE ( m.page = "cart" OR m.page = "cart" ) AND ml.id_lang = 2 AND ml.id_shop = 1 LIMIT 1 SELECT * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC SELECT `id_country` FROM `ps_country` WHERE `iso_code` = 'US' LIMIT 1 SELECT gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name SELECT c.id_country, c.iso_code, cl.name as name FROM `ps_country` c INNER JOIN `ps_country_shop` cs ON (cs.`id_country`= c.`id_country` AND cs.id_shop = 1) INNER JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2) WHERE c.active = 1 ORDER BY cl.name ASC SELECT c.id_country, c.iso_code, cl.name as name FROM `ps_country` c INNER JOIN `ps_country_shop` cs ON (cs.`id_country`= c.`id_country` AND cs.id_shop = 4) INNER JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2) WHERE c.active = 1 ORDER BY cl.name ASC SELECT `iso_code` FROM `ps_country` WHERE `id_country` = 125 LIMIT 1 SELECT * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 86) LIMIT 1 SELECT * FROM `ps_country_lang` WHERE `id_country` = 86 SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` SELECT `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name SELECT m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1) SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 2 AND hook = 'home' AND active = 1 ORDER BY item_order ASC SELECT r.`id_textwidget`, r.`id_shop`, rl.`text`, rl.`title` FROM `ps_textwidget` r LEFT JOIN `ps_textwidget_lang` rl ON (r.`id_textwidget` = rl.`id_textwidget`) WHERE `id_lang` = 2 SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 2 AND hook = 'footer' AND active = 1 ORDER BY item_order ASC Cart - Photopoint
SELECT r.`id_textwidget`, r.`id_shop`, rl.`text`, rl.`title` FROM `ps_textwidget` r LEFT JOIN `ps_textwidget_lang` rl ON (r.`id_textwidget` = rl.`id_textwidget`) WHERE `id_lang` = 2
Pealeht

Tootevõrdlus

Sulge
SELECT id_campaign FROM ps_campaign WHERE (campaign_start < '2025-01-08 23:42:41' AND campaign_end > '2025-01-08 23:42:41') AND only_logged_in_users = 0 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 494 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 515 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 516 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 579 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 581 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 585 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 608 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 632 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 637 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 639 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 652 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 653 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 669 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 712 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 715 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 731 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 733 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 737 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 741 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 753 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 802 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 809 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 827 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 835 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 836 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 838 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 520 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 231 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 710 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 824 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 841 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 433 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 559 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 625 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 304 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 326 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 412 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 435 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 564 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 617 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 634 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 662 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 672 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 673 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 682 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 683 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 690 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 703 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 704 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 706 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 716 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 718 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 759 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 760 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 761 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 768 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 778 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 779 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 784 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 794 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 801 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 803 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 804 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 811 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 819 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 839 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 656 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 45 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 46 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 199 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 43 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 44 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 71 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 74 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 75 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 168 SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 185