[views] setView, found: /home/eshopmia/public_html/system/core/../../application/views/miamiglobal.pickup/base.mate
[Database] SELECT contentlangs.* FROM contentlangs ORDER BY contentlangs.id
[Database] SELECT amazonusers.* FROM amazonusers WHERE amazonusers.status=1 ORDER BY amazonusers.id
[Database] SELECT amazonusers.* FROM amazonusers WHERE amazonusers.status=1 ORDER BY amazonusers.id
[Database] SELECT generalsettings.*, players.* FROM generalsettings LEFT JOIN players ON players.id = generalsettings.id_player WHERE generalsettings.name='eShopMiami' ORDER BY generalsettings.id
[Database] SELECT generalsetting_infos.*, contentlangs.*, generalsettings.* FROM generalsetting_infos LEFT JOIN contentlangs ON contentlangs.id = generalsetting_infos.id_contentlang LEFT JOIN generalsettings ON generalsettings.id = generalsetting_infos.id_generalsetting WHERE generalsetting_infos.id_generalsetting='10' AND generalsetting_infos.id_contentlang='1' ORDER BY generalsetting_infos.id
[Database] SELECT generalsetting_infos.*, contentlangs.*, generalsettings.* FROM generalsetting_infos LEFT JOIN contentlangs ON contentlangs.id = generalsetting_infos.id_contentlang LEFT JOIN generalsettings ON generalsettings.id = generalsetting_infos.id_generalsetting WHERE generalsetting_infos.id_generalsetting='10' AND generalsetting_infos.id_contentlang='2' ORDER BY generalsetting_infos.id
[Database] SELECT generalsettingbanners.*, generalsettings.* FROM generalsettingbanners LEFT JOIN generalsettings ON generalsettings.id = generalsettingbanners.id_generalsetting WHERE generalsettingbanners.id_generalsetting='10' ORDER BY generalsettingbanners.orden DESC
[Database] SELECT socialnetworks.* FROM socialnetworks ORDER BY orden DESC
[Database] SELECT CONCAT("",section_infos.name) as name,CONCAT("",if(section_infos.name!='',section_infos.name,sections.code)) as newcode,CONCAT("",sec.id) as children,CONCAT("",sect.code) as template, sections.*, sectiontemplates.* FROM sections LEFT JOIN sectiontemplates ON sectiontemplates.id = sections.id_sectiontemplate LEFT JOIN contentlangs ON contentlangs.code = 'es' LEFT JOIN section_infos ON sections.id = section_infos.id_section AND section_infos.id_contentlang=contentlangs.id LEFT JOIN sections as sec ON sections.id=sec.id_section LEFT JOIN sectiontemplates as sect ON sections.id_sectiontemplate=sect.id LEFT JOIN contentdomain ON contentdomain.contentid = CONCAT("section_",sections.id) AND contentdomain.id_generalsetting = '12' WHERE sections.id_section=0 AND sections.visible IN (1) AND sections.menu !='none' AND (contentdomain.id IS NULL or contentdomain.status = 1) ORDER BY sections.orden DESC
[Database] SELECT CONCAT("",section_infos.name) as name,CONCAT("",if(section_infos.name!='',section_infos.name,sections.code)) as newcode,CONCAT("",sec.id) as children,CONCAT("",sect.code) as template, sections.*, sectiontemplates.* FROM sections LEFT JOIN sectiontemplates ON sectiontemplates.id = sections.id_sectiontemplate LEFT JOIN contentlangs ON contentlangs.code = 'es' LEFT JOIN section_infos ON sections.id = section_infos.id_section AND section_infos.id_contentlang=contentlangs.id left JOIN sections as sec ON sections.id=sec.id_section left JOIN sectiontemplates as sect ON sections.id_sectiontemplate=sect.id LEFT JOIN contentdomain ON contentdomain.contentid = CONCAT("section_",sections.id) AND contentdomain.id_generalsetting = '12' WHERE sections.id_section=56 AND sections.visible IN (1) AND sections.menu like '%main%' AND (contentdomain.id IS NULL or contentdomain.status = 1) ORDER BY sections.orden ASC
[Database] SELECT CONCAT("",section_infos.name) as name,CONCAT("",if(section_infos.name!='',section_infos.name,sections.code)) as newcode,CONCAT("",sec.id) as children,CONCAT("",sect.code) as template, sections.*, sectiontemplates.* FROM sections LEFT JOIN sectiontemplates ON sectiontemplates.id = sections.id_sectiontemplate LEFT JOIN contentlangs ON contentlangs.code = 'es' LEFT JOIN section_infos ON sections.id = section_infos.id_section AND section_infos.id_contentlang=contentlangs.id left JOIN sections as sec ON sections.id=sec.id_section left JOIN sectiontemplates as sect ON sections.id_sectiontemplate=sect.id LEFT JOIN contentdomain ON contentdomain.contentid = CONCAT("section_",sections.id) AND contentdomain.id_generalsetting = '12' WHERE sections.id_section=56 AND sections.visible IN (1) AND sections.menu like '%footer%' AND (contentdomain.id IS NULL or contentdomain.status = 1) ORDER BY sections.orden ASC
[Database] SELECT CONCAT("",section_infos.name) as name,CONCAT("",if(section_infos.name!='',section_infos.name,sections.code)) as newcode,CONCAT("",sec.id) as children,CONCAT("",sect.code) as template, sections.*, sectiontemplates.* FROM sections LEFT JOIN sectiontemplates ON sectiontemplates.id = sections.id_sectiontemplate LEFT JOIN contentlangs ON contentlangs.code = 'es' LEFT JOIN section_infos ON sections.id = section_infos.id_section AND section_infos.id_contentlang=contentlangs.id left JOIN sections as sec ON sections.id=sec.id_section left JOIN sectiontemplates as sect ON sections.id_sectiontemplate=sect.id LEFT JOIN contentdomain ON contentdomain.contentid = CONCAT("section_",sections.id) AND contentdomain.id_generalsetting = '12' WHERE sections.id_section=46 AND sections.visible IN (1) AND sections.menu like '%footer%' AND (contentdomain.id IS NULL or contentdomain.status = 1) ORDER BY sections.orden ASC
[Database] SELECT CONCAT("",section_infos.name) as name,CONCAT("",if(section_infos.name!='',section_infos.name,sections.code)) as newcode,CONCAT("",sec.id) as children,CONCAT("",sect.code) as template, sections.*, sectiontemplates.* FROM sections LEFT JOIN sectiontemplates ON sectiontemplates.id = sections.id_sectiontemplate LEFT JOIN contentlangs ON contentlangs.code = 'es' LEFT JOIN section_infos ON sections.id = section_infos.id_section AND section_infos.id_contentlang=contentlangs.id left JOIN sections as sec ON sections.id=sec.id_section left JOIN sectiontemplates as sect ON sections.id_sectiontemplate=sect.id LEFT JOIN contentdomain ON contentdomain.contentid = CONCAT("section_",sections.id) AND contentdomain.id_generalsetting = '12' WHERE sections.id_section=7 AND sections.visible IN (1) AND sections.menu like '%main%' AND (contentdomain.id IS NULL or contentdomain.status = 1) ORDER BY sections.orden ASC
[Database] SELECT CONCAT("",section_infos.name) as name,CONCAT("",if(section_infos.name!='',section_infos.name,sections.code)) as newcode,CONCAT("",sec.id) as children,CONCAT("",sect.code) as template, sections.*, sectiontemplates.* FROM sections LEFT JOIN sectiontemplates ON sectiontemplates.id = sections.id_sectiontemplate LEFT JOIN contentlangs ON contentlangs.code = 'es' LEFT JOIN section_infos ON sections.id = section_infos.id_section AND section_infos.id_contentlang=contentlangs.id left JOIN sections as sec ON sections.id=sec.id_section left JOIN sectiontemplates as sect ON sections.id_sectiontemplate=sect.id LEFT JOIN contentdomain ON contentdomain.contentid = CONCAT("section_",sections.id) AND contentdomain.id_generalsetting = '12' WHERE sections.id_section=7 AND sections.visible IN (1) AND sections.menu like '%footer%' AND (contentdomain.id IS NULL or contentdomain.status = 1) ORDER BY sections.orden ASC
[Database] SELECT CONCAT("",section_infos.name) as name,CONCAT("",if(section_infos.name!='',section_infos.name,sections.code)) as newcode,CONCAT("",sec.id) as children,CONCAT("",sect.code) as template, sections.*, sectiontemplates.* FROM sections LEFT JOIN sectiontemplates ON sectiontemplates.id = sections.id_sectiontemplate LEFT JOIN contentlangs ON contentlangs.code = 'es' LEFT JOIN section_infos ON sections.id = section_infos.id_section AND section_infos.id_contentlang=contentlangs.id left JOIN sections as sec ON sections.id=sec.id_section left JOIN sectiontemplates as sect ON sections.id_sectiontemplate=sect.id LEFT JOIN contentdomain ON contentdomain.contentid = CONCAT("section_",sections.id) AND contentdomain.id_generalsetting = '12' WHERE sections.id_section=13 AND sections.visible IN (1) AND sections.menu like '%footer%' AND (contentdomain.id IS NULL or contentdomain.status = 1) ORDER BY sections.orden ASC
[Database] SELECT CONCAT("",section_infos.name) as name,CONCAT("",if(section_infos.name!='',section_infos.name,sections.code)) as newcode,CONCAT("",sec.id) as children,CONCAT("",sect.code) as template, sections.*, sectiontemplates.* FROM sections LEFT JOIN sectiontemplates ON sectiontemplates.id = sections.id_sectiontemplate LEFT JOIN contentlangs ON contentlangs.code = 'es' LEFT JOIN section_infos ON sections.id = section_infos.id_section AND section_infos.id_contentlang=contentlangs.id left JOIN sections as sec ON sections.id=sec.id_section left JOIN sectiontemplates as sect ON sections.id_sectiontemplate=sect.id LEFT JOIN contentdomain ON contentdomain.contentid = CONCAT("section_",sections.id) AND contentdomain.id_generalsetting = '12' WHERE sections.id_section=39 AND sections.visible IN (1) AND sections.menu like '%footer%' AND (contentdomain.id IS NULL or contentdomain.status = 1) ORDER BY sections.orden ASC
[Database] SELECT CONCAT("",section_infos.name) as name,CONCAT("",if(section_infos.name!='',section_infos.name,sections.code)) as newcode,CONCAT("",sec.id) as children,CONCAT("",sect.code) as template, sections.*, sectiontemplates.* FROM sections LEFT JOIN sectiontemplates ON sectiontemplates.id = sections.id_sectiontemplate LEFT JOIN contentlangs ON contentlangs.code = 'es' LEFT JOIN section_infos ON sections.id = section_infos.id_section AND section_infos.id_contentlang=contentlangs.id left JOIN sections as sec ON sections.id=sec.id_section left JOIN sectiontemplates as sect ON sections.id_sectiontemplate=sect.id LEFT JOIN contentdomain ON contentdomain.contentid = CONCAT("section_",sections.id) AND contentdomain.id_generalsetting = '12' WHERE sections.id_section=18 AND sections.visible IN (1) AND sections.menu like '%footer%' AND (contentdomain.id IS NULL or contentdomain.status = 1) ORDER BY sections.orden ASC
[Database] SELECT CONCAT("",section_infos.name) as name,CONCAT("",if(section_infos.name!='',section_infos.name,sections.code)) as newcode,CONCAT("",sec.id) as children,CONCAT("",sect.code) as template, sections.*, sectiontemplates.* FROM sections LEFT JOIN sectiontemplates ON sectiontemplates.id = sections.id_sectiontemplate LEFT JOIN contentlangs ON contentlangs.code = 'es' LEFT JOIN section_infos ON sections.id = section_infos.id_section AND section_infos.id_contentlang=contentlangs.id left JOIN sections as sec ON sections.id=sec.id_section left JOIN sectiontemplates as sect ON sections.id_sectiontemplate=sect.id LEFT JOIN contentdomain ON contentdomain.contentid = CONCAT("section_",sections.id) AND contentdomain.id_generalsetting = '12' WHERE sections.id_section=57 AND sections.visible IN (1) AND sections.menu like '%main%' AND (contentdomain.id IS NULL or contentdomain.status = 1) ORDER BY sections.orden ASC
[Database] SELECT CONCAT("",section_infos.name) as name,CONCAT("",if(section_infos.name!='',section_infos.name,sections.code)) as newcode,CONCAT("",sec.id) as children,CONCAT("",sect.code) as template, sections.*, sectiontemplates.* FROM sections LEFT JOIN sectiontemplates ON sectiontemplates.id = sections.id_sectiontemplate LEFT JOIN contentlangs ON contentlangs.code = 'es' LEFT JOIN section_infos ON sections.id = section_infos.id_section AND section_infos.id_contentlang=contentlangs.id left JOIN sections as sec ON sections.id=sec.id_section left JOIN sectiontemplates as sect ON sections.id_sectiontemplate=sect.id LEFT JOIN contentdomain ON contentdomain.contentid = CONCAT("section_",sections.id) AND contentdomain.id_generalsetting = '12' WHERE sections.id_section=57 AND sections.visible IN (1) AND sections.menu like '%footer%' AND (contentdomain.id IS NULL or contentdomain.status = 1) ORDER BY sections.orden ASC
[Database] SELECT box.status, COUNT(*) AS total FROM box WHERE box.id_user='' and box.id_order is null GROUP BY box.status
[Database] SELECT budgets.id_budgetstate, COUNT(*) AS total FROM budgets WHERE budgets.id_user='' and budgets.id_order is null and (id_offertime = 1 or (id_offertime != 1 and offer_end > now())) and budgets.type='normal' GROUP BY budgets.id_budgetstate
[Database] SELECT shippingaddress.*, users.* FROM shippingaddress LEFT JOIN users ON users.id = shippingaddress.id_user WHERE shippingaddress.id_user='' AND shippingaddress.is_default='1' ORDER BY shippingaddress.id
[views] setView, found: /home/eshopmia/public_html/system/core/../../application/views/miamiglobal.pickup/menu.mate
[View] /home/eshopmia/public_html/system/core/../../application/views/miamiglobal.pickup/menu.mate
[views] setView, found: /home/eshopmia/public_html/system/core/../../application/views/miamiglobal.pickup/footer.mate
[View] /home/eshopmia/public_html/system/core/../../application/views/miamiglobal.pickup/footer.mate
[Database] SELECT CONCAT('',section_infos.name) as pagename,CONCAT('',section_infos.page_title) as page_title,CONCAT('',section_infos.link_text) as text,CONCAT('',section_infos.meta_title) as meta_title,CONCAT('',section_infos.meta_keywords) as meta_keywords,CONCAT('',section_infos.meta) as meta,CONCAT('',sectiontemplates.code) as template,CONCAT('',sections.defaultcontent) as defaultcontent, sections.*, sectiontemplates.* FROM sections LEFT JOIN sectiontemplates ON sectiontemplates.id = sections.id_sectiontemplate LEFT JOIN contentlangs ON contentlangs.code = 'es' LEFT JOIN section_infos ON sections.id = section_infos.id_section AND section_infos.id_contentlang=contentlangs.id LEFT JOIN section_infos as secinfo ON sections.id = secinfo.id_section LEFT JOIN contentdomain ON contentdomain.contentid = CONCAT("section_",sections.id) AND contentdomain.id_generalsetting = '12' WHERE sections.visible IN (1) AND ( sections.code='Questions' OR secinfo.name='Questions') AND (contentdomain.id IS NULL or contentdomain.status = 1) ORDER BY sections.orden DESC LIMIT 1