Picfair Plus free trial

Breakdown

Your images

x
  • Images (inc VAT) £0.00
  • Fees £0.00
  • Total £0.00
  • (Including £0.00 in VAT)

Bill breakdown

  • Images (ex VAT) £0.00
  • VAT on images £0.00
  • Picfair commission (ex VAT) £0.00
  • VAT on Picfair commission £0.00
  • Subtotal £0.00
  • Total £0.00
  • (Including £0.00 in VAT)

Click here to hide cart!

Commercial Licence
Editorial, Social Media, Marketing

All Editorial & Personal Uses

  • Single use
  • Personal use
  • Editorial: Print, online, broadcast
  • In-house business editorial
  • Corresponding online/offline content trails & social media
  • Any placement
  • Any size & DPI
  • Unlimited Distribution
  • No licence expiration

Marketing

  • Single use or campaign
  • Advertorial, promoted & "sponsored by" content
  • Newsletters & email marketing
  • Website backgrounds & collateral
  • Social media
  • Social media advertising & promoted posts
  • Brochures & leaflets
  • All promotional materials
  • Unlimited sizes, distribution, placement, perpetuity
  • One time licence transfer

Advertising & Merchandising

View full licence

Editorial & Personal Licence
Editorial & personal use

All Editorial & Personal Uses

  • Single use
  • Personal use
  • Editorial: Print, online, broadcast
  • In-house business editorial
  • Corresponding online/offline content trails & social media
  • Any placement
  • Any size & DPI
  • Unlimited Distribution
  • No licence expiration

Marketing

Advertising & Merchandising

View full licence

Advertising Licence
Advertising & merchandising

All editorial & personal uses

Marketing

Advertising & Merchandising

  • Single use or single campaign
  • Print advertising
  • Out-of-home advertising
  • Broadcast advertising
  • Display advertising
  • Multi-channel advertising
  • Merchandising
  • Retail product packaging
  • One time licence transfer
View full licence
Categories [] /  Distribution Upload Viewing Category

Distribution Upload Viewing Category

Steps:

1) Run this query:

-- Monthly Upload via Distributed-Pics table w/ pics.state = live (after uploading) select CONCAT('id:', distributedpics.picid, ' OR '), distributedpics.state, pics.state, distributedpics.incurrentstatesince from distributedpics join pics on pics.id = distributedpics.picid where distributionid = [insert distribution number] and distributedpics.state = 'live' and distributedpics.incurrentstatesince > [insert date new pics were uploaded] ;

2) Copy the result in the 'concat' column

3) Paste the result below within the last set of brackets.

The full category query should read:

!!!ADVANCED!!! (state:complete) AND suspended:false AND ( result of the 'concat' column from sql query above )

N.B. Remember to remove the final 'OR' after pasting the result.

4) Update category and open the category to view pics

×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"Photography can be fruitful" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"Boiling Sunrise Over Clacton Windfarm" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"Golden Hour Clacton Beach Huts" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"Frinton Beach Sunrise" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"Butterfly Colour" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£6.20

Advertising

Advertising

£62.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"A Mexican trio going up a spiral staircase to play music" stock image
£6.20
×

DIGITAL DOWNLOAD

Commercial

Commercial

£9.92

Advertising

Advertising

£99.20

PRINTED PRODUCTS

Prints

Prints

SELECT
"A jockey on horse back on a race track in mexico city" stock image
£9.92
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"Finger Licking Good" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
×

DIGITAL DOWNLOAD

Commercial

Commercial

£1.36

Advertising

Advertising

£13.60

PRINTED PRODUCTS

Prints

Prints

SELECT
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
×

DIGITAL DOWNLOAD

Editorial

Editorial

£9.92

PRINTED PRODUCTS

Prints

Prints

SELECT
×

DIGITAL DOWNLOAD

Editorial

Editorial

£11.16

PRINTED PRODUCTS

Prints

Prints

SELECT
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

PRINTED PRODUCTS

Prints

Prints

SELECT
"Pony Portrait" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£3.72

PRINTED PRODUCTS

Prints

Prints

SELECT
"East Kirkby Night Shoot" stock image
£3.72
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

PRINTED PRODUCTS

Prints

Prints

SELECT
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"Mad Goose" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£8.68

PRINTED PRODUCTS

Prints

Prints

SELECT
"Bivouac in front of the Tre Cime" stock image
£8.68
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

PRINTED PRODUCTS

Prints

Prints

SELECT
"Lago di Sorapis - Dolomite" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"Landermere Quay a June Sunset" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"Rainbow Over Beaumont Quay" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"Landermere Quay Double Sunset 2017" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"Small Yacht Big Skies Off Frinton Beach" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"Sunset Through Glass" stock image
£12.40
×

DIGITAL DOWNLOAD

Commercial

Commercial

£12.40

Advertising

Advertising

£124.00

PRINTED PRODUCTS

Prints

Prints

SELECT
"Fire Sky Over Frinton On Sea" stock image
£12.40
Categories [] /  Distribution Upload Viewing Category

Distribution Upload Viewing Category

Steps:

1) Run this query:

-- Monthly Upload via Distributed-Pics table w/ pics.state = live (after uploading) select CONCAT('id:', distributedpics.picid, ' OR '), distributedpics.state, pics.state, distributedpics.incurrentstatesince from distributedpics join pics on pics.id = distributedpics.picid where distributionid = [insert distribution number] and distributedpics.state = 'live' and distributedpics.incurrentstatesince > [insert date new pics were uploaded] ;

2) Copy the result in the 'concat' column

3) Paste the result below within the last set of brackets.

The full category query should read:

!!!ADVANCED!!! (state:complete) AND suspended:false AND ( result of the 'concat' column from sql query above )

N.B. Remember to remove the final 'OR' after pasting the result.

4) Update category and open the category to view pics