SELECT * FROM `SquareItems` WHERE (SquareItems.active = 1 AND SquareItems.custom_active = -1 OR SquareItems.custom_active = 1) AND (SquareItems.last_square_price > 0 OR SquareItems.custom_price_marked_up > 0 OR SquareItems.custom_price_marked_up = 0 AND SquareItems.price_marked_up > 0) AND SquareItems.deleted = 0 AND SquareItems.store_active > 0 AND (REPLACE(REPLACE(name, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(custom_name, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(description, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(custom_description, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(category, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(newcat, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(custom_newcat, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(subcat, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(custom_subcat, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(manufacturer, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(custom_manufacturer, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(square_sku, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(upc, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(custom_upc, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(sku, ' ', ''),'-', '') LIKE '%%' OR REPLACE(REPLACE(custom_sku, ' ', ''),'-', '') LIKE '%%' OR MATCH(name, manufacturer, category, subcat, newcat, description, custom_name, custom_description, custom_newcat, custom_subcat, custom_manufacturer) AGAINST ('' IN NATURAL LANGUAGE MODE)) ORDER BY deleted, ((LOWER(name) LIKE '%rtr%' OR LOWER(custom_name) LIKE '%rtr%') OR (LOWER(category) LIKE '%vehicles%' OR LOWER(category) LIKE 'r/c%' OR LOWER(category) LIKE 'rc%' OR (LOWER(category) LIKE '%drag race%' AND LOWER(subcat) like '%cars%')) OR (LOWER(custom_newcat) LIKE '%vehicles%' OR LOWER(custom_newcat) LIKE 'r/c%' OR LOWER(custom_newcat) LIKE 'rc%' OR (LOWER(custom_newcat) LIKE '%drag race%' AND LOWER(subcat) like '%cars%'))) AND LOWER(if(custom_newcat != '', custom_newcat, category)) NOT LIKE '%accessories%' AND LOWER(if(custom_newcat != '', custom_newcat, category)) NOT LIKE '%parts%' DESC, squareInventory > 0 DESC, if(custom_name = '', lower(name),lower(custom_name)) ASC LIMIT 20 OFFSET 0

All Products

'>