商品列表

1105 - File './mallmaster/lizicanon_products_description.MYD' not found (Errcode: 24) select count(p.products_id) as total from 21ctapec_products p, 21ctapec_products_description pd, 21ctapec_manufacturers m left join 21ctapec_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from 28081601_products p, 28081601_products_description pd, 28081601_manufacturers m left join 28081601_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from 28081601a_products p, 28081601a_products_description pd, 28081601a_manufacturers m left join 28081601a_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from 3coins_products p, 3coins_products_description pd, 3coins_manufacturers m left join 3coins_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from 3g_products p, 3g_products_description pd, 3g_manufacturers m left join 3g_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from akuma_products p, akuma_products_description pd, akuma_manufacturers m left join akuma_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from amimdepot_products p, amimdepot_products_description pd, amimdepot_manufacturers m left join amimdepot_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from anniecake_products p, anniecake_products_description pd, anniecake_manufacturers m left join anniecake_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from appccd_products p, appccd_products_description pd, appccd_manufacturers m left join appccd_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from appccdv2_products p, appccdv2_products_description pd, appccdv2_manufacturers m left join appccdv2_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from binbin_products p, binbin_products_description pd, binbin_manufacturers m left join binbin_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from blessings_products p, blessings_products_description pd, blessings_manufacturers m left join blessings_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from broadway_products p, broadway_products_description pd, broadway_manufacturers m left join broadway_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from caffeyang_products p, caffeyang_products_description pd, caffeyang_manufacturers m left join caffeyang_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from caffeyangv2_products p, caffeyangv2_products_description pd, caffeyangv2_manufacturers m left join caffeyangv2_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from camay_products p, camay_products_description pd, camay_manufacturers m left join camay_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from carolcafe_products p, carolcafe_products_description pd, carolcafe_manufacturers m left join carolcafe_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from cbprint_products p, cbprint_products_description pd, cbprint_manufacturers m left join cbprint_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from cdimotor_products p, cdimotor_products_description pd, cdimotor_manufacturers m left join cdimotor_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from cdir_products p, cdir_products_description pd, cdir_manufacturers m left join cdir_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from changpad_products p, changpad_products_description pd, changpad_manufacturers m left join changpad_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from charming_products p, charming_products_description pd, charming_manufacturers m left join charming_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from chenglauda_products p, chenglauda_products_description pd, chenglauda_manufacturers m left join chenglauda_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from chiahungagency_products p, chiahungagency_products_description pd, chiahungagency_manufacturers m left join chiahungagency_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from chinphone_products p, chinphone_products_description pd, chinphone_manufacturers m left join chinphone_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from chitek_products p, chitek_products_description pd, chitek_manufacturers m left join chitek_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from chitekv2_products p, chitekv2_products_description pd, chitekv2_manufacturers m left join chitekv2_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from chteech_products p, chteech_products_description pd, chteech_manufacturers m left join chteech_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from chungta_products p, chungta_products_description pd, chungta_manufacturers m left join chungta_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from chyfood_products p, chyfood_products_description pd, chyfood_manufacturers m left join chyfood_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from cjhome_products p, cjhome_products_description pd, cjhome_manufacturers m left join cjhome_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from clfood1_products p, clfood1_products_description pd, clfood1_manufacturers m left join clfood1_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from clfood_products p, clfood_products_description pd, clfood_manufacturers m left join clfood_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from cloudy_products p, cloudy_products_description pd, cloudy_manufacturers m left join cloudy_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from cmb_products p, cmb_products_description pd, cmb_manufacturers m left join cmb_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from cmccar_products p, cmccar_products_description pd, cmccar_manufacturers m left join cmccar_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from comeandbuy_products p, comeandbuy_products_description pd, comeandbuy_manufacturers m left join comeandbuy_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from coolstone_products p, coolstone_products_description pd, coolstone_manufacturers m left join coolstone_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from cpen_products p, cpen_products_description pd, cpen_manufacturers m left join cpen_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from csfamily_products p, csfamily_products_description pd, csfamily_manufacturers m left join csfamily_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from csscrew_products p, csscrew_products_description pd, csscrew_manufacturers m left join csscrew_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from ctapec_products p, ctapec_products_description pd, ctapec_manufacturers m left join ctapec_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from ctjewel_products p, ctjewel_products_description pd, ctjewel_manufacturers m left join ctjewel_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from cyba_products p, cyba_products_description pd, cyba_manufacturers m left join cyba_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from cycafe_products p, cycafe_products_description pd, cycafe_manufacturers m left join cycafe_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from cylight_products p, cylight_products_description pd, cylight_manufacturers m left join cylight_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from dachia_products p, dachia_products_description pd, dachia_manufacturers m left join dachia_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from danni_products p, danni_products_description pd, danni_manufacturers m left join danni_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from daytea_products p, daytea_products_description pd, daytea_manufacturers m left join daytea_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from ddbeauty_products p, ddbeauty_products_description pd, ddbeauty_manufacturers m left join ddbeauty_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from ddfood_products p, ddfood_products_description pd, ddfood_manufacturers m left join ddfood_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from derlexbtc_products p, derlexbtc_products_description pd, derlexbtc_manufacturers m left join derlexbtc_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from didabeauty_products p, didabeauty_products_description pd, didabeauty_manufacturers m left join didabeauty_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from digibear_products p, digibear_products_description pd, digibear_manufacturers m left join digibear_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from dlcake_products p, dlcake_products_description pd, dlcake_manufacturers m left join dlcake_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from donher_products p, donher_products_description pd, donher_manufacturers m left join donher_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from dupe_products p, dupe_products_description pd, dupe_manufacturers m left join dupe_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from dyb_products p, dyb_products_description pd, dyb_manufacturers m left join dyb_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from easysael_products p, easysael_products_description pd, easysael_manufacturers m left join easysael_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from eesmc_products p, eesmc_products_description pd, eesmc_manufacturers m left join eesmc_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from eratech_products p, eratech_products_description pd, eratech_manufacturers m left join eratech_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from farmgo_products p, farmgo_products_description pd, farmgo_manufacturers m left join farmgo_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from femalebeauty_products p, femalebeauty_products_description pd, femalebeauty_manufacturers m left join femalebeauty_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from flltd_products p, flltd_products_description pd, flltd_manufacturers m left join flltd_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from flysound101_products p, flysound101_products_description pd, flysound101_manufacturers m left join flysound101_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from fmseafood_products p, fmseafood_products_description pd, fmseafood_manufacturers m left join fmseafood_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from food_products p, food_products_description pd, food_manufacturers m left join food_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from forcecity_products p, forcecity_products_description pd, forcecity_manufacturers m left join forcecity_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from fotomi_products p, fotomi_products_description pd, fotomi_manufacturers m left join fotomi_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from foxeyecam_products p, foxeyecam_products_description pd, foxeyecam_manufacturers m left join foxeyecam_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from fruittw_products p, fruittw_products_description pd, fruittw_manufacturers m left join fruittw_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from fsm_products p, fsm_products_description pd, fsm_manufacturers m left join fsm_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from fwanl_products p, fwanl_products_description pd, fwanl_manufacturers m left join fwanl_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from fwling_products p, fwling_products_description pd, fwling_manufacturers m left join fwling_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from genkiyaki_products p, genkiyaki_products_description pd, genkiyaki_manufacturers m left join genkiyaki_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from getea_products p, getea_products_description pd, getea_manufacturers m left join getea_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from geteav2_products p, geteav2_products_description pd, geteav2_manufacturers m left join geteav2_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from gffood_products p, gffood_products_description pd, gffood_manufacturers m left join gffood_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from ghfruit_products p, ghfruit_products_description pd, ghfruit_manufacturers m left join ghfruit_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from ghtape_products p, ghtape_products_description pd, ghtape_manufacturers m left join ghtape_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from gingfuji_products p, gingfuji_products_description pd, gingfuji_manufacturers m left join gingfuji_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from gingtest_products p, gingtest_products_description pd, gingtest_manufacturers m left join gingtest_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from gocars_products p, gocars_products_description pd, gocars_manufacturers m left join gocars_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from goldfast_products p, goldfast_products_description pd, goldfast_manufacturers m left join goldfast_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from golermall_products p, golermall_products_description pd, golermall_manufacturers m left join golermall_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from goodair_products p, goodair_products_description pd, goodair_manufacturers m left join goodair_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from goodde_products p, goodde_products_description pd, goodde_manufacturers m left join goodde_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from goodimage_products p, goodimage_products_description pd, goodimage_manufacturers m left join goodimage_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from greendesign_products p, greendesign_products_description pd, greendesign_manufacturers m left join greendesign_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from greenforest_products p, greenforest_products_description pd, greenforest_manufacturers m left join greenforest_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from gstep_products p, gstep_products_description pd, gstep_manufacturers m left join gstep_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from hangerhouse_products p, hangerhouse_products_description pd, hangerhouse_manufacturers m left join hangerhouse_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from hanliang_products p, hanliang_products_description pd, hanliang_manufacturers m left join hanliang_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from hanlin118_products p, hanlin118_products_description pd, hanlin118_manufacturers m left join hanlin118_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from hanlin118v2_products p, hanlin118v2_products_description pd, hanlin118v2_manufacturers m left join hanlin118v2_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from hanlinv3_products p, hanlinv3_products_description pd, hanlinv3_manufacturers m left join hanlinv3_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from happytaipei_products p, happytaipei_products_description pd, happytaipei_manufacturers m left join happytaipei_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from hbtape_products p, hbtape_products_description pd, hbtape_manufacturers m left join hbtape_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from healthysleep_products p, healthysleep_products_description pd, healthysleep_manufacturers m left join healthysleep_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from hgreal_products p, hgreal_products_description pd, hgreal_manufacturers m left join hgreal_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from hibeautylife_products p, hibeautylife_products_description pd, hibeautylife_manufacturers m left join hibeautylife_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from hltour_products p, hltour_products_description pd, hltour_manufacturers m left join hltour_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from holsun_products p, holsun_products_description pd, holsun_manufacturers m left join holsun_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from hongsam_products p, hongsam_products_description pd, hongsam_manufacturers m left join hongsam_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from horitakiispa_products p, horitakiispa_products_description pd, horitakiispa_manufacturers m left join horitakiispa_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from hscake_products p, hscake_products_description pd, hscake_manufacturers m left join hscake_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from htfood_products p, htfood_products_description pd, htfood_manufacturers m left join htfood_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from htpaper_products p, htpaper_products_description pd, htpaper_manufacturers m left join htpaper_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from htpaperv2_products p, htpaperv2_products_description pd, htpaperv2_manufacturers m left join htpaperv2_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from huangting_products p, huangting_products_description pd, huangting_manufacturers m left join huangting_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from iwant99_products p, iwant99_products_description pd, iwant99_manufacturers m left join iwant99_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from jagtec_products p, jagtec_products_description pd, jagtec_manufacturers m left join jagtec_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from janewai_products p, janewai_products_description pd, janewai_manufacturers m left join janewai_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from jjdc_products p, jjdc_products_description pd, jjdc_manufacturers m left join jjdc_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from joylanddance_products p, joylanddance_products_description pd, joylanddance_manufacturers m left join joylanddance_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from jprint_products p, jprint_products_description pd, jprint_manufacturers m left join jprint_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from jqk_products p, jqk_products_description pd, jqk_manufacturers m left join jqk_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from jshinprint_products p, jshinprint_products_description pd, jshinprint_manufacturers m left join jshinprint_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from jtape_products p, jtape_products_description pd, jtape_manufacturers m left join jtape_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from jtapev2_products p, jtapev2_products_description pd, jtapev2_manufacturers m left join jtapev2_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from karamel_products p, karamel_products_description pd, karamel_manufacturers m left join karamel_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from keydex_products p, keydex_products_description pd, keydex_manufacturers m left join keydex_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from kingfood_products p, kingfood_products_description pd, kingfood_manufacturers m left join kingfood_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from kingyaa_products p, kingyaa_products_description pd, kingyaa_manufacturers m left join kingyaa_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from klcake_products p, klcake_products_description pd, klcake_manufacturers m left join klcake_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from klfashop_products p, klfashop_products_description pd, klfashop_manufacturers m left join klfashop_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from kspec_products p, kspec_products_description pd, kspec_manufacturers m left join kspec_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from kuoli1993_products p, kuoli1993_products_description pd, kuoli1993_manufacturers m left join kuoli1993_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from kuoli1993v2_products p, kuoli1993v2_products_description pd, kuoli1993v2_manufacturers m left join kuoli1993v2_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from kuopen_products p, kuopen_products_description pd, kuopen_manufacturers m left join kuopen_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from labau_products p, labau_products_description pd, labau_manufacturers m left join labau_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from lamb_products p, lamb_products_description pd, lamb_manufacturers m left join lamb_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from lanchen_products p, lanchen_products_description pd, lanchen_manufacturers m left join lanchen_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from lanticmall_products p, lanticmall_products_description pd, lanticmall_manufacturers m left join lanticmall_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from lantis_products p, lantis_products_description pd, lantis_manufacturers m left join lantis_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from lcwood_products p, lcwood_products_description pd, lcwood_manufacturers m left join lcwood_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from lfc1987_products p, lfc1987_products_description pd, lfc1987_manufacturers m left join lfc1987_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from lightprint_products p, lightprint_products_description pd, lightprint_manufacturers m left join lightprint_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from linjiunn_products p, linjiunn_products_description pd, linjiunn_manufacturers m left join linjiunn_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from liuchiufood_products p, liuchiufood_products_description pd, liuchiufood_manufacturers m left join liuchiufood_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from lizicanon_products p, lizicanon_products_description pd, lizicanon_manufacturers m left join lizicanon_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from lntec_products p, lntec_products_description pd, lntec_manufacturers m left join lntec_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from longtea_products p, longtea_products_description pd, longtea_manufacturers m left join longtea_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from loveking_products p, loveking_products_description pd, loveking_manufacturers m left join loveking_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from lsytest21_products p, lsytest21_products_description pd, lsytest21_manufacturers m left join lsytest21_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from lsytest2_1_products p, lsytest2_1_products_description pd, lsytest2_1_manufacturers m left join lsytest2_1_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from lsytest2_products p, lsytest2_products_description pd, lsytest2_manufacturers m left join lsytest2_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from lsytest_products p, lsytest_products_description pd, lsytest_manufacturers m left join lsytest_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from luster_products p, luster_products_description pd, luster_manufacturers m left join luster_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from mak_products p, mak_products_description pd, mak_manufacturers m left join mak_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from mame_products p, mame_products_description pd, mame_manufacturers m left join mame_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from massage_products p, massage_products_description pd, massage_manufacturers m left join massage_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from mbio_products p, mbio_products_description pd, mbio_manufacturers m left join mbio_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from mcloth_products p, mcloth_products_description pd, mcloth_manufacturers m left join mcloth_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from mdrt_products p, mdrt_products_description pd, mdrt_manufacturers m left join mdrt_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from meroled_products p, meroled_products_description pd, meroled_manufacturers m left join meroled_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from mimking_products p, mimking_products_description pd, mimking_manufacturers m left join mimking_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from miracletourclub_products p, miracletourclub_products_description pd, miracletourclub_manufacturers m left join miracletourclub_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from mjbag_products p, mjbag_products_description pd, mjbag_manufacturers m left join mjbag_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from mkpos_products p, mkpos_products_description pd, mkpos_manufacturers m left join mkpos_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from mlstep_products p, mlstep_products_description pd, mlstep_manufacturers m left join mlstep_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from mtoskincare_products p, mtoskincare_products_description pd, mtoskincare_manufacturers m left join mtoskincare_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from nanlingnoodle_products p, nanlingnoodle_products_description pd, nanlingnoodle_manufacturers m left join nanlingnoodle_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from newloulan_products p, newloulan_products_description pd, newloulan_manufacturers m left join newloulan_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from nhouse_products p, nhouse_products_description pd, nhouse_manufacturers m left join nhouse_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from niceplus_products p, niceplus_products_description pd, niceplus_manufacturers m left join niceplus_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from no26_products p, no26_products_description pd, no26_manufacturers m left join no26_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from orchardqueen_products p, orchardqueen_products_description pd, orchardqueen_manufacturers m left join orchardqueen_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from oxyspa_products p, oxyspa_products_description pd, oxyspa_manufacturers m left join oxyspa_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from palis_products p, palis_products_description pd, palis_manufacturers m left join palis_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from peacediving_products p, peacediving_products_description pd, peacediving_manufacturers m left join peacediving_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from phott_products p, phott_products_description pd, phott_manufacturers m left join phott_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from plh_products p, plh_products_description pd, plh_manufacturers m left join plh_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from r3_products p, r3_products_description pd, r3_manufacturers m left join r3_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from renher_products p, renher_products_description pd, renher_manufacturers m left join renher_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from rlentco_products p, rlentco_products_description pd, rlentco_manufacturers m left join rlentco_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from safehouse_products p, safehouse_products_description pd, safehouse_manufacturers m left join safehouse_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from samplem3_products p, samplem3_products_description pd, samplem3_manufacturers m left join samplem3_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from samplemall_products p, samplemall_products_description pd, samplemall_manufacturers m left join samplemall_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from sankansoubo_products p, sankansoubo_products_description pd, sankansoubo_manufacturers m left join sankansoubo_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from sanshen_products p, sanshen_products_description pd, sanshen_manufacturers m left join sanshen_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from sanyuedo_products p, sanyuedo_products_description pd, sanyuedo_manufacturers m left join sanyuedo_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from sbgift_products p, sbgift_products_description pd, sbgift_manufacturers m left join sbgift_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from sccup_products p, sccup_products_description pd, sccup_manufacturers m left join sccup_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from sfruit_products p, sfruit_products_description pd, sfruit_manufacturers m left join sfruit_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from shennongbt_products p, shennongbt_products_description pd, shennongbt_manufacturers m left join shennongbt_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from shfarm_products p, shfarm_products_description pd, shfarm_manufacturers m left join shfarm_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from shingchong_products p, shingchong_products_description pd, shingchong_manufacturers m left join shingchong_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from skllaser_products p, skllaser_products_description pd, skllaser_manufacturers m left join skllaser_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from skltec_products p, skltec_products_description pd, skltec_manufacturers m left join skltec_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from slhome_products p, slhome_products_description pd, slhome_manufacturers m left join slhome_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from sloils_products p, sloils_products_description pd, sloils_manufacturers m left join sloils_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from smotorbike_products p, smotorbike_products_description pd, smotorbike_manufacturers m left join smotorbike_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from soybean_products p, soybean_products_description pd, soybean_manufacturers m left join soybean_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from springtea_products p, springtea_products_description pd, springtea_manufacturers m left join springtea_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from stape_products p, stape_products_description pd, stape_manufacturers m left join stape_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from stnews_products p, stnews_products_description pd, stnews_manufacturers m left join stnews_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from sunelite_products p, sunelite_products_description pd, sunelite_manufacturers m left join sunelite_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from sunetea_products p, sunetea_products_description pd, sunetea_manufacturers m left join sunetea_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from sweetasty_products p, sweetasty_products_description pd, sweetasty_manufacturers m left join sweetasty_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from swen_products p, swen_products_description pd, swen_manufacturers m left join swen_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from swords_products p, swords_products_description pd, swords_manufacturers m left join swords_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from syekdo_products p, syekdo_products_description pd, syekdo_manufacturers m left join syekdo_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from syhome_products p, syhome_products_description pd, syhome_manufacturers m left join syhome_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from symlong_products p, symlong_products_description pd, symlong_manufacturers m left join symlong_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from tai888_products p, tai888_products_description pd, tai888_manufacturers m left join tai888_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from taipeiimplant_products p, taipeiimplant_products_description pd, taipeiimplant_manufacturers m left join taipeiimplant_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from taipuu_products p, taipuu_products_description pd, taipuu_manufacturers m left join taipuu_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from talakuya_products p, talakuya_products_description pd, talakuya_manufacturers m left join talakuya_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from tamataiwan_products p, tamataiwan_products_description pd, tamataiwan_manufacturers m left join tamataiwan_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from tastegood_products p, tastegood_products_description pd, tastegood_manufacturers m left join tastegood_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from test_products p, test_products_description pd, test_manufacturers m left join test_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from teyuo_products p, teyuo_products_description pd, teyuo_manufacturers m left join teyuo_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from tientaihou_products p, tientaihou_products_description pd, tientaihou_manufacturers m left join tientaihou_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from tomworks_products p, tomworks_products_description pd, tomworks_manufacturers m left join tomworks_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from toykingdom_products p, toykingdom_products_description pd, toykingdom_manufacturers m left join toykingdom_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from tpmassage_products p, tpmassage_products_description pd, tpmassage_manufacturers m left join tpmassage_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from tptea_products p, tptea_products_description pd, tptea_manufacturers m left join tptea_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from treehome_products p, treehome_products_description pd, treehome_manufacturers m left join treehome_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from tsbobbin_products p, tsbobbin_products_description pd, tsbobbin_manufacturers m left join tsbobbin_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from tserfo_products p, tserfo_products_description pd, tserfo_manufacturers m left join tserfo_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from tserfov2_products p, tserfov2_products_description pd, tserfov2_manufacturers m left join tserfov2_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from twfarmer_products p, twfarmer_products_description pd, twfarmer_manufacturers m left join twfarmer_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from twgoods_products p, twgoods_products_description pd, twgoods_manufacturers m left join twgoods_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from tylight_products p, tylight_products_description pd, tylight_manufacturers m left join tylight_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from udcar_products p, udcar_products_description pd, udcar_manufacturers m left join udcar_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from upps_products p, upps_products_description pd, upps_manufacturers m left join upps_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from uutape_products p, uutape_products_description pd, uutape_manufacturers m left join uutape_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from vansona_products p, vansona_products_description pd, vansona_manufacturers m left join vansona_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from vf_products p, vf_products_description pd, vf_manufacturers m left join vf_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from vghouse_products p, vghouse_products_description pd, vghouse_manufacturers m left join vghouse_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from vitorye_products p, vitorye_products_description pd, vitorye_manufacturers m left join vitorye_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from wagor88888_products p, wagor88888_products_description pd, wagor88888_manufacturers m left join wagor88888_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from wanho_products p, wanho_products_description pd, wanho_manufacturers m left join wanho_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from wca_products p, wca_products_description pd, wca_manufacturers m left join wca_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from whinject_products p, whinject_products_description pd, whinject_manufacturers m left join whinject_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from winny_products p, winny_products_description pd, winny_manufacturers m left join winny_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from wmg2_products p, wmg2_products_description pd, wmg2_manufacturers m left join wmg2_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from woff_products p, woff_products_description pd, woff_manufacturers m left join woff_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from woodart_products p, woodart_products_description pd, woodart_manufacturers m left join woodart_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from workingkingdom_products p, workingkingdom_products_description pd, workingkingdom_manufacturers m left join workingkingdom_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from wstech_products p, wstech_products_description pd, wstech_manufacturers m left join wstech_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from wyad_products p, wyad_products_description pd, wyad_manufacturers m left join wyad_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from xdpm_products p, xdpm_products_description pd, xdpm_manufacturers m left join xdpm_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from ycbest_products p, ycbest_products_description pd, ycbest_manufacturers m left join ycbest_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from yelin_products p, yelin_products_description pd, yelin_manufacturers m left join yelin_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from yf_products p, yf_products_description pd, yf_manufacturers m left join yf_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from yixinplastic_products p, yixinplastic_products_description pd, yixinplastic_manufacturers m left join yixinplastic_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from yjtape_products p, yjtape_products_description pd, yjtape_manufacturers m left join yjtape_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from yltextile_products p, yltextile_products_description pd, yltextile_manufacturers m left join yltextile_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from ynbio_products p, ynbio_products_description pd, ynbio_manufacturers m left join ynbio_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from yourfood_products p, yourfood_products_description pd, yourfood_manufacturers m left join yourfood_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from yuhaoglass_products p, yuhaoglass_products_description pd, yuhaoglass_manufacturers m left join yuhaoglass_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from yungkai_products p, yungkai_products_description pd, yungkai_manufacturers m left join yungkai_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from yuwatech_products p, yuwatech_products_description pd, yuwatech_manufacturers m left join yuwatech_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from ywl_products p, ywl_products_description pd, ywl_manufacturers m left join ywl_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from yygo_products p, yygo_products_description pd, yygo_manufacturers m left join yygo_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from yyhome_products p, yyhome_products_description pd, yyhome_manufacturers m left join yyhome_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from zhenzhou_products p, zhenzhou_products_description pd, zhenzhou_manufacturers m left join zhenzhou_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from zhutian_products p, zhutian_products_description pd, zhutian_manufacturers m left join zhutian_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' UNION ALL select count(p.products_id) as total from zuminol_products p, zuminol_products_description pd, zuminol_manufacturers m left join zuminol_specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '6' and p.products_model like '%自然美專區%' [TEP STOP]