This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
explain analyze SELECT | |
count(1) AS count | |
FROM | |
merlin.merlin_templates t | |
INNER JOIN merlin.merlin_keywords k ON t.id = k.merlin_template_id | |
WHERE | |
t.enabledstatus = 1 | |
AND t.disabled = 0 | |
AND k.keyword @@ to_tsquery('red|blue') | |
AND product_id = 1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[Session] | |
; Handler used to store/retrieve data. | |
; http://php.net/session.save-handler | |
session.save_handler = files | |
; Argument passed to save_handler. In the case of files, this is the path | |
; where data files are stored. Note: Windows users have to change this | |
; variable in order to use PHP's session functions. | |
; | |
; The path can be defined as: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#include <stdio.h> | |
#include <stdlib.h> | |
struct node { | |
int num; | |
struct node *next; | |
struct node *prev; | |
}; | |
struct node *create(int num) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- SQL Script to remove all booklet entries and schema. | |
-- item.type range is 251 - 280 | |
-- revrec sku cat ids are 92 - 121 | |
-- Product types are 'booklets-85x11' and 'booklets-55x85' | |
BEGIN; | |
-- Delete Booklet entries from migration_log | |
DELETE FROM migration_log WHERE patch_file IN ( | |
'option.sql', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- SQL Script to remove all booklet entries and schema. | |
-- item.type range is 251 - 280 | |
-- revrec sku cat ids are 92 - 121 | |
-- Product types are 'booklets-85x11' and 'booklets-55x85' | |
BEGIN; | |
-- Delete Booklet entries from migration_log | |
DELETE FROM migration_log WHERE patch_file IN ( | |
'option.sql', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- SQL Script to remove all booklet entries and schema. | |
-- item.type range is 251 - 280 | |
-- revrec sku cat ids are 92 - 121 | |
-- Product types are 'booklets-85x11' and 'booklets-55x85' | |
BEGIN; | |
-- Delete Booklet entries from migration_log | |
DELETE FROM migration_log WHERE patch_file IN ( | |
'option.sql', |
NewerOlder