Closed

sql query for fetch mails from Wordpress Contact 7 form and Woocommerce

i have one query but i need to modificate some

Contact 7 table is - pobierz-program as structure standard in Contact 7 plugin

SELECT DISTINCT(field_value) AS email, submit_time AS custom_id

FROM `wp_cf7dbplugin_submits`

WHERE form_name = "pobierz-program" AND field_name = "your-email"

AND submit_time >= "1404238627.0000"

GROUP by submit_time

I want to fetch mails from pobierz-program where date is 2016 year and email not in table woocoommerce (buyer) who bought product like id = 'someproduct2016' and some product id = 'someproduct2017'

Habilidades: SQL, WooCommerce, WordPress

Ver más: contact form outlook wordpress, contact form email wordpress, contact form slider wordpress theme, create pdf contact form submitted wordpress plugin, nexus contact form slider wordpress, contact form multisite wordpress, contact form slider wordpress, contact form paypal wordpress, paypal api integration contact form using wordpress, ajax contact form recaptcha wordpress, simple contact form revisited wordpress, contact form lightbox wordpress, contact form autoresponder wordpress, contact form calendar wordpress, software write mq4, software write chip epson, useful software write book, software write web specs, contact form maps wordpress, free software write user guide

Información del empleador:
( 73 comentarios ) Wrocław, Poland

Nº del proyecto: #12731124

29 freelancers están ofertando el promedio de zł78 para este trabajo

linuxfreak1985

Hi, Sir I am ready to start now I have fully read your project description and may i ask few questions about Woocommerce backend functionality part of the website? Mentioned below is my Past Portfolio http://portf Más

zł87 PLN en 1 día
(318 comentarios)
7.5
GetReal

Freelance Professional! Ready to start now and have it done for you ASAP! Look forward to hear from you and work with you...Thanks!

zł75 PLN en 0 días
(284 comentarios)
7.0
DSAssociates

Hello There, My name is DS, New Zealand based freelance designer/developer here. With more than 12 years of experience i worked for various clients across Australia, New Zealand and UK. Worked on projects ranging fro Más

zł90 PLN en 2 días
(27 comentarios)
6.2
moderninfotech

Hello, We have recently customized Woocommerce for single artwork upload for every product as well as overcome limitation of WooCommerce variations in following website; digiprints.com. Also we have customized WooCo Más

zł132 PLN en 1 día
(86 comentarios)
6.3
yogeshssanwal

I am Yogesh sanwal, 5+ years experienced in website and e-commerce development using PHP/MySQL and Internet Marketing. Take a look to my last work: [login to view URL] [login to view URL] http: Más

zł75 PLN en 1 día
(106 comentarios)
6.1
VnBestSolutions

Dear Sir. I had read your descriptions about project. Kindly give me a chance, i would like to discuss more about project and sure everything clear. Please drop me messages when you have free time. Any your queries and Más

zł135 PLN en 3 días
(61 comentarios)
5.9
webcast

Hello sir/mam, I am good at : 1. WordPress web development 2. PSD to HTML 3. Responsive web development 4. Graphics Designing 5. Photoshop 6. PHP 7. html + CSS Styling 8. js & jQuery. you can check my Más

zł75 PLN en 1 día
(36 comentarios)
4.8
nivasoftvietnam

TRY VIETNAMESE DEVELOPER. “Trial 30% your work before, pay later” is my work principle. We have a production warranty in 12 months if there are errors from what we made Can you see the Web Wordpress services in the li Más

zł105 PLN en 1 día
(30 comentarios)
4.9
tikumishra

Hi I can quickly fix your SQL as you are looking for, as I am aware of Contact Form 7 and WooCommerce DB Tables details. Let me know, if interested, I can start right away. Thanks

zł95 PLN en 1 día
(17 comentarios)
4.6
surender6789

SENIOR WORDPRESS DEVELOPER WITH 6+ YEARS EXPERIENCE Thank you for such a great opportunity. I am very glad to see your Job Posting according to my skill set. I have read your requirements and I’m pretty confiden Más

zł115 PLN en 1 día
(17 comentarios)
4.9
gamdurbhullar

Hello There, I hope you are doing well. I have read your requirements carefully and I am very much confident to execute your requirements successfully. I am very expert in PHP , Laravel Framework ,Magento ,WordP Más

zł75 PLN en 1 día
(24 comentarios)
4.5
pasuf

I have excellent reviews, a near 100% completion rating and I have earned my preferred freelancer badge. I have read over your project description and I'm interested in completing your task. I am a professional with ro Más

zł212 PLN en 1 día
(11 comentarios)
4.4
zł55 PLN en 1 día
(24 comentarios)
4.4
webarox

Hello i can modify your sql query which fetch all mails from wp and woo-commerce.I am having 7+ years work experience in Wordpress and other CMS and Framework. I can give you my best if you provide me the details. Cou Más

zł95 PLN en 1 día
(18 comentarios)
4.6
vw7590795vw

Please review my profile. Please let me know when we will start.

zł44 PLN en 0 días
(15 comentarios)
3.6
saaz109

Hello sir, Hope you doing well, i read your project description so pls come technical I am very much sure that I can complete work as per your requirements.I assure you that I will provide you quality work and wit Más

zł45 PLN en 1 día
(8 comentarios)
4.3
swarm22

I am able to build query for that. give me database details , i will do as per requirements. I have +4 years experience in SQL query development.

zł85 PLN en 1 día
(5 comentarios)
2.8
zł75 PLN en 1 día
(4 comentarios)
2.4
INneerajlodhi

Pay after satisfaction. I am very experienced in web only the to work at too low cost is to build my profile here because i am new to this [login to view URL] matters always. No formal quote and profile my work speaks Más

zł45 PLN en 1 día
(2 comentarios)
1.3
vsingote

Dear Project Owner, Great Experience in CI I have Completed 30+ Websites (WordPress, CodeIgnitor, Shopify, Core PHP) I am Sharing you with my WordPress portfolios http://ww Más

zł30 PLN en 1 día
(1 comentario)
1.1