groggu

SELECT
	wp_posts.ID AS 'Post ID' ,
	wp_posts.post_title AS 'Post Title' ,
	group_concat(
		DISTINCT wp_terms.`name` SEPARATOR ', '
	) AS 'Tags'
FROM
	wp_term_relationships
JOIN wp_posts ON wp_term_relationships.object_id = wp_posts.ID
JOIN wp_term_taxonomy ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id

groggu

#Click details for last 7 days
SELECT
	wp_posts.post_title as 'Link Name' ,
	wp_ta_link_clicks.date_clicked ,
	ip.meta_value as 'User IP Address',
	redirect.meta_value as 'Affiliate Link',
	cloaked.meta_value as 'Cloaked Link'
FROM
	wp_ta_link_clicks
	JOIN wp_posts ON wp_ta_link_clicks.link_id = wp_posts.ID

groggu

<?php
/*
 * Developed by Greg Croasdill
 * Developed for Porto v3.1.8
 * Sept 25, 2019
 *
 * For use with the Porto Themes (ThemeForest - http://bit.ly/2lAwRR2 or https://www.portotheme.com)
 *
 * Please read the Proto documentation to understand how to setup your selected Porto Theme.
 *

groggu

/**
 * Magento Enterprise Edition
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Magento Enterprise Edition End User License Agreement
 * that is bundled with this package in the file LICENSE_EE.txt.
 * It is also available through the world-wide-web at this URL:
 * http://www.magento.com/license/enterprise-edition
 * If you did not receive a copy of the license and are unable to

groggu

<?php
/*
All extended shortcode class are extended from the helper class - Fishpig_Wordpress_Helper_Shortcode_Abstract 

There are two abstract functions you must implement

public function getTag() 

this functions defines [tagname].

groggu

    /***
     * Convert standard ISO country codes to NetSuite's world
     *
     * @param $isoCode
     *
     * @return string|bool
     */

    public function convertCountryCode($isoCode)
    {

groggu

//assumes you are using the PHPToolKit and have already

  require_once 'lib/NetSuite/NetSuiteService.php';
  $service = new NetSuiteService();

  //if you have the internal ID
    $request = new GetRequest();
    $request->baseRef = new RecordRef();
    $request->baseRef->internalId = $nsOrderId;
    $request->baseRef->type = "salesOrder";

groggu

//assumes you are using the PHPToolKit and have already
// require_once 'lib/NetSuite/NetSuiteService.php';
    private function _getNsPromoCode($magePromoCode){

        $service = new NetSuiteService();

        //get the ID of the coupon by code
        $searchData = new SearchStringField();
        $searchData->operator = "is";
        $searchData->searchValue = $magePromoCode;

groggu

SELECT 
    parent.sku as 'sku',
    eav.attribute_code as 'configurable_attribute',
    GROUP_CONCAT(child.sku SEPARATOR ',') as 'simples_skus' 
FROM catalog_product_super_link 
    INNER JOIN catalog_product_entity as child ON catalog_product_super_link.product_id = child.entity_id
    INNER JOIN catalog_product_entity as parent ON catalog_product_super_link.parent_id = parent.entity_id
    INNER JOIN catalog_product_super_attribute as super ON  super.product_id = parent.entity_id
    INNER JOIN eav_attribute as eav ON eav.attribute_id = super.attribute_id
Group By parent.sku

groggu

#!/bin/bash

IGNORE_TABLES=( dataflow_batch_export dataflow_batch_import log_customer log_quote log_summary log_summary_type log_url log_url_info log_visitor log_visitor_info log_visitor_online report_viewed_product_index report_compared_product_index report_event index_event enterprise_logging_event_changes )
CONFIG_FILE="./app/etc/local.xml"
IGNORE_STRING=""
TMP_FILE="./var/.tmp.local.xml"

if [ ! -f "$CONFIG_FILE" ]; then
  echo "$CONFIG_FILE does not exist"
  exit