Greek traditional and organic products of the highest quality

Kalimera

Facebook like

37 queries executed
1
SELECT * FROM elx_core_acl_access_lists
2 SELECT seotitle FROM elx_sections WHERE scope='content' AND ((seotitle != '') OR (seotitle IS NOT NULL))
3 SELECT id, link FROM elx_menu WHERE menutype='mainmenu' AND published='1' AND ((language IS NULL) OR (language LIKE '%english%')) ORDER BY parent, ordering
4 SELECT template, params FROM elx_templates_menu WHERE client_id='0' AND menuid='72'
5 SELECT template, params FROM elx_templates_menu WHERE client_id='0' AND menuid='0'
6 DELETE FROM elx_session WHERE (time < 1461978653)
7 SELECT * FROM elx_session WHERE session_id='e8e08f965dd55a9c5d1f0fc98cac3320'
8 SELECT session_id FROM elx_session WHERE session_id='2edda35ebaeb5ee60e1fbedd987c5499'
9 INSERT INTO elx_session ( `session_id`,`time`,`username`,`gid`,`allowed`,`guest`,`ip` ) VALUES ( 'c5141ef306f44d1a024128fc6da09dcf','1461987653',NULL,'29','29','1','54.234.224.39' )
10 SELECT name FROM elx_core_acl_aro_groups WHERE group_id='29'
11 SELECT id, sdvalue FROM elx_softdisk WHERE sdsection='STATICCACHE' AND sdname='COM_ESHOP'
12 SELECT folder, element, published, CONCAT(folder,'/',element) AS lookup FROM elx_mambots WHERE published > 0 AND access IN (29) AND folder='editors' ORDER BY ordering
13 SELECT folder, element, published, CONCAT(folder,'/',element) AS lookup FROM elx_mambots WHERE published > 0 AND access IN (29) AND folder='editors-xtd' ORDER BY ordering
14 SELECT access FROM elx_menu WHERE id='72'
15 SELECT sgid, sgtitle FROM elx_eshop_groups WHERE sgcountries LIKE '%GR%'
16 SELECT sgtitle FROM elx_eshop_groups WHERE sgid='1'
17 SELECT cid, title, dialect1, dialect2, dialect3, seotitle, products_count, picture FROM elx_eshop_categories WHERE parent='0' AND published='1' ORDER BY ordering ASC
18 SELECT cid, parent, products_count FROM elx_eshop_categories WHERE parent IN (13,12,33,10,31,15,32,67,41,6,48,4,5,42,46,37,47,49,51,52,61,81,66,63,26,14,83,84,85) AND published='1'
19 SELECT parent, products_count FROM elx_eshop_categories WHERE parent IN (7,8,9,11,16,17,18,19,20,21,22,23,24,25,34,35,36,38,39,43,44,45,50,53,54,55,56,57,58,59,60,62,64,65,68,69,70,71,72,73,74,75,76,77,78,79,80,82) AND published='1' AND products_count > 0
20 SELECT p.id, p.cid, p.title, p.dialect1, p.dialect2, p.dialect3, i.file AS image, c.seotitle, r.price, r.discount, r.tax FROM elx_eshop_products p LEFT JOIN elx_eshop_categories c ON c.cid=p.cid LEFT JOIN elx_eshop_prices r ON r.id=p.id LEFT JOIN elx_eshop_images i ON i.id=p.id WHERE p.specialoffer='1' AND p.published='1' AND c.published='1' AND r.sgid='1' GROUP BY p.id ORDER BY p.dateadded DESC
21 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, m.language FROM elx_modules m, elx_modules_menu mm WHERE m.published='1' AND m.access IN (29) AND m.client_id='0' AND ((m.language IS NULL) OR (m.language LIKE '%english%')) AND mm.moduleid=m.id AND ((mm.menuid = '0') OR (mm.menuid = '72')) ORDER BY m.ordering
22 SELECT id FROM elx_components WHERE name = 'Syndicate'
23 SELECT * FROM elx_components WHERE id='17'
24 SELECT id, title, module, position, content, showtitle, params, language FROM elx_modules WHERE module='mod_search' AND published='1' AND access IN (29) AND client_id='0' AND ((language IS NULL) OR (language LIKE '%english%'))
25 SELECT * FROM elx_menu WHERE menutype='topmenu' AND published='1' AND access IN (29) AND ((language IS NULL) OR (language LIKE '%english%')) ORDER BY parent,ordering
26 SELECT * FROM elx_eshop_categories WHERE published='1' ORDER BY parent ASC, ordering ASC
27 SELECT id, language FROM elx_menu WHERE id='72'
28 SELECT COUNT(session_id) FROM elx_session WHERE gid='29'
29 SELECT COUNT(DISTINCT username) FROM elx_session WHERE userid<>'0' AND gid <> '29'
30 UPDATE elx_eshop_cart SET userid='0', ipaddress='54.234.224.39' WHERE session_id='vx7JkpsxR9V7JFpB28EwTh2WuWBYlhoxUfDpl6zyPcewBuERZxom9UTF'
31 SELECT b.cartid, b.quantity, b.variant, p.id, p.cid, p.immaterial, p.weight, r.price, r.discount, r.tax FROM elx_eshop_cart b LEFT JOIN elx_eshop_products p ON p.id=b.product_id LEFT JOIN elx_eshop_categories c ON c.cid=p.cid LEFT JOIN elx_eshop_prices r ON r.id=p.id WHERE b.session_id='vx7JkpsxR9V7JFpB28EwTh2WuWBYlhoxUfDpl6zyPcewBuERZxom9UTF' AND p.published='1' AND c.published='1' AND r.sgid='1' GROUP BY p.id
32 SELECT COUNT(*) FROM elx_banner WHERE showbanner = '1'
33 SELECT * FROM elx_banner WHERE showbanner = '1' ORDER BY rand()
34 SELECT * FROM elx_banner WHERE showbanner = '1' AND bid NOT IN (0,7) ORDER BY rand()
35 SELECT * FROM elx_banner WHERE showbanner = '1' AND bid IN (0,7) ORDER BY rand()
36 UPDATE elx_banner SET impmade = impmade + 1 WHERE bid = '7'
37 SELECT p.id, p.cid, p.title, p.dialect1, p.dialect2, p.dialect3, p.mid, p.immaterial, p.sku, p.in_stock, p.specialoffer, p.offerexpire, c.title AS ctitle, c.dialect1 AS cdialect1, c.dialect2 AS cdialect2, c.dialect3 AS cdialect3, c.seotitle, m.manufacturer, r.price, r.discount, r.tax, i.file AS image FROM elx_eshop_products p LEFT JOIN elx_eshop_categories c ON c.cid=p.cid LEFT JOIN elx_eshop_manufacturers m ON m.mid=p.mid LEFT JOIN elx_eshop_prices r ON r.id=p.id LEFT JOIN elx_eshop_images i ON i.id=p.id WHERE p.published='1' AND c.published='1' AND r.sgid='1' GROUP BY p.id ORDER BY p.dateadded DESC