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 66, 6
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 QuickBooks quite a lot harder. This note explains some of the new rules and how to record import and export transactions in QuickBooks. You can see a similar note for […]
Find out more
12-02-2021
Simon
Overview The aim of this note is to provide an overview of some of the rules that came into effect from 1 January 2021 . The new rules place significant restrictions on the ability of EU directors of UK companies to perform directorial duties in the UK. In reading this note it is important to understand that […]
Find out more
12-02-2021
Simon
Overview – Post Brexit Working in the UK A new immigration system was introduced on 1 January 2021. This applies to people that want to work in the UK. It will apply if they come to the UK from either Europe or outside of Europe. So, for the first time in many years EU citizens […]
Find out more
04-12-2020
Simon
Overview The aim of this note is to explain some of the new VAT rules that overseas sellers will need to follow after Brexit. In this context an overseas seller is a business that is established outside of the UK and doesn’t have an establishment within the UK. The changes are reasonably complex because there are […]
Find out more
02-12-2020
Simon
Overview The aim of the offshore funds rules is to make sure that income earned by the fund is taxed as income, ideally in the year the income is earned. If it wasn’t for these rules the investor would not pay tax on income retained or reinvested by the fund but would instead pay capital […]
Find out more
02-12-2020
Simon
Overview Europeans that already live in the UK can continue to live and work in the UK after 1 January 2021. However, they will need to apply for ‘Settled Status’ or ‘Pre-Settled Status’ by 30 June 2021. Lived in the UK for more than 5 years – apply for ‘Settled Status’ EU citizens who have lived […]
Find out more