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 = 4 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 = 4) AND (mg.id_shop = 4 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` = 4
AND id_shop = 4 LIMIT 1
SELECT `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' LIMIT 1
SELECT `iso_code`
FROM `ps_country`
WHERE `id_country` = 125 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 = 4
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 = 4
WHERE (a.id_currency = 1)
LIMIT 1
SELECT id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 4 LIMIT 1
SELECT *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 4
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 = 4 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 = 4
AND ml.id_shop = 4 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 = 4) 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` = 4)
WHERE c.active = 1
ORDER BY cl.name ASC
SELECT `iso_code`
FROM `ps_country`
WHERE `id_country` = 86 LIMIT 1
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` = 4)
WHERE c.active = 1
ORDER BY cl.name ASC
SELECT *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 4
WHERE (a.id_country = 125)
LIMIT 1
SELECT * FROM `ps_country_lang`
WHERE `id_country` = 125
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 = 4 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 = 4) AND (mg.id_shop = 4 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` = 4
LIMIT 1
) as mshop
FROM `ps_module` m
SELECT * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (4)
SELECT *
FROM `ps_themeconfigurator`
WHERE id_shop = 4 AND id_lang = 4
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` = 4
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 = 4 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 = 4) AND (mg.id_shop = 4 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 = 4 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 = 4) AND (mg.id_shop = 4 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 = 4 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 = 4) AND (mg.id_shop = 4 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 = 4 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 = 4) AND (mg.id_shop = 4 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 4)
WHERE c.`active` = 1
LIMIT 1
SELECT *
FROM `ps_themeconfigurator`
WHERE id_shop = 4 AND id_lang = 4
AND hook = 'footer' 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` = 4
Klientu atbalsts katru dienu
9-21:00 Tālrunis: +372 733 7700 Tālrunis 9-21:00 +372 733 7700 Veikali
SELECT c.id_cms, cl.link_rewrite, cl.meta_title
FROM ps_cms c
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 4)
INNER JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 4)
WHERE 1
AND c.id_cms IN (16) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
SELECT id_campaign FROM ps_campaign WHERE (campaign_start < '2025-01-08 23:42:28' AND campaign_end > '2025-01-08 23:42:28') AND only_logged_in_users = 0
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 494)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 494
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 494
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 515)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 515
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 515
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 516)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 516
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 516
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 579)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 579
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 579
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 581)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 581
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 581
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 585)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 585
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 585
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 608)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 608
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 608
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 632)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 632
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 632
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 637)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 637
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 637
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 639)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 639
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 639
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 652)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 652
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 652
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 653)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 653
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 653
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 669)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 669
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 669
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 712)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 712
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 712
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 715)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 715
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 715
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 731)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 731
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 731
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 733)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 733
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 733
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 737)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 737
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 737
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 741)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 741
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 741
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 753)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 753
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 753
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 802)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 802
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 802
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 809)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 809
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 809
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 827)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 827
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 827
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 835)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 835
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 835
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 836)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 836
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 836
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 838)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 838
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 838
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 520)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 520
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 520
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 231)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 231
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 231
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 710)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 710
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 710
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 824)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 824
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 824
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 841)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 841
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 841
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 433)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 433
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 433
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 559)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 559
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 559
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 625)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 625
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 625
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 304)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 304
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 304
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 326)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 326
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 326
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 412)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 412
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 412
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 435)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 435
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 435
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 564)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 564
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 564
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 617)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 617
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 617
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 634)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 634
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 634
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 662)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 662
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 662
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 672)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 672
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 672
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 673)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 673
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 673
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 682)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 682
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 682
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 683)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 683
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 683
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 690)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 690
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 690
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 703)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 703
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 703
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 704)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 704
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 704
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 706)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 706
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 706
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 716)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 716
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 716
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 718)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 718
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 718
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 759)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 759
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 759
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 760)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 760
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 760
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 761)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 761
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 761
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 768)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 768
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 768
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 778)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 778
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 778
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 779)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 779
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 779
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 784)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 784
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 784
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 794)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 794
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 794
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 801)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 801
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 801
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 803)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 803
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 803
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 804)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 804
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 804
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 811)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 811
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 811
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 819)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 819
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 819
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 839)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 839
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 839
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 656)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 656
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 656
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 45)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 45
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 45
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 46)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 46
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 46
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 199)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 199
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 199
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 43)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 43
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 43
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 44)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 44
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 44
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 71)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 71
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 71
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 74)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 74
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 74
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 75)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 75
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 75
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 168)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 168
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 168
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 4
WHERE (a.id_campaign = 185)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 185
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 185