Magento 1.9 make one mySQL Query for select random data from dba

$10-30 USD

Completed

Posted

over 5 years ago

$10-30 USD

Paid on delivery

Hi, I need mySQL query for database is Magento 1.9, I need select attribute from table: catalog_product_flat_1 sales_flat_invoice_grid sales_flat_invoice_item Last 10 Invoice one random product, costumer name, Country, product name, Time (h), image path, product link. I need only Query like this: SELECT * FROM sales_flat_invoice_item, sales_flat_invoice_grid WHERE sales_flat_invoice_item.product_id=sales_flat_invoice_grid.order_id ORDER BY RAND();"); Thanks

Project ID: 17658050

About the project

19 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@serkanakyol

Our expert team of Magento 1, 2 edition, Wordpress, Shopify, BigCommerce, OpenCart, Php, Laravel etc. We read your problem(s)/request(s) and can support you fast and high quality service with our team. You can contact us at any time. PusulaSoft Support Http://[login to view URL]

$25 USD in 1 day

5.0

(12 reviews)

4.5

19 freelancers are bidding on average $37 USD for this job

@sureshdevi

I will create mysql query to select one random product from last 10 invoices in Magento 1.9 website. I will complete this work in next few hours. Looking for your reply to start this work immediately. I will be available online from 2 am GMT to 5 pm GMT individual full-time freelancer.

$20 USD in 1 day

5.0

(1241 reviews)

8.2

@crystalhitesh

Dear Client, I am expert self-motivated and hardworking Magento developer having 8+ year experienced for both versions: 1.9 & 2.0. > Magento: 1.9 to 2.0. X > Commerce portal > Customization, template, API, Plugin > Multiple payment gateway > Community > API & Plugin > Multi vendor > Marketplace store > Custom module More discussion over chat Thanks

$25 USD in 1 day

4.8

(148 reviews)

6.7

@hasnut

HEllo, Did you get it solved? Lets Chat, one order can have multiple products Lets Chat, one order can have multiple products Thanks Sarder

$25 USD in 1 day

4.9

(196 reviews)

6.6

@jonyahmed105

I am ready to start now.. Thanks

$30 USD in 1 day

4.5

(188 reviews)

6.8

@softcarve

Hi, I would like to write mysql query to get random record from last 10 invoices. Get in touch to discuss more. Available to start now. Regards, Manish

$20 USD in 1 day

4.9

(129 reviews)

6.3

@Barrybk

Senor database administrator is here with expertise and grasp knowledge in multiple Databases. Looking forward to hear from you to resolve your query. Regards, B.

$35 USD in 1 day

4.9

(25 reviews)

5.4

@rohitmittal18

Hello Friend, I am a Magento2 Certified Associate Developer and looking for long term clients. I can write the mysql query for you, let me know if I can help you in any way. Thanks.

$25 USD in 3 days

4.9

(33 reviews)

4.9

@adedokunadekola

kolltechict is the best company that can do this for you

$25 USD in 1 day

4.9

(4 reviews)

2.9

@techweblabs

Hi there. Ping me. Let me help you with the type of query you need for magento 1.9 I need to ask you few details. Thanks, Guru

$23 USD in 0 day

2.7

(17 reviews)

5.2

@Webintuit

Dear Client, Good Day Please open PMB for further discussion so that we can help you to resolve the concern. Thanks

$25 USD in 1 day

4.1

(3 reviews)

2.4

@berceanbogdan

I have experience with both SQL (MySQL, SQLServer) and noSQL (OrientDB, Cassandra) databases. One of the project I worked in the past, involved a data lake, in which we also used a dockerized MySQL in multi-master mode. I am new to freelancing and I would be glad to take on this project for a minimum amount of money only to strengthen my portfolio.

$10 USD in 1 day