IF select count(*) from <@PREFIX@>posts where post_name = '<@SGROUP@>-<@KEY@>'
@@GO@@
INSERT INTO <@PREFIX@>posts
(
  post_author,
  post_date,
  post_date_gmt,
  post_content,
  post_title,
  post_excerpt,
  post_status,
  comment_status,
  ping_status,
  post_password,
  post_name,
  to_ping,
  pinged,
  post_modified,
  post_modified_gmt,
  post_content_filtered,
  post_parent,
  guid,
  menu_order,
  post_type,
  post_mime_type,
  comment_count)
values
(
  1,
  current_timestamp,
  UTC_TIMESTAMP(),
  'stock-<@KEY@>',
  '<@SGROUP@>-<@KEY@>',
  '',
  'inherit',
  'open',
  'closed',
  '',
  '<@SGROUP@>-<@KEY@>',
  '',
  '',
  current_timestamp,
  UTC_TIMESTAMP() ,
 '',
  0,
   concat((select option_value from wptr_options where option_name = 'siteurl') ,'/wp-content/uploads/<@SGROUP@>-<@KEY@>.jpg'),
  0,
  'attachment',
  'image/jpeg',
  0
)
@@GO@@
select count(*) from <@PREFIX@>posts where post_name = '<@SGROUP@>-<@KEY@>'
@@GO@@

delete from <@PREFIX@>postmeta
where  post_id = (select id from <@PREFIX@>posts where post_type = 'attachment' and post_name = '<@SGROUP@>-<@KEY@>'  )
@@GO@@

INSERT INTO <@PREFIX@>postmeta
(post_id ,meta_key, meta_value)
values(
(select id from <@PREFIX@>posts where post_type = 'attachment' and post_name = '<@SGROUP@>-<@KEY@>'  ),
'_wp_attached_file',
'<@SGROUP@>-<@KEY@>.jpg'
)
@@GO@@
INSERT INTO <@PREFIX@>postmeta
(post_id ,meta_key, meta_value)
values(
(select id from <@PREFIX@>posts where post_type = 'attachment' and post_name = '<@SGROUP@>-<@KEY@>'  ),
'_wp_attachment_metadata',
'a:5:{s:5:"width";i:800;s:6:"height";i:715;s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"sizes";a:15:{s:9:"thumbnail";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:150;s:6:"height";i:150;s:9:"mime-type";s:10:"image/jpeg";}s:6:"medium";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:300;s:6:"height";i:268;s:9:"mime-type";s:10:"image/jpeg";}s:12:"medium_large";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:768;s:6:"height";i:686;s:9:"mime-type";s:10:"image/jpeg";}s:21:"et-pb-post-main-image";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:400;s:6:"height";i:250;s:9:"mime-type";s:10:"image/jpeg";}s:31:"et-pb-post-main-image-fullwidth";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:800;s:6:"height";i:675;s:9:"mime-type";s:10:"image/jpeg";}s:21:"et-pb-portfolio-image";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:400;s:6:"height";i:284;s:9:"mime-type";s:10:"image/jpeg";}s:28:"et-pb-portfolio-module-image";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:510;s:6:"height";i:382;s:9:"mime-type";s:10:"image/jpeg";}s:35:"et-pb-gallery-module-image-portrait";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:400;s:6:"height";i:516;s:9:"mime-type";s:10:"image/jpeg";}s:30:"et-pb-image--responsive--phone";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:480;s:6:"height";i:429;s:9:"mime-type";s:10:"image/jpeg";}s:21:"woocommerce_thumbnail";a:5:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:300;s:6:"height";i:300;s:9:"mime-type";s:10:"image/jpeg";s:9:"uncropped";b:0;}s:18:"woocommerce_single";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:600;s:6:"height";i:536;s:9:"mime-type";s:10:"image/jpeg";}s:29:"woocommerce_gallery_thumbnail";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:100;s:6:"height";i:100;s:9:"mime-type";s:10:"image/jpeg";}s:12:"shop_catalog";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:300;s:6:"height";i:300;s:9:"mime-type";s:10:"image/jpeg";}s:11:"shop_single";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:600;s:6:"height";i:536;s:9:"mime-type";s:10:"image/jpeg";}s:14:"shop_thumbnail";a:4:{s:4:"file";s:24:"<@SGROUP@>-<@KEY@>.jpg";s:5:"width";i:100;s:6:"height";i:100;s:9:"mime-type";s:10:"image/jpeg";}}s:10:"image_meta";a:12:{s:8:"aperture";s:1:"0";s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";s:1:"0";s:9:"copyright";s:0:"";s:12:"focal_length";s:1:"0";s:3:"iso";s:1:"0";s:13:"shutter_speed";s:1:"0";s:5:"title";s:0:"";s:11:"orientation";s:1:"0";s:8:"keywords";a:0:{}}}'
)
@@GO@@ 
IF select count(1) from <@PREFIX@>terms where '<@SGROUP@>' = 'products_image_small'
@@GO@@
update <@PREFIX@>postmeta
set meta_value =  concat(meta_value,if(coalesce(meta_value,'')='','',',')  ,(select id from <@PREFIX@>posts where post_type = 'attachment' and post_name = '<@SGROUP@>-<@KEY@>'  )) 
where post_id  = <@KEY@>
and meta_key ='_product_image_gallery'
@@GO@@
update <@PREFIX@>postmeta
set meta_value =  (select id from <@PREFIX@>posts where post_type = 'attachment' and post_name = '<@SGROUP@>-<@KEY@>'  ) 
where post_id  = <@KEY@>
and meta_key ='_thumbnail_id'
@@GO@@
	