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 >= "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'

Compétences : SQL, WooCommerce, WordPress

Voir plus : 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, software write edid, free software write company profile, software write websites idea, software write book images, software write books

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

N° du projet : #12731124

29 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
(318 Commentaires)
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!

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

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

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

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

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

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

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

115 zł PLN en 1 jour
(17 Commentaires)
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 Plus

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

212 zł PLN en 1 jour
(11 Commentaires)
4.4
55 zł PLN en 1 jour
(24 Commentaires)
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 Plus

95 zł PLN en 1 jour
(18 Commentaires)
4.6
vw7590795vw

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

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

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

85 zł PLN en 1 jour
(5 Commentaires)
2.8
75 zł PLN en 1 jour
(4 Commentaires)
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 [url removed, login to view] matters always. No formal quote and profile my work speaks Plus

45 zł PLN en 1 jour
(2 Commentaires)
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 Plus

30 zł PLN en 1 jour
(1 Commentaire)
1.1