Fermé

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 >= "[url removed, login to view]"

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'

Compétences : SQL, WooCommerce, WordPress

Voir plus : contact form outlook wordpress, contact form email wordpress, contact form multisite wordpress, contact form slider wordpress, contact form paypal 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, software write edid, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, software write technical manual

Concernant l'employeur :
( 73 commentaires ) Wrocław, Poland

N° du projet : #12731124

30 freelance ont fait une offre moyenne de 78 zł pour ce travail

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 Plus

87 zł PLN en 1 jour
(286 Commentaires)
7.4
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!

75 zł PLN en 0 jours
(233 Commentaires)
6.7
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 Plus

90 zł PLN en 2 jours
(23 Commentaires)
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 Plus

135 zł PLN en 3 jours
(59 Commentaires)
5.9
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 Plus

132 zł PLN en 1 jour
(65 Commentaires)
6.0
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: [url removed, login to view] [url removed, login to view] http: Plus

75 zł PLN en 1 jour
(77 Commentaires)
5.5
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 Plus

75 zł PLN en 1 jour
(32 Commentaires)
4.7
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

95 zł PLN en 1 jour
(16 Commentaires)
4.6
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 Plus

75 zł PLN en 1 jour
(20 Commentaires)
4.3
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 Plus

212 zł PLN en 1 jour
(10 Commentaires)
4.3
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 Plus

115 zł PLN en 1 jour
(16 Commentaires)
4.8
55 zł PLN en 1 jour
(20 Commentaires)
4.2
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 Plus

95 zł PLN en 1 jour
(14 Commentaires)
4.5
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 Plus

45 zł PLN en 1 jour
(4 Commentaires)
4.0
vw7590795vw

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

44 zł PLN en 0 jours
(9 Commentaires)
3.1
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 Plus

105 zł PLN en 1 jour
(7 Commentaires)
3.1
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.

85 zł PLN en 1 jour
(4 Commentaires)
2.8
75 zł PLN en 1 jour
(3 Commentaires)
2.2
VivekGoswami

hello Sir. I can created query as per your requirement, Discuss your requirement on Privat massage. Thanks You Vivek

75 zł PLN en 1 jour
(1 Commentaire)
0.0
45 zł PLN en 1 jour
(0 Commentaires)
0.0