SELECT SQL_CALC_FOUND_ROWS u.s_phone_land as s_phone_land, (SELECT count(*) FROM oc_fr_fr_t_item_resource where fk_i_item_id = oc_fr_fr_t_item.pk_i_id) as resource_count, meta.s_value as s_ad_type, meta_price.s_value as s_price_type, d.s_title as s_title, d.s_description as s_description, loc.*, city.s_slug as s_city_slug, region.s_slug as s_region_slug, cat.s_name as s_category_name, cat.s_slug as s_category_slug, cat.fk_i_category_id, oc_fr_fr_t_item.*, oc_fr_fr_t_item.s_contact_name as s_user_name FROM ( SELECT * FROM (oc_fr_fr_t_item) WHERE oc_fr_fr_t_item.b_deleted = 0 AND oc_fr_fr_t_item.b_enabled = 1 AND oc_fr_fr_t_item.b_active = 1 AND oc_fr_fr_t_item.b_spam = 0 AND (oc_fr_fr_t_item.b_premium = 1 || oc_fr_fr_t_item.dt_expiration >= '2020-04-02 01:39:08') AND oc_fr_fr_t_item.pk_i_id IN (SELECT fk_i_item_id FROM oc_fr_fr_t_item_meta WHERE oc_fr_fr_t_item_meta.fk_i_item_id = oc_fr_fr_t_item.pk_i_id AND oc_fr_fr_t_item_meta.fk_i_field_id = 1 AND oc_fr_fr_t_item_meta.s_value = 'service') ORDER BY COALESCE(oc_fr_fr_t_item.dt_order_date, oc_fr_fr_t_item.dt_pub_date) desc LIMIT 0, 1000) oc_fr_fr_t_item LEFT JOIN oc_fr_fr_t_user u ON oc_fr_fr_t_item.fk_i_user_id = u.pk_i_id JOIN oc_fr_fr_t_item_meta meta ON meta.fk_i_item_id = oc_fr_fr_t_item.pk_i_id AND meta.fk_i_field_id = 1 LEFT JOIN oc_fr_fr_t_item_meta meta_price ON meta_price.fk_i_item_id = oc_fr_fr_t_item.pk_i_id AND meta_price.fk_i_field_id = 12 JOIN oc_fr_fr_t_item_description d ON d.fk_i_item_id = oc_fr_fr_t_item.pk_i_id AND d.fk_c_locale_code = 'fr_FR' JOIN oc_fr_fr_t_item_location loc ON loc.fk_i_item_id = oc_fr_fr_t_item.pk_i_id JOIN oc_fr_fr_t_city city ON city.pk_i_id = loc.fk_i_city_id JOIN oc_fr_fr_t_region region ON region.pk_i_id = loc.fk_i_region_id JOIN oc_fr_fr_t_category_description cat ON cat.fk_i_category_id = oc_fr_fr_t_item.fk_i_category_id AND cat.fk_c_locale_code = 'fr_FR' ORDER BY COALESCE(oc_fr_fr_t_item.dt_order_date, oc_fr_fr_t_item.dt_pub_date) desc LIMIT 0, 20
Dernières annonces ajoutées - PepsDom - Services à domicile https://www.pepsdom.fr/ Dernières annonces ajoutées dans PepsDom - Services à domicile <![CDATA[]]> https://www.pepsdom.fr/peintre/peintre-en-batiment-i64796 https://www.pepsdom.fr/peintre/peintre-en-batiment-i64796 ]]> Tue, 31 Mar 2020 11:39:54 +0200 <![CDATA[]]> https://www.pepsdom.fr/nettoyage-sol-murs/agent-d-entretien-de-maison-i64795 https://www.pepsdom.fr/nettoyage-sol-murs/agent-d-entretien-de-maison-i64795 ]]> Tue, 31 Mar 2020 11:26:07 +0200 <![CDATA[]]> https://www.pepsdom.fr/cours-anglais/cours-d-espagnol-en-ligne-i64793 https://www.pepsdom.fr/cours-anglais/cours-d-espagnol-en-ligne-i64793 ]]> Tue, 31 Mar 2020 11:13:35 +0200 <![CDATA[]]> https://www.pepsdom.fr/cours-anglais/cours-d-anglais-par-un-pro-i64794 https://www.pepsdom.fr/cours-anglais/cours-d-anglais-par-un-pro-i64794 ]]> Tue, 31 Mar 2020 11:24:09 +0200 <![CDATA[]]> https://www.pepsdom.fr/preparation-repas-seniors/services-a-domicile-cuisine-menage-courses-i64788 https://www.pepsdom.fr/preparation-repas-seniors/services-a-domicile-cuisine-menage-courses-i64788 ]]> Mon, 30 Mar 2020 09:30:39 +0200 <![CDATA[]]> https://www.pepsdom.fr/coach-sportif/coach-sportif-a-domicile-i64786 https://www.pepsdom.fr/coach-sportif/coach-sportif-a-domicile-i64786 ]]> Mon, 30 Mar 2020 09:16:20 +0200 <![CDATA[]]> https://www.pepsdom.fr/depannage-informatique/depanneur-informatique-pour-les-particuliers-i64785 https://www.pepsdom.fr/depannage-informatique/depanneur-informatique-pour-les-particuliers-i64785 ]]> Sat, 28 Mar 2020 13:40:21 +0100 <![CDATA[]]> https://www.pepsdom.fr/creation-site/creation-ergonomique-de-votre-site-web-i64784 https://www.pepsdom.fr/creation-site/creation-ergonomique-de-votre-site-web-i64784 ]]> Sat, 28 Mar 2020 13:37:13 +0100 <![CDATA[]]> https://www.pepsdom.fr/gardiennage/gardiennage-et-autres-services-a-domicile-i64783 https://www.pepsdom.fr/gardiennage/gardiennage-et-autres-services-a-domicile-i64783 ]]> Sat, 28 Mar 2020 13:27:04 +0100 <![CDATA[]]> https://www.pepsdom.fr/demenagement/demenagement-securise-avec-possibilite-d-intervention-d-urgence-i64782 https://www.pepsdom.fr/demenagement/demenagement-securise-avec-possibilite-d-intervention-d-urgence-i64782 ]]> Sat, 28 Mar 2020 13:23:30 +0100 <![CDATA[]]> https://www.pepsdom.fr/aide-personnes-agees/aide-aux-personnes-agees-de-nuits-de-jours-i64781 https://www.pepsdom.fr/aide-personnes-agees/aide-aux-personnes-agees-de-nuits-de-jours-i64781 ]]> Sat, 28 Mar 2020 13:08:36 +0100 <![CDATA[]]> https://www.pepsdom.fr/cours-maths/cours-particuliers-mathematiques-et-physique-i64777 https://www.pepsdom.fr/cours-maths/cours-particuliers-mathematiques-et-physique-i64777 ]]> Fri, 27 Mar 2020 10:25:16 +0100 <![CDATA[]]> https://www.pepsdom.fr/auxiliaire-vie/assistante-de-vie-experimentee-i64776 https://www.pepsdom.fr/auxiliaire-vie/assistante-de-vie-experimentee-i64776 ]]> Fri, 27 Mar 2020 10:05:27 +0100 <![CDATA[]]> https://www.pepsdom.fr/baby-sitting/etudiante-cherche-travail-comme-babysitter-i64779 https://www.pepsdom.fr/baby-sitting/etudiante-cherche-travail-comme-babysitter-i64779 ]]> Fri, 27 Mar 2020 10:43:49 +0100 <![CDATA[]]> https://www.pepsdom.fr/cours-guitare/cours-de-guitare-en-ligne-i64775 https://www.pepsdom.fr/cours-guitare/cours-de-guitare-en-ligne-i64775 ]]> Fri, 27 Mar 2020 09:58:41 +0100 <![CDATA[]]> https://www.pepsdom.fr/jardinage/jardinier-amateur-a-votre-service-i64771 https://www.pepsdom.fr/jardinage/jardinier-amateur-a-votre-service-i64771 ]]> Thu, 26 Mar 2020 09:47:09 +0100 <![CDATA[]]> https://www.pepsdom.fr/plombier/installation-de-chaudiere-i64770 https://www.pepsdom.fr/plombier/installation-de-chaudiere-i64770 ]]> Thu, 26 Mar 2020 09:43:13 +0100 <![CDATA[]]> https://www.pepsdom.fr/cours-economie/soutien-scolaire-pour-tous-les-niveaux-i64772 https://www.pepsdom.fr/cours-economie/soutien-scolaire-pour-tous-les-niveaux-i64772 ]]> Thu, 26 Mar 2020 10:13:51 +0100 <![CDATA[]]> https://www.pepsdom.fr/peintre/peinture-et-deco-interieure-i64769 https://www.pepsdom.fr/peintre/peinture-et-deco-interieure-i64769 ]]> Thu, 26 Mar 2020 09:29:23 +0100 <![CDATA[]]> https://www.pepsdom.fr/jardinage/jardinier-paysagiste-pro-i64768 https://www.pepsdom.fr/jardinage/jardinier-paysagiste-pro-i64768 ]]> Thu, 26 Mar 2020 09:26:50 +0100