加國公民入籍新規5年住3年已三讀通過,2017年10月11日實施

  
參議院2017年5月3日通過C-6號法案(BILL C-6),修改了部分現行的公民入籍的規定,簡略如下:

  • 減少永久居民入籍所需居加時間,由原本6年內住滿4年,縮短為5年內住滿3年即可;
  • 以非永久居民身分(如工作或學習許可證)在加時間,每2天可併計算一天(最多一年)在加居住時間3年期間內。
  • 語言測試由原現行18至65歲,修改為18至55歲都需要測試。
select p.products_image, pd.products_name, p.products_id, p.products_image,p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price,pd.products_description from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '286' order by p.sort_order, pd.products_name
1054 - Unknown column 'p.products_id' in 'on clause'

select p.products_image, pd.products_name, p.products_id, p.products_image,p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price,pd.products_description from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '286' order by p.sort_order, pd.products_name

[STEP STOP]