WordPress database error: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
SELECT www1_posts.ID FROM www1_posts LEFT JOIN www1_postmeta ON ( www1_posts.ID = www1_postmeta.post_id ) LEFT JOIN www1_postmeta AS mt1 ON (www1_posts.ID = mt1.post_id AND mt1.meta_key = 'images_order' ) LEFT JOIN www1_postmeta AS mt2 ON ( www1_posts.ID = mt2.post_id ) LEFT JOIN www1_postmeta AS mt3 ON (www1_posts.ID = mt3.post_id AND mt3.meta_key = 'is_cover' ) LEFT JOIN www1_postmeta AS mt4 ON ( www1_posts.ID = mt4.post_id ) LEFT JOIN www1_postmeta AS mt5 ON (www1_posts.ID = mt5.post_id AND mt5.meta_key = 'is_portfolio' ) WHERE 1=1 AND www1_posts.post_parent = 3189 AND (www1_posts.post_mime_type LIKE 'image/%') AND ( ( www1_postmeta.meta_key = 'images_order' OR mt1.post_id IS NULL ) AND ( ( mt2.meta_key = 'is_cover' AND mt2.meta_value != '1' ) OR mt3.post_id IS NULL ) AND ( ( mt4.meta_key = 'is_portfolio' AND mt4.meta_value != '1' ) OR mt5.post_id IS NULL ) ) AND www1_posts.post_type = 'attachment' AND ((www1_posts.post_status = 'inherit')) GROUP BY www1_posts.ID ORDER BY www1_postmeta.meta_value+0 ASC, www1_posts.post_date ASC LIMIT 0, 1

Casual sia

Door Supervisor
  • Not rated yet

WordPress database error: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
SELECT www1_posts.ID FROM www1_posts LEFT JOIN www1_postmeta ON ( www1_posts.ID = www1_postmeta.post_id ) LEFT JOIN www1_postmeta AS mt1 ON (www1_posts.ID = mt1.post_id AND mt1.meta_key = 'images_order' ) LEFT JOIN www1_postmeta AS mt2 ON ( www1_posts.ID = mt2.post_id ) LEFT JOIN www1_postmeta AS mt3 ON (www1_posts.ID = mt3.post_id AND mt3.meta_key = 'is_cover' ) LEFT JOIN www1_postmeta AS mt4 ON ( www1_posts.ID = mt4.post_id ) LEFT JOIN www1_postmeta AS mt5 ON (www1_posts.ID = mt5.post_id AND mt5.meta_key = 'is_portfolio' ) WHERE 1=1 AND www1_posts.post_parent = 3189 AND (www1_posts.post_mime_type LIKE 'image/%') AND ( ( www1_postmeta.meta_key = 'images_order' OR mt1.post_id IS NULL ) AND ( ( mt2.meta_key = 'is_cover' AND mt2.meta_value != '1' ) OR mt3.post_id IS NULL ) AND ( ( mt4.meta_key = 'is_portfolio' AND mt4.meta_value != '1' ) OR mt5.post_id IS NULL ) ) AND www1_posts.post_type = 'attachment' AND ((www1_posts.post_status = 'inherit')) GROUP BY www1_posts.ID ORDER BY www1_postmeta.meta_value+0 ASC, www1_posts.post_date ASC LIMIT 0, 10

100% Secure

Job is done or money back

  • You pay only the listed price without any hidden costs.
  • We keep your money until you are happy with the delivered work.
  • The job will be done or your money will be returned.

Job Description

Worked at various stadiums and venues as sia supervisor and response team member doing various roles including search staff deployment pre checks pit team

Map

Additional Details

Age
41
Experience
10 years
Height (Feet)
5ft 10in
SIA License Number
1019696233546122
Information Require From Client
Prefer events festivals and stadiums. Have 4 day contract so just looking for ad hoc work
Transport
Public Transport
Availability
Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday
Your Area
London