[3.3.5] [Quest] The Left Piece of Lord Valthalak's Amulet

[ghost]

TrinityCore rev. 014040b66214 2014-03-17 15:02:58 -0400 (master branch)
http://www.wowhead.com/quest=8968/the-left-piece-of-lord-valthalaks-amulet

Use the Brazier of Beckoning to summon forth Jarien and Sothos and slay them. Return to Bodley inside Blackrock Mountain with the Left Piece of Lord Valthalak's Amulet and the Brazier of Beckoning.

16046 Jarien and Sothos Trigger
16101 Jarien
16103 Spirit of Jarien
16102 Sothos
16104 Spirit of Sothos

You can't place the Brazier of Beckoning in The Crimson Throne inside Strathholme.

[dr-j]

I did fix this whole chain will have to find script out and make some changes as at that time Lord Valthalak was scripted in eai but has since been scripted in cpp and I did a eai to sai conversion but since was converted to cpp that was no longer needed,

Anyway will try and find script but did get Brazier of Invocation and Brazier of Beckoning to spawn Mor Grayhoof, Isalien, Jarien and Sothos, Kormok and Lord Valthalak when used in appropriate location,

If I remember the spell focus object to spawn most of these bosses is missing but which bosses you need to kill for chain depends on class.

I will provide script for the braziers for this shortly as still need to make some changes to sql as writ this like 10 months ago but for teasers

http://youtu.be/BZcgXXgL11M Mor Grayhoof
http://youtu.be/EQt1VIC5Bzg Isalien
http://youtu.be/1zn9ALOfHMU Jarien and Sothos
http://youtu.be/x-bQbc38ABA Kormok

Some of these bosses are already scripted in cpp just did not spawn other had no script,

[dr-j]

Ok I have not included script for any bosses here as I know those should be in cpp, the below just deals with the brazier of beckoning / brazier of invocation spawning the npcs both need a different spell focus,

Spawns the TEMP The Crimson Throne spell focus to spawn Jarien and Sothos
Spawns the TEMP Haunted Locus which are not spawned but are needed as the spell focus for Brazier of Invocation to work which is the reward once you have completed chain once so you can summon any of the bosses including the ones your class did not have to do in chain

SET @Guid := 14218;

UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI', `ScriptName`='' WHERE  `entry`IN(181045,181051);
DELETE FROM `smart_scripts` WHERE `source_type`=1 AND `entryorguid`IN(181045,181051);

DELETE FROM `gameobject` WHERE `id` IN(181096,181048);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES 
(@Guid,181096,429,1,1,263.38,-452.69,-119.96,0,0,0,0,0,180,0,1),
(@Guid+1,181096,229,1,1,-23.97,-451.98,-18.64,0,0,0,0,0,180,0,1),
(@Guid+2,181096,289,1,1,-3.82,141.88,83.9,0,0,0,0,0,180,0,1),
(@Guid+3,181096,229,1,1,25.92,-537.7,110.93,0,0,0,0,0,180,0,1),
(@Guid+4,181096,329,1,1,3423.47,-3055.73,136.499,6.00568,0,0,0.138306,-0.990389,300,0,1),
(@Guid+5, 181048, 329, 1, 1, 3423.47, -3055.73, 136.499, 6.00568, 0, 0, 0.138306, -0.990389, 300, 0, 1);

INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(181045, 1, 0 ,0, 11, 0, 100, 0, 0, 0, 0,0,45,1,1,0,0,0,0,10,45841,16044,0,0,0,0,0, 'Brazier of Beckoning - On Spawn - Set Data Mor Grayhoof Trigger'),
(181045, 1, 1 ,0, 11, 0, 100, 0, 0, 0, 0,0,45,1,1,0,0,0,0,10,48937,16047,0,0,0,0,0, 'Brazier of Beckoning - On Spawn - Set Data Kormok Trigger'),
(181045, 1, 2 ,0, 11, 0, 100, 0, 0, 0, 0,0,45,1,1,0,0,0,0,10,84386,16045,0,0,0,0,0, 'Brazier of Beckoning - On Spawn - Set Data Isalien Trigger'),
(181045, 1, 3 ,0, 11, 0, 100, 0, 0, 0, 0,0,45,1,1,0,0,0,0,10,53937,16046,0,0,0,0,0, 'Brazier of Beckoning - On Spawn - Set Data Jarien and Sothos Trigger'),
(181045, 1, 4 ,0, 11, 0, 100, 0, 0, 0, 0,0,45,1,1,0,0,0,0,10,137927,16048,0,0,0,0,0, 'Brazier of Beckoning - On Spawn - Set Data Lord Valthalak Trigger');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=181045;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(22, 1, 181045, 1, 0, 23, 1, 1583, 0, 0, 0, 0, 0, '', 'Brazier of Beckoning only run SAI in Blackrock Spire'),
(22, 2, 181045, 1, 0, 23, 1, 2057, 0, 0, 0, 0, 0, '', 'Brazier of Beckoning only run SAI in Scholomance'),
(22, 3, 181045, 1, 0, 23, 1, 2557, 0, 0, 0, 0, 0, '', 'Brazier of Beckoning only run SAI in Dire Maul'),
(22, 4, 181045, 1, 0, 23, 1, 2017, 0, 0, 0, 0, 0, '', 'Brazier of Beckoning only run SAI in Stratholme'),
(22, 5, 181045, 1, 0, 23, 1, 1583, 0, 0, 0, 0, 0, '', 'Brazier of Beckoning only run SAI in Blackrock Spire');

INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(181051, 1, 0 ,0, 11, 0, 100, 0, 0, 0, 0,0,45,1,1,0,0,0,0,10,45841,16044,0,0,0,0,0, 'Brazier of Invocation - On Spawn - Set Data Mor Grayhoof Trigger'),
(181051, 1, 1 ,0, 11, 0, 100, 0, 0, 0, 0,0,45,1,1,0,0,0,0,10,48937,16047,0,0,0,0,0, 'Brazier of Invocation - On Spawn - Set Data Kormok Trigger'),
(181051, 1, 2 ,0, 11, 0, 100, 0, 0, 0, 0,0,45,1,1,0,0,0,0,10,84386,16045,0,0,0,0,0, 'Brazier of Invocation - On Spawn - Set Data Isalien Trigger'),
(181051, 1, 3 ,0, 11, 0, 100, 0, 0, 0, 0,0,45,1,1,0,0,0,0,10,53937,16046,0,0,0,0,0, 'Brazier of Invocation - On Spawn - Set Data Jarien and Sothos Trigger'),
(181051, 1, 4 ,0, 11, 0, 100, 0, 0, 0, 0,0,45,1,1,0,0,0,0,10,137927,16048,0,0,0,0,0, 'Brazier of Invocation - On Spawn - Set Data Lord Valthalak Trigger');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=181051;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(22, 1, 181051, 1, 0, 23, 1, 1583, 0, 0, 0, 0, 0, '', 'Brazier of Invocation only run SAI in Blackrock Spire'),
(22, 2, 181051, 1, 0, 23, 1, 2057, 0, 0, 0, 0, 0, '', 'Brazier of Invocation only run SAI in Scholomance'),
(22, 3, 181051, 1, 0, 23, 1, 2557, 0, 0, 0, 0, 0, '', 'Brazier of Invocation only run SAI in Dire Maul'),
(22, 4, 181051, 1, 0, 23, 1, 2017, 0, 0, 0, 0, 0, '', 'Brazier of Invocation only run SAI in Stratholme'),
(22, 5, 181051, 1, 0, 23, 1, 1583, 0, 0, 0, 0, 0, '', 'Brazier of Invocation only run SAI in Blackrock Spire');

UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE  `entry`=16044;

DELETE FROM `smart_scripts` WHERE `entryorguid` =16044;
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
(16044, 0, 0, 0, 38,  0, 100, 1, 1, 1, 0, 0, 12, 16080, 8, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof Trigger - On Data Set - Spawn Mor Grayhoof');

UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE  `entry`=16045;

DELETE FROM `smart_scripts` WHERE `entryorguid` =16045;
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
(16045, 0, 0, 0, 38,  0, 100, 1, 1, 1, 0, 0, 12, 16097, 8, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Isalien Trigger - On Data Set - Spawn Isalien');

UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE  `entry`=16046;

DELETE FROM `smart_scripts` WHERE `entryorguid` =16046;
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
(16046, 0, 0, 1, 38,  0, 100, 1, 1, 1, 0, 0, 12, 16101, 8, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Jarien and Sothos Trigger - On Data Set - Spawn Jarien'),
(16046, 0, 1, 0, 61,  0, 100, 1, 1, 1, 0, 0, 12, 16102, 8, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Jarien and Sothos Trigger - Linked with Previous Event - Spawn Sothos');

UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE  `entry`=16047;

DELETE FROM `smart_scripts` WHERE `entryorguid` =16047;
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
(16047, 0, 0, 0, 38,  0, 100, 1, 1, 1, 0, 0, 12, 16118, 8, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Kormok Trigger - On Data Set - Spawn Kormok');

UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE  `entry`=16048;

DELETE FROM `smart_scripts` WHERE `entryorguid` =16048;
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
(16048, 0, 0, 0, 38,  0, 100, 1, 1, 1, 0, 0, 12, 16042, 8, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Lord Valthalak Trigger - On Data Set - Spawn Lord Valthalak');

[ghost]

Awesome. : ) On my next restart I will check this out. Thanks for the hard work.

[ghost]

SET @Guid := XXXX;
SET @Guid := 84892;

I used the un-used guid finder to find a free game object. Just making sure I did that right ?

[ghost]

The brazier spawned Mor Grayhoof correctly in Blackrock Spire Lower but he is friendly and I can not attack him.

[ghost]

I summoned Jarien and Sothos correctly but I had to remove the other quest or the Brazier would not work correctly which was fine. They spawned and were not friendly. I killed them both and completed that part of the quest.

[dr-j]

make sure you are using right quest item http://www.wowhead.com/item=22051

As each quest as different Brazier of Beckoning item which works for specific boss only

If it says you are need to be Blackrock spire you are using the version of the Brazier which is meant to summon either Lord Thalthalek or Mor Grayhoof.

[ghost]

Yeah I had to remove and retake the quests and the Brazier worked correctly.

When Mor Grayhoof is spawned he is friendly though and I can not kill him. Everything else is working as you intended.

[dr-j]

this scripts mor grayhoof however this should be in cpp as is classified as boss

   UPDATE `creature_template` SET `AIName`= 'SmartAI',`mechanic_immune_mask`=605932 WHERE  `entry`=16080;

   DELETE FROM `smart_scripts` WHERE `entryorguid` =16080;

   INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
   (16080, 0, 0, 0, 11,  0, 100, 0, 0, 0, 0, 0, 2, 40, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - On Spawn - Set Faction'),
   (16080, 0, 1, 0, 2,  0, 100, 0, 50, 100, 10000, 20000, 11, 27545, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - On Agro - Cast Cat Form'),
   (16080, 0, 2, 0, 2,  0, 100, 0, 25, 50, 10000, 20000, 11, 27543, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - On Between 25 and 50% HP - Cast Bear Form'),
   (16080, 0, 3, 0, 2,  0, 100, 0, 0, 25, 10000, 20000, 11, 27546, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - On Between 0 and 25% HP - Cast Faerie Dragon Form'),
   (16080, 0, 4, 5, 2,  0, 100, 0, 0, 75, 12000, 15000, 28, 27545, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - On Less than 30% HP - Remove Cat Form'),
   (16080, 0, 5, 6,61,  0, 100, 0, 0, 0, 0, 0, 28, 27543, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - Linked with Previous Event - Remove Bear Form'),
   (16080, 0, 6, 7,61,  0, 100, 0, 0, 0, 0, 0, 28, 27546, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - Linked with Previous Event - Faerie Dragon Form'),
   (16080, 0, 7, 0,61,  0, 100, 0, 0, 0, 0, 0, 11, 27532, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - Linked with Previous Event - Cast Rejuvenation'),
   (16080, 0, 8, 0, 0,  0, 100, 0, 3000, 7000, 7000, 11000, 11, 27555, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - IC - Cast Shred (Cat)'),
   (16080, 0, 9, 0, 0,  0, 100, 0, 2000, 5000, 5000, 9000, 11, 27556, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - IC - Cast Rake (Cat)'),
   (16080, 0, 10, 0, 0,  0, 100, 0, 0, 0, 30000, 30000, 11, 27551, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - IC - Cast Demoralizing Roar (Bear)'),
   (16080, 0, 11, 0, 9,  0, 100, 0, 0, 10, 3000, 5000, 11, 27554, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - IC - Cast Swipe (Bear)'),
   (16080, 0, 12, 0, 9,  0, 100, 0, 0, 10, 5000, 25000, 11, 27530, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - IC - Cast Hurricane (Non Shited)'),
   (16080, 0, 13, 0, 0,  0, 100, 0, 0, 5000, 5000, 20000, 11, 27737, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - IC - Cast Moonfire (Non Shited)'),
   (16080, 0, 14, 0, 2,  0, 100, 0, 0, 85, 5000, 20000, 11, 27527, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - IC - Cast Healing Touch (Non Shited)'),
   (16080, 0, 15, 0, 9,  0, 100, 0, 0, 5, 8000, 13000, 11, 27553, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - IC - Cast Maul (Bear)'),
   (16080, 0, 16, 0, 9,  0, 100, 0, 0, 5, 5000, 9000, 11, 27557, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Mor Grayhoof - IC - Cast Ferocious Bite (Cat)');

   DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=16080;

   INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
   (22,17, 16080, 0, 0, 1, 1, 27545, 0, 0, 0, 0, 0, '', 'Mor Grayhoof only casts Ferocious Bite in Cat form'),
   (22,16, 16080, 0, 0, 1, 1, 27543, 0, 0, 0, 0, 0, '', 'Mor Grayhoof only casts Maul in Bear form'),
   (22, 9, 16080, 0, 0, 1, 1, 27545, 0, 0, 0, 0, 0, '', 'Mor Grayhoof only casts Shred in Cat form'),
   (22,10, 16080, 0, 0, 1, 1, 27545, 0, 0, 0, 0, 0, '', 'Mor Grayhoof only casts Rake in Cat form'),
   (22,11, 16080, 0, 0, 1, 1, 27543, 0, 0, 0, 0, 0, '', 'Mor Grayhoof only casts Demoralizing Roar in Bear form'),
   (22,12, 16080, 0, 0, 1, 1, 27543, 0, 0, 0, 0, 0, '', 'Mor Grayhoof only casts Swipe in Bear form'),
   (22,13, 16080, 0, 0, 1, 1, 27545, 0, 0, 1, 0, 0, '', 'Mor Grayhoof does not cast Hurricane in Cat form'),
   (22,13, 16080, 0, 0, 1, 1, 27543, 0, 0, 1, 0, 0, '', 'Mor Grayhoof does not cast Hurricane in Bear form'),
   (22,13, 16080, 0, 0, 1, 1, 27546, 0, 0, 1, 0, 0, '', 'Mor Grayhoof does not cast Hurricane in Faerie Dragon Form'),
   (22,14, 16080, 0, 0, 1, 1, 27545, 0, 0, 1, 0, 0, '', 'Mor Grayhoof does not cast Moonfire in Cat form'),
   (22,14, 16080, 0, 0, 1, 1, 27543, 0, 0, 1, 0, 0, '', 'Mor Grayhoof does not cast Moonfire in Bear form'),
   (22,14, 16080, 0, 0, 1, 1, 27546, 0, 0, 1, 0, 0, '', 'Mor Grayhoof does not cast Moonfire in Faerie Dragon Form'),
   (22,15, 16080, 0, 0, 1, 1, 27545, 0, 0, 1, 0, 0, '', 'Mor Grayhoof does not cast Healing Touch in Cat form'),
   (22,15, 16080, 0, 0, 1, 1, 27543, 0, 0, 1, 0, 0, '', 'Mor Grayhoof does not cast Healing Touch in Bear form'),
   (22,15, 16080, 0, 0, 1, 1, 27546, 0, 0, 1, 0, 0, '', 'Mor Grayhoof does not cast Healing Touch in Faerie Dragon Form');

[Aokromes]

Can you change the old spell focus ids to the new ones? Thx. 300061 now is 181048 but with 300064 we have SELECT * FROM gameobject_template WHERE data0 LIKE '%1359%' LIMIT 0, 1000