Last SQL-Query: SELECT SQL_CALC_FOUND_ROWS hH3672yj6z_posts.ID
FROM hH3672yj6z_posts JOIN hH3672yj6z_icl_translations wpml_translations
ON hH3672yj6z_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT(‘post_’, hH3672yj6z_posts.post_type)
WHERE 1=1 AND hH3672yj6z_posts.post_type = ‘resources’ AND ((hH3672yj6z_posts.post_status = ‘publish’)) AND ( ( ( wpml_translations.language_code = ‘en’ OR (
wpml_translations.language_code = ‘en’
AND hH3672yj6z_posts.post_type IN ( ‘resources’ )
AND ( (
( SELECT COUNT(element_id)
FROM hH3672yj6z_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = ‘en’
) = 0
) OR (
( SELECT COUNT(element_id)
FROM hH3672yj6z_icl_translations t2
JOIN hH3672yj6z_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = ‘en’
AND (
p.post_status = ‘publish’ OR p.post_status = ‘private’ OR
( p.post_type=’attachment’ AND p.post_status = ‘inherit’ )
)
) = 0 ) )
) ) AND hH3672yj6z_posts.post_type IN (‘post’,’page’,’attachment’,’wp_block’,’wp_template’,’wp_template_part’,’wp_navigation’,’wpcf7_contact_form’,’resources’ ) ) OR hH3672yj6z_posts.post_type NOT IN (‘post’,’page’,’attachment’,’wp_block’,’wp_template’,’wp_template_part’,’wp_navigation’,’wpcf7_contact_form’,’resources’ ) )
ORDER BY hH3672yj6z_posts.post_date DESC
LIMIT 60, 6
09-03-2021
Simon
Purpose of note The purpose of this note is to remind European nationals (and their employers) that they need to apply for UK ‘Pre Settled Status’ by 30 June 21. If they don’t, they will need to follow the points-based immigration rules, which will make it much more difficult for them to work in the […]
Find out more
07-03-2021
Simon
Purpose of note « Reclaiming VAT for overseas businesses » This note explains how an overseas business that is not allowed to register for UK VAT can still reclaim import and other UK VAT. This situation often applies to overseas companies active in UK construction projects. I have written it in response to a number of questions […]
Find out more
07-03-2021
Simon
Purpose of note Some of our clients have asked us to explain the difference between a Proforma and a Commercial Invoice. This note describes the differences, explains when each should be used and what information each should contain. Since most of our clients are overseas businesses that do business in the UK, I have written […]
Find out more
04-03-2021
Simon
Aim of note The aim of this note is to summarise some of the policies announced in yesterday’s budget. I have selected the points that are most likely to be relevant to our clients. The list is not meant to be comprehensive. You can see a summary of the points here and the full budget […]
Find out more
18-02-2021
Simon
Overview HMRC recently provided an update of their VAT deferral scheme. This note summarises HMRC’s guidance, You can read the guidance in full here. The VAT deferral scheme Basically, if you deferred VAT payments at the start of COVID (between 20 March and 30 June 2020) and you still have payments to make, you can […]
Find out more
14-02-2021
Simon
Overview From 1st January 2021 (post Brexit) new rules apply for accounting for import and export VAT. This has made recording imports and exports on Xero quite a lot harder. This note explains some of the new rules and how to record import and export transactions in Xero. You can see a similar note for […]
Find out more